Reference user

[youssef_anegay3]

Hello all

is there a way to identify (via sql statement) all users that have a reference user in IdM 7.2 ? (the field shown in the screeshot)

thanks

Y.

[former_member198652 · Accepted solution]

Hi Youssef,

You can try this simple query to get all the users who have reference user.

select distinct mskey from idmv_vallink_basic where mcAttrName='MX_REFERENCE_USER'

if you wanted to get the reference user is test s_test then,  use below query

select distinct mskey from idmv_vallink_basic where mcAttrName='MX_REFERENCE_USER' and mcValue='mskey'

where mskey is the mskey of the ‘reference user (test s_test)mskey’

Regards,

Jaya

[youssef_anegay3 · Accepted solution]

hello Jaya

thanks! that was it ... i have change slightly your sql to have the login id instead of the mskey:

select distinct b.mcMSKEYVALUE  from idmv_vallink_basic a, mxi_entry b with (nolock) where a.mcAttrName='MX_REFERENCE_USER'

and a.mskey=b.mcMSKEY

[former_member2987]

Hi Youssef,

If you look up that user in the database, you should be able to see the linkage.

My assumption is that it should be in the MX_REFERENCE_USER attribute:

MX_REFERENCE_USER User reference Entry reference Single ReferenceUser Reference to MX_PERSON only. System specific user ids.

I got this information from the IDM Schema document

From here you should be able to generate a query...

Hope it helps you.

Regards,

Matt