Exporting the users

[Ckumar]

Anyway is there, to export all the users with assigned privileges whose account is enabled today?

[Former Member · Accepted solution]

select

     mcThisMskeyValue, mcOtherMskeyValue from idmv_link_ext with(nolock)

where

     mcThisOcName = 'MX_PERSON' and mcOtherOcName = 'MX_PRIVILEGE' and

     mcLinkState = 0 and mcThisMskey in

          (select mcMskey from idmv_entry_simple with(nolock) where mcCreated > '2013-10-17 00:00:00')

or variations of it for entries created today (on SQL Server atleast since you dont specify). Would look a bit different if you want to use hiredate or something else to define "enabled".

[Ckumar · Accepted solution]

Thanx for the help Per, i will check and let you inform .

Thanx again.

[former_member2987]

Chandan,

Yes you could create a job usnig the Identity Center as a source.  Depending on the format you need the information in, this could be pumped to HTML / ASCII, Database, LDAP/LDIF, etc.

Matt

[Ckumar]

Thanx Matt