AD Reporting
Active Directory User Import
Do you need to import users into Active Directory in bulk? Want to Automate user creation, updates and deletion? Do you need to make bulk changes to existing Active Directory users?
AD Bulk Users makes importing and modifying large numbers of users easy. Import users in bulk from CSV, Excel, SQL, MySQL and Oracle. Use the built-in scheduler to fully automate the import, update and removal of your Active Directory users. Create home folders, profile folders and mailboxes.
Choose a license
Product Name |
SKU |
ID |
Price (USD) |
AD Toolset Single Administrator License | ADTSSA | 16538 | $299.00 |
AD Toolset Site License | ADTSSL | 16539 | $499.00 |
AD Toolset Multiple Site License | ADTSMSL | 16540 | $799.00 |
AD Toolset Three Administrator License | ADTS3A | 16541 | $399.00 |
Choose Maintanance Plan
Maintenance Option |
SKU |
ID |
Price (USD) |
1 Year Maintenance (Support and Updates) | 1YR | 16518 | $0.00 |
2 Year Maintenance (Support and Updates) | ADTSSA2Y | 16625 | $99.00 |
3 Year Maintenance (Support and Updates) | ADTSSA3Y | 16810 | $198.00 |
AD Reporting is a reporting tool for Active Directory. AD Reporting contains a large number of pre-built reports plus a built-in scheduler allows you to automate reports on Users, Computers, Groups, Passwords and Office 365 on a hourly, daily, weekly or monthly basis.
Active Directory Reporting, automated, simplified and powerful. Produce awesome reports in minutes.
Do you need to find the true last login time for users and computer accounts? Do you need to receive a report of users who haven’t logged on in the last 30 days? Do you need to automatically disable accounts that haven’t logged on in 60 days?
- Helps with SOX compliance and IT security reports
- Retrieve account status and the true last logon time
- Create custom reports
- Locate the true last logon time of users and computers
- Export and Email Reports in
- CSV, Excel, Word and PDF
- Automate reports & perform actions
- hourly, daily, weekly or monthly
- Identify accounts in need of attention, e.g. disabled, locked, never logged on, or with non-expiring passwords.
- Command line operation
- Pre-built reports, example
- e.g. ‘List all users created this month’
- e.g. ‘List all users that have never logged on’
- e.g. ‘List Groups with no members’
- e.g. ‘List Office 365 licensed users’
- Perform bulk actions
- Disable & Enable objects
- Delete objects
- Move objects
- Add or Remove from groups
- Remove from all groups
- Set expiry date
Actions can be applied to users or computers. For example, you can disable users who have not logged on in 60 days or you could move all computers which haven’t been used in 90 days to a specific OU. Actions can be used within the scheduler so you can run a weekly report for users that have not logged on in 30 days and disable their accounts before removing them from all groups after 90 days.
When querying Active Directory using the lastLogon column the program will query each domain controller for the most recent lastLogon time, you can click the cell to see the time the user last authenticated against each Domain Controller.
AD Reporting has a built-in scheduler that you can use to perform hourly, daily, weekly, monthly or one-off reports and exports. The scheduler can send the report results via email and also perform actions on the results such as disabling, deleting, moving etc.
Create custom reports, for example, locate all users in California who haven’t logged on in the last 20 days or computers running older versions of Windows that have logged on in the 30 days.
There are many pre-built reports covering Users, Passwords, Computers, Groups and Office 365.
Reports can be sent via email in CSV, Excel, Word or PDF format. A Windows service handles all the scheduled reports in the background so the computer can be logged off.
Office 365 Reports
To use the reports for Office 365 the software below is required.
Install the 64-bit version of the Microsoft Online Services Sign-in Assistant:
Microsoft Online Services Sign-in Assistant for IT Professionals RTW.
Install the 64-bit version of the Windows Azure Active Directory Module for Windows PowerShell:
Windows Azure Active Directory Module for Windows PowerShell (64-bit version).
Importing users into Active Directory (CSV, Excel)
The import file can be formatted using the CSV (comma separated value) format or Excel XLS and XLSX.
The column headers in your file (CSV,XLS,XLSX) should contain the name of the Active Directory Attribute you want to add the data to. A list of column headers/attributes can be found below. The columns can be in any order and the column headers are not case sensitive but obviously must be spelt correctly for the program to recognize them, if it comes across a column it doesn’t recognize it will ignore that column.
In the example shown below I’m using Excel to construct the file and using wildcards to speed up the creation of the file. The first row (1) contains the column headers, these are the attribute names such as givenName (first name). You don’t need to use all the attributes names just those you need, the minimum required to create a new users are shown below. This example file would create 5 new users.
Using MS SQL, My SQL or Oracle as your data source
Updating Existing Active Directory User Accounts
Command Line Arguments
USING Wildcards
USING HOME FOLDERS
TEMPLATE DOWNLOADS & VIDEO GUIDES
More Details and Information
List of supported Active Directory Attributes
Click here for a list of Active Directory attributes supported that you can use by default. More can be added including custom attributes.
You can add custom or unlisted attributes via the Attributes button on the Settings tab.
Download Templates
Below you can download several example CSV and Excel templates to help you get started.
Sample CSV/XLS Template Files
Need to export your existing usernames?
AD Bulk Users is compatible with AD Bulk Export which is ideal for migrations, creating test domains etc.
What other customers are saying
It Works Great!
“Its working great!! Love it has saved me hours of work!!”
An Excellent Tool!
“I would like to say a word about your product. It’s an excellent tool. It saved my time a lot during the beginning of the academic to create the new AD account as well as the email account and clear the leavers. Great Job !!!!!”
It Works Great!
“Its working great!! Love it has saved me hours of work!!”
Has been a real time saver!
“Although a user of AD Bulk Users (and the other tools) for some time now, I have only just harnessed the power of the scheduler part of the system. Previously I thought the software was superb, but this feature takes it to another level, saving us even more time than before..”