I’ve recently started working on a new application, and like all of my other apps it will be completely free when it is complete. It is an Active Directory reporting tool that will allow you to easily query your AD domain and produce custom reports that you can view on screen and export to file.
There will be several predefined report queries ‘built in’ but you will also have the option to create your own custom query and tailor the output to suit your requirements.
UPDATE 04/12/2010: Click here for a list of the predefined queries and query-able attributes that I am planning to include: http://www.cjwdev.co.uk/../Info.html
click here for screenshots of how the app currently looks
and here for some videos
For the built in reports, the way I intend for it to work is as follows:
- Select the query you would like to run – this determines what the search will actually find, for example there would be a simple query that finds all disabled user accounts.
- Modify any optional parameters for the query so that it suits your needs, for example you might want to specify that the search only looks in one particular OU.
- Run the query and it brings back all of the accounts that matched the query criteria.
- You can optionally modify the account attributes that are included in the output, for example if you were running the “All Disabled Users” report you might decide that as well as the default attributes included in the output (which would be things like username, display name, email address etc), you also want to include a list of the groups that each user is a member of, or include the user’s last logon time, etc etc.
- Now that you can see the results of the query exactly as you want them, you can either simply read the data from the screen or you can save the results to file.
As for creating and running your own custom report, the 5 steps above would be identical but the difference would be that before you could even perform step 1 you would have to create your query. This would be done via a wizard that lets you specify which accounts should be found by the query – I intend to make this query builder as user friendly as possible but quite powerful at the same time. It will be easy and quick to build a simple query that just finds all computer accounts with an OS of Windows XP for example, but then you will also be able to build complex queries that combine several criteria, for example all user accounts that have not logged on for 30 days, are a member of a specific group, do not have an expired password and are not disabled. I can’t see any use for that particular query but you get the idea!
Oh and of course you will be able to save your custom queries so that you can run them whenever you want. I may even include some command line options so that you could automate the running of a specific report and then have it emailed to you each week or something. We will see… but if you like the sound of that feature then please let me know, because otherwise the chances are it wont end up in the very first version.
I cannot confirm yet precisely which file formats you will be able to export to (though .txt and .csv are pretty much guaranteed) or whether or not you will be able to print directly from the application, but I will post another entry on this blog once I have an update.
Let me know if you have any suggestions for features you would like to see as I will hopefully be able to get them in before the first release (as I did with a number of suggestions that people sent me for my AD Tidy application)