Skip to Content
author's profile photo Former Member
Former Member

How to select status of Provisioning from tables?

Hello Guru!

Please help me to understand how can I select from tables information about status of Provisioning?


I assigned role to user and see that it's in 'Pending' status now:

I want to find the reason of this from tables of IDM. And execute the following request:

select * from idmv_linkaudit_basic where usermskey in (select mcmskey from idmv_entry_simple where mcmskeyvalue='TEST')

assignmentmskey='169856' order by auditdate desc

Then I check table

select * from mxp_audit where auditid ='348048'

and see that status of Audit is 1100 = "Ok".

What I did wrong and how to select status and reason of "Pending" from tables?

Best regards,


pending.jpg (28.8 kB)
sel_aud.jpg (83.5 kB)
sel_aud2.jpg (70.8 kB)
Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

2 Answers

  • Best Answer
    Posted on Dec 23, 2013 at 08:28 AM

    If you select mcExecStateHierarchy from link tables what do you see then for the assignment?

    My notes show me that the value is 512 for "pending add" and 1536 "pending remove". (I don't have access to system where I could verify these.)

    Hopefully either of the Chris from Ireland or Chris from Norway will let us know if these are reliable values.

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Dec 19, 2013 at 11:53 AM

    Hello Natalia,

    I see you marked your thread as "Assumed answered". Could you please provide the solution for your question, so that other can find it, too? 😊



    Add a comment
    10|10000 characters needed characters exceeded

    • Hello Natalia,

      But my dream is to be able understand it via Tables.

      that's a pretty big dream. 😀

      Personally I find the IdM-tables not very accessible when it comes to understanding the different columns and values dealing with status of provisioning etc. To many numbers and not enough letters for my taste. *g*



Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.