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;