Active Identities SQL Query
This document (7100014) is provided subject to the disclaimer at the end of this document.
NetIQ Access Governance Suite
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;
This Support Knowledgebase provides a valuable tool for NetIQ/Novell/SUSE customers and parties interested in our products and solutions to acquire information, ideas and learn from one another. Materials are provided for informational, personal or non-commercial use within your organization and are presented "AS IS" WITHOUT WARRANTY OF ANY KIND.
- Document ID:7100014
- Creation Date:02-JUL-13
- Modified Date:07-AUG-13
- NetIQAccess Governance
Did this document solve your problem? Provide Feedback