Version: 2.6
The report shows domain groups and theirs Primary and Secondary owners. In order to collect secondary owners, Active Role Server should be configured.
Installation:
1. Extract the attached zip file
2. Backup existing database
3. Open SSMS, select the database, open and execute the attached 'Domain Groups with ARS secondary owner.sql; script
4. Make sure that ARS is installed and configured
5. Open Configuration Manager, Discovery Management, Configuration, Manage attributes collected by Enterprise Reporter, click Yes
6. Click 'Extend' button in the 'Active Roles' section
7. Set Domain, Active Role Server and Credentials
8. Select 'Group' in the 'Type' drop down menu
9. Find and extend the 'edsvaSecondaryOwners' attribute. Close the dialog.
10. Switch back to the SSMS
11. Find newly created tblDomainGroup_[GIUD] table
12. Copy the full name of the table.
13. Open Report Manager
14. Import the attached 'Domain Groups with ARS secondary owner.xrd' report into 'My Reports' category
15. Click 'Edit' and select 'Query' tab
16. Find [tblDomainGroup_GIUD] in the query and replace with the one copied from the database.
17. Validate the query and close the dialog.
18. Set input parameters and run the report.
