All Active Directory reports under Reports menu are customizable. To customize a report first select and run a report.
After the report is rendered select Add/Remove Column button
Type in the attribute text box to filter the attributes and select and move the attribute to right
The report will update and will show the new column.
The report will keep the attribute next time you run the same report.
How About Running the same Report with New Attributes and Saving it? |
Run the report and add attributes as mentioned above and select Export or Schedule button
Copy the SQL
Click on the tool bar SQL button
Paste the sql, select the spreadsheet layout and click on the run button
Click on the Save SQL button to save the sql or recall it using the show History button or Open SQL button