Here are some reports that I’ve created to help our technical support team with the management of users accounts in active directory. This allows them to get the following information about users (also note that this has been tested in a single AD (DFL 2003) domain and Sccm 2007 sp2);
So the first report will give you a count of users by status, Enable, Disable, Password Set to never Expired, Account Expired and Stale Account ( which as exceed their threshold of 90 days). Also, with the ability to get a list of all user accounts with a specific status, ex; all expired Account or All users account with password set to never expired.
And the second report will count users by OU, with the ability to drill down and get the users informations in the selected OU and then get the group membership by Users.
Count user accounts in a specific state
All Users in a specific state
User Accouts by OU
All Users in the selected OU
Group Membership for a selected user
So here’s the queries
FirstReport, (contains queries for the two reports)
SecondReports, (contains queries for the three reports)
**** user discovery must be enable with all these attributes ****