Archive for the ‘Uncategorized’ Category

AD Bulk Users and thumbnailPhoto

Monday, June 21st, 2010

AD Bulk Users 3.3.1.5 is now available, in this incremental release it is now possible to import photos for into the thumbnailPhoto attribute, this has become popular recently with Microsoft using the thumbnailPhoto attribute in Outlook 2010. AD Bulk Users will check you are using a .jpg image and that the image size is smaller than 10KB and its dimensions are less than 96 x 96 pixels, whilst on the subject of photos it’s worth pointing out that support for the jpegPhoto attribute was added back in April this supports a bigger image (25KB and 200×200 pixels) but note this isn’t used by Outlook 2010.

Changing the sAMAccountName (logon name) in bulk

With this release it is now possible to change a users logon name by updating the sAMAccountName attribute (shown as ‘User logon name pre-Windows 2000′ in Active Directory Users and Computers), to change the logon name use a CSV file similar to the one below, add the new logon names to the newsAMAccountName column.

CSV file to change sAMAccountName

After the import the log will show the users logon names have been changed.

Log showing logon name change

As always if you have any questions or feature requests please get in touch.

AD Bulk Contacts 3.2 now supports Exchange 2010

Tuesday, January 12th, 2010

AD Bulk Contacts now includes support for Exchange 2010, note the Exchange 2010 management tools can only be installed on Windows 7, Vista SP2, Windows 2008 SP2, 2008 R2.

Exchange 2010 Support

Microsoft Technet article on how to Install the Exchange 2010 Management Tools:
http://technet.microsoft.com/en-us/library/bb232090.aspx

Using AD Bulk Users to update Exchange Storage Limits

Thursday, November 19th, 2009

In the latest build of AD Bulk Users we’ve added support setting the Exchange Storage Limits, these limits are stored in the attributes mDBStorageQuota (Issue warning at), mDBOverQuotaLimit (Prohibit send at) and mDBOverHardQuotaLimit (Prohibit send and receive at).

Exchange Storage Limits

The check box ‘Use mailbox store defaults’ shown above is toggled on and off using the attribute mDBUseDefaults, so to set non default storage limit we need to set mDBUseDefaults to FALSE. If you want to turn the default storage limits back on just set mDBUseDefaults to TRUE in the CSV file.

Below is an example CSV file that would set ‘Prohibit send and receive at (KB):’ to 1Gb, 2GB and 3GB for the 3 users in the file. The sAMAccountName is the users logon name and is used to locate the user in Active Directory, the Modify column tells the program we are modifying an existing user.

Storage Limits CSV

In my example above a 1Gb quota may be too low for some, if a user receives 100 x 50k messages a day for 30 days this would consume 150MB, or 1.8GB over a year.

All the best.

Automatically update e-mail addresses based on recipient policy?

Saturday, October 24th, 2009

When importing new users (or modifying existing users) with an Exchange mailbox  you may not want to have the Exchange recipient policy update the e-mail addresses for those users, by default when AD Bulk Users creates the mailbox ‘Automatically update e-mail addresses based on recipient policy’ is checked i.e. TRUE, to prevent this being set add a column to your CSV file entitled AutoUpdateOnRecipientPolicy and set the value to FALSE.

Click here for an example CSV file.

The result of setting AutoUpdateOnRecipientPolicy to FALSE is ‘Automatically update e-mail addresses based on recipient policy’ is unchecked meaning the recipient policy won’t update the mailbox for the user.

Automatically-update-e-mail-addresses-based-on-recipient-policy

All the best.

Append, Drop and Truncate with AD Bulk Export 3.0.7.2

Sunday, September 27th, 2009

This latest release of AD Bulk Export includes a couple of minor bug fixes and a change to the way saving to a SQL database can be done. Two new command line arguments have been added, these are /dropTable and /truncateTable, you can also enable these options via the GUI in the  ‘Options’ section of the ‘Save to Database’ window.

By default the data pulled from Active Directory will be appended to the table this can now be changed by using the command line arguments /dropTable or /truncateTable or by selecting either of  the two options in the GUI. By checking ‘Drop table first’ the program will delete the table and then recreate the table before inserting the data pulled from Active Directory. Checking ‘Truncate table first’ will delete the table rows but leave the columns intact, this is especially useful if you are going to add custom columns. Both options are retained when the program is closed and reopened.

AD Bulk Export, Saving to SQL