When none of the ready-made reports fits, build your own. A custom report picks an object type, the columns you want and the conditions objects must meet, and is saved so you can run it again whenever you need it.
For example: enabled users in the Finance OU whose password hasn't changed in more than 180 days, with their name, manager and last logon.
Custom reports are under Reports > Custom Reports:
- New report: build a report.
- My reports: the reports you've built.
- Shared with me: reports other people have shared.
Build a report
- Go to Reports > Custom Reports > New report.
- Enter a Report Name, for example
Disabled users in Finance. - Choose who can see it: Private (only me) or Shared (everyone).
- Follow the three steps below, then select Save & view.
1. Object Type
Choose Users, Computers or Groups.
To limit the report to some OUs, select Browse… and choose them. OUs nested inside them are included. Leave it empty for the whole domain.
2. Choose Columns
Tick the attributes you want under Available Attributes. Use Search attributes... to find one quickly. Your custom attributes are in the list too.
The columns appear under Selected Columns in the order you add them. Drag them to change the order, or select × to remove one.
3. Conditions (Optional)
Conditions decide which objects are included. With no conditions, every object of that type is in the report.
- Select + Add Condition.
- Choose an attribute, a condition and a value. For example, Department, Equals,
Finance. - Add more conditions if you need them.
- Choose whether objects must meet ALL conditions or ANY condition.
Some useful conditions:
| Condition | Use it for |
|---|---|
| More than N days ago, on a date | Passwords not changed, or accounts not used, for a number of days. It moves with time, so the report stays correct whenever you run it. |
| Within the last N days, on a date | Accounts created or changed recently. |
| is a member of / is not a member of, on Member Of | Users in, or not in, a group. It matches the whole group name, so Administrators doesn't also match Enterprise Administrators. |
| Is empty / Is not empty | Missing data, such as users with no manager or no email address. |
Run a saved report
Go to Reports > Custom Reports > My reports or Shared with me, and select Open next to the report.
It runs against the latest synced data each time. You can search the results and Export them to Excel, CSV or PDF, like any other report.
To get a custom report by email on a schedule, choose it when you set up a scheduled report. It's listed under Custom reports.
Change or delete a report
On My reports, select Edit or Delete next to the report. You can also select Edit when the report is open.
Only the person who built a report can change or delete it. A shared report can be opened by everyone, but not changed.
Things to know
- Shared means everyone who can use reports in AD Pro Toolkit. It can't be shared with only some people.
- Your role still applies. If your role is limited to some OUs, a shared report only shows you objects in those OUs, even if the person who built it can see more.