Registration

Dear SAP Community Member,
In order to fully benefit from what the SAP Community has to offer, please register at:
http://scn.sap.com
Thank you,
The SAP Community team.
Skip to end of metadata
Go to start of metadata

Identity Center Database

For the identity center database following systems can be used:

  • MS SQL Server
  • Oracle

In order to retrieve information from the database e.g. within tasks SQL queries are requied. Therefore a basic understanding of the SQL syntax is very helpful.

Common SQL Queries used

Get all attributes for a defined MSKEY


SELECT *	FROM mxiv_sentries WHERE MSKEY=<MSKEY>

Concerned about the Logging foo? Here are five ways to find the most log intensive tasks in SAP IDM

  • No labels