Active Identities SQL Query

  • Document ID:7100014
  • Creation Date:02-Jul-2013
  • Modified Date:07-Aug-2013
    • Micro Focus Products:
      Access Governance

Environment


NetIQ Access Governance Suite

Situation

Active Identities SQL Query

Resolution

The following SQL Query allows for a user to see how many active accounts are inAccess Governance Suite and weeds out orphaned / inactive identites:

select count(distinct(spt_identity.id)) from spt_identity join spt_link on spt_link.identity_id = spt_identity.id where spt_identity.inactive = false;