WORKAROUND:
To see if there is members, this query would be ran against your ArchiveManager database:
SELECT * FROM [Group] AS G WITH (NOLOCK)
JOIN LoginGroup AS LG WITH (NOLOCK) ON G.GroupID = LG.GroupID
JOIN Login AS L WITH (NOLOCK) ON LG.LoginID = L.LoginID
WHERE G.Name = 'groupname'
If you get results, it indicates the group has members in Archive Manager.
Another way to tell is if you click Edit beside the group (blue button) from within the Archive Manager WebUI you will see if it has members.
To delete groups that have members:
1. Take the GroupID from the results of the above query.
2. Run the following against your ArchiveManager database:
delete from LoginGroup where GroupID=xx
Replace the XX with the GroupID number you received from the 1st query above.
3. After the references have been deleted, you can go into the Web UI and click on the Red X to delete the group.
Note:
The information in the script(s) provided is known to work successfully; however, they have not been officially tested by Quest Software Quality Control. If any of these instructions are changed and/or incorrectly used, intentionally or unintentionally, this solution becomes unsupported by Quest Software Support and Development.
Quest Software Support and Development recommend to always make a backup of the current database prior to execution of any script(s) that may modify it.
For customization of the Archive Manager, please contact our Professional Services Organization: http://www.quest.com/professional-services/
