Questions

Active Directory/Exchange Report

Tags:
+
0 Votes
Locked

Active Directory/Exchange Report

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?
  • +
    0 Votes
    mlieberman

    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.

    +
    0 Votes
    amit.puthran

    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.

    +
    0 Votes
    RDiaz727

    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?

    +
    0 Votes
    mlieberman

    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.

  • +
    0 Votes
    mlieberman

    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.

    +
    0 Votes
    amit.puthran

    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.

    +
    0 Votes
    RDiaz727

    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?

    +
    0 Votes
    mlieberman

    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.