Dec 29 2011

Export Sending Message Size Limits for users in Exchange 2003

Some companies love to set Sending Message Size Limits per user to avoid certain users from sending mail larger than the set limit on their Active Directory Account. (Please note that this is not the best practice and when used extensively will become a huge headache for you in the future)

If you need to report on the set sizes for users in your environment then I would recommend you use CSVDE to export the data from Active Directory to a CSV file.

The attribute in Active Directory that you are looking for is “submissionContLength”. You can see the set value in ADUC or using ADSIEDIT.

To change the allowed send limit per user go to: Active Directory Users and computers, find the user you want to set the limits for, right-click and choose properties, click on the Exchange General Tab, click on Delivery Restrictions and then click on Maximum KB under Sending Message Size and set the size limit. (as previously noted this is not recommended but helps when a user’s machine is infected with a virus so you can bring the message size down to zero KB to prevent the account from sending mail)

Now to the good stuff!

You need to report on who the users are that have custom set sending limits and what these limits are set to.

1. Login to your Exchange server and run the command prompt. (Start, Run, type cmd and press enter)
2. Type the following command to export users attributes in a certain OU:  csvde -d “OU=Users and Computers,OU=theOUname,DC=test,DC=domain,DC=example,DC=local” -f c:export.csv
3. This will export all user attributes to a csv file to c:
4. Open the export.csv with Excel and delete all the columns except the submissionContlength column and others that you’d like to keep.
5. Now you are able to see which user has limits set and what size they are in KB

Note that it’s easier to add the values for the csvde command when you have Active Directory open and browsed to where the users ar homed. Then just fill in the query from the bottom to the top like: OU=user,OU=branch1,=DC=yourdomain,DC=local

To export attributes from the root use: csvde -f c:export.csv (this will export the whole environment but beware your text file could be huge!

CSVDE is a very powerful tool and you can customise the query to produce filtered results. Google is your friend 😉


Dec 8 2011

Reporting on OWA for Exchange 2003

I recently received a request to report on OWA for a 2003 Exchange environment.

Needless to say without any 3rd party tools you are kind of left in the dark. However, I found the below website that assisted me with pulling some stats from the IIS logs using Log Parser 2.2 and 2 SQL scripts.

First browse to this website and follow the instructions. The site will give you 99% of the information you need to pull the reports. There was one issue that they failed to mention though. How do I export the data to CSV???

Here is a screenshot of how the command looks like: (you need to add -o:CSV to export the data to CSV format)

Other things to keep in mind:

1. I had to copy the log files to c:publicLogs for Log Parser to run against the logs
2. Add -o:CSV before the SQL Script path to export the output to CSV
3. The CSV file is found in C:PublicLogParserOutput
4. Open the CSV in Excel and panel beat the report to your heart’s desire

This article was very helpful and there’s some other commands that you might want to use.
Lastly I could not get the 2nd script to work for exporting the data to a pie graph.

Hope you found this useful.