Storage group report
Hello,I need to provide the following report (usingExchange 2007):Storage Group; Employee number; Lastname; Firstname; Alias; CDP; Site Name; Company; CATEGORY; SMTP1; SMTP2; SMTP3; SMTP4; SMTP5; SMTP6I tried command with Get-Mailbox but have no clue how to get all those information all together.I really need to know what user (Lastname+ Firstname) belongs to what storage Group.And also gather the below information in a xls file (rows)Coudl you please help me out??Graig
May 7th, 2009 4:41pm
Here is an example of what you can do dumping username, lastname, firstname, and storagegroup. You can add the other attributes but this gives you an idea how to do it.get-mailbox -resultsize unlimited | select samaccountname, @{name="Last Name";expression={(get-user $_.samaccountname).lastname}}, @{name="First Name";expression={(get-user $_.samaccountname).firstname}},@{name="Storage Group";expression={$_.database.parent.name}} | export-csv -notype 'filename.csv'Sr. Exchange Engineer - Constellation Energy
Free Windows Admin Tool Kit Click here and download it now
May 7th, 2009 5:11pm