creating report of all exchange mailboxes with associated information

steps to create report of all exchange user mailboxes with associated Names, server names, departments and title
(Note, you must have at least exchange recipient management rights to do this)
1. Open Exchange management shell
2. Run the Get mailbox powershell command(see below)
3. Run the Get-user command (see pshell command below). Note that this can take up to 10-15minutes to complete
4. Open MS Access and open the text files to a database and import the text files to respective tables in same database
5. While importing, use fixed width. Name the fields. Choose no primary key
6. After importing, create join between required tables
7. Run query on joined tables

get-mailbox  -ResultSize Unlimited  | ft SamAccountName, DisplayName, ServerName | out-file c:all-EMTmboxes060309.txt
get-user  -ResultSize Unlimited | where-object{$_.RecipientType –eq “UserMailbox”}| ft SamAccountName, FirstName, LastName, Department, Title | out-file c:allusermailboxes060309.txt


Leave a Reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

%d bloggers like this: