Question

Locked

Active Directory/Exchange Report

By mlieberman ·
I am trying to create a basic query that I can make a basic Excel report from.

I want to get the Name, Quota, and Description of each user from AD as well as the actual size of the Exchange box from either WMI or we have a Spiceworks DB that also logs this. What is the easiest way of going about this?

This conversation is currently closed to new comments.

6 total posts (Page 1 of 1)  
| Thread display: Collapse - | Expand +

All Answers

Collapse -

Problem

by mlieberman In reply to LDAP has some functionali ...

Yeah, the problem is you can't get the Exchange size from that. I have a LDAP query tool that I can use to get everything except for the current size. And I have the ability via WMI to get all the info on Exchange but the Eescription. I need all of it, because the description is what we use as identifiers for our clients and we charge clients by the mailbox/size of mailbox.

Collapse -

Bulk Change Utility

by amit.puthran In reply to Active Directory/Exchange ...

I use this tool to update or export AD object : http://www.wisesoft.co.uk/software/passwordcontrol/bulk_password_control.aspx, there is a LDAP query option too which you might be able to use to export the mailbox size. The name of this tool is misleading as it can do a lot more than just the typical bulk password updates.

Collapse -

Some of your fields

by RDiaz727 In reply to Active Directory/Exchange ...

Part of your request...

Get-MailboxStatistics -server "yourexchangeserver" | Select DisplayName, TotalItemSize | export-csv c:\file.csv

The problem is the description and quota are in different commands. You would need to pipe something to 'foreach'.

Since your Desciption and quota are usually static, can you grab those once, and just keep updating displayname and totalitemsize?

Collapse -

Solution

by mlieberman In reply to Active Directory/Exchange ...

After some searching and not really finding anything that does both LDAP and WMI queries or LDAP and SQL queries (at least anything fairly simple to use.) I ended up just developing a Java app to do it. I developed the Java app to query both our Active Directory getting the name, quota and description of each mailbox user and then also running a query against our Spiceworks database that logs the name and actual size of the mailbox and then joining the two queries based on name. Luckily there were only a few instances where the mailbox name and user name didn't match. I was then easily able to perform operations and export that data as a report.

Back to Software Forum
6 total posts (Page 1 of 1)  

Software Forums