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