Produces an Excel report of active domain users including display name, title, office, department, and password status.
This script requires the ActiveDirectory, ImportExcel, OZO, and OZOAD PowerShell modules. The ActiveDirectory PowerShell module is included with the Remote Server Administration Tools (RSAT) for Windows feature installation. The remaining modules are published to PowerShell Gallery. Ensure your system is configured for this repository then execute the following in an Administrator PowerShell:
Install-Module ImportExcel,OZO,OZOADThis script is published to PowerShell Gallery. Ensure your system is configured for this repository then execute the following in an Administrator PowerShell:
Install-Script ozo-ad-active-users-reportozo-ad-active-users-report
-OutDir <String>| Parameter | Description |
|---|---|
OutDir |
Directory for the Excel report. Defaults to the current directory. |
Empty cells in the password status field indicates the password has never been set.
Special thanks to my employer, Sonic Healthcare USA, who supports the growth of my PowerShell skillset and enables me to contribute portions of my work product to the PowerShell community.