000028038 - How to list groups without any members?

Document created by RSA Customer Support Employee on Jun 15, 2016Last modified by RSA Customer Support Employee on Apr 21, 2017
Version 2Show Document
  • View in full screen mode

Article Content

Article Number000028038
Applies ToAuthentication Manager version 6.1
ACE/Server version 5.2
IssueHow to list groups without any members?
Determine groups with no members
List the groups without any members
There is no canned query or report to determine this information.
Resolution

A custom query using the following SQL SELECT statement will return all groups that have no members:

SELECT * from SDGroup where iGroupnum not in (SELECT iGroupnum FROM SDGroupMember)

Legacy Article IDa54676

Attachments

    Outcomes