Once you have run a report, you can export it to the Excel format.
1 |
2 |
3 |
On the Report tab, expand Report Library | Active Directory and select your first report, for example Domain Groups. |
4 |
5 |
Click Run Report. |
6 |
On the tool bar, click the Export To drop-down arrow, and choose XLS (older versions of Excel) or XLSX (Excel 2007 and later). |
9 |
Click Save. |
10 |
Click Yes to view the report in Excel. |
You need to modify an existing report to only show accounts that have been inactive for 90 days and are not disabled. You should manually run an appropriate Active Directory® discovery right before you run the report to ensure you are getting up to date data. This will allow you to address any issues before your compliance report is sent out. To do this, you must perform the following steps:
1 |
2 |
1 |
In the My Report container, select the Domain Users without Recent Logons report, and click Edit Report. |
2 |
Change the report name to Domain Users to be Disabled. |
3 |
Change the report description to Shows users in the selected domains who have not logged on in the past 90 days and whose accounts are still enabled. |
4 |
Select the Fields tab. |
5 |
6 |
Select the Parameters tab. |
7 |
Click +Add. |
8 |
9 |
10 |
11 |
Click OK. |
1 |
In the Edit Report dialog box, click the Layout tab. |
2 |
Click Edit. |
3 |
In the detailHeader row of the report layout, right-click Number of Logons, and select Delete then Cell. |
4 |
5 |
Repeat for all fields in the detailBand row of the report layout except Account Name and Last Logon (Domain User). |
6 |
Click the Preview tab below the report to ensure the new layout it is accurate: |
7 |
Click OK to close the Edit Report dialog box. |
8 |
Click OK to close the Edit Report Definition dialog box, and finish editing the report. |
1 |
If necessary, in the My Reports container, select the Domain Users to be Disabled report. |
2 |
3 |
4 |
To make these the default parameter values, click Save parameters as default, and click OK in the confirmation dialog box. |
5 |
Click Run report. |
1 |
On the Manage Discoveries page of the Configuration Manager, select the AD - [Domain Name] discovery you created, and click Edit. |
2 |
If necessary, click the Schedule tab. |
3 |
Click Monthly, and select the last Friday of the month. |
4 |
Click +Add. |
5 |
Click OK if you edited an existing discovery. |
© ALL RIGHTS RESERVED. Terms of Use Privacy Cookie Preference Center