PowerShell Script to export mailbox details
Hi, I am looking for a script to export details of few executive mailboxes such as Display Name, MailboxSize(MB), ItemCount,Database,DatabaseSize,FreeDiskSpace. Currently i am running three different scripts to get this information. 1. To get Display Name, MailboxSize(MB), ItemCount,Database 2. To get DatabaseSize and 3. To get DiskCapacity and DiskFreeSpace. Is it possible to combine all three scripts into one to get above mentioned information. Our exchange server have MountPoint drives as well as SAN drives. If anyone has a script to acheive my task above please share it with me. Thanks, ShahidShahid
May 25th, 2012 5:31am

Almost, try this one out, it will show whitespace, db size, the largest MB user for each DB you can custimize the script to show more than just 1st user, pretty straight forward. Exchange 2010 Database HTML Email Report http://gallery.technet.microsoft.com/scriptcenter/d9af4a66-a908-4a3f-af10-380aa63c3a74 Database Name Server Database File Database Size(MB) # of Mailboxes WhiteSpace(MB) Top Mailbox Top Mailbox Size Last Full Backup No Backup Since? MDB01 TIER1 DCEXMAILP02 E:\Exchsrvr\MDB01\MDB01.edb 94607.36 40 459.59MB Jenn 8.72GB 05/14/2012 17:57:36 8 MDB05 TIER3 DCEXMAILP02 E:\Exchsrvr\MDB05\MDB05.edb 49674.24 93 2.09MB David 2.87GB 05/23/2012 01:08:10 0 MDB02 TIER1 DCEXMAILP02 E:\Exchsrvr\MDB02\MDB02.edb 105861.12 35 5.83GB Carson 8.17GB 05/13/2012 23:08:37 9 MDB04 TIER2 DCEXMAILP02 E:\Exchsrvr\MDB04\MDB04.edb 65157.12 33 3.84GB Tim 5.97GB 05/22/2012 22:26:55 0 MDB06 TIER3 DCEXMAILP02 E:\Exchsrvr\MDB06\MDB06.edb 140687.36 398 6.26GB Brett 1.28GB 05/13/2012 23:08:37 9 MDB03 TIER3 DCEXMAILP02 E:\Exchsrvr\MDB03\MDB03 TIER3.edb 29829.12 8 2.76GB Emily 6.89GB 05/22/2012 21:51:16 0 MDB07 TIER3 DCEXMAILP02 E:\Exchsrvr\MDB07\MDB07.edb 8.06 2.16MB SystemMailbox{3a420d7a-4d93-4fbf-b774-eaf49a08e998} 318Bytes null Never Backed Up James Chong MCITP | EA | EMA; MCSE | M+, S+ Security+, Project+, ITIL msexchangetips.blogspot.com
Free Windows Admin Tool Kit Click here and download it now
May 25th, 2012 9:56am

Almost, try this one out, it will show whitespace, db size, the largest MB user for each DB you can custimize the script to show more than just 1st user, pretty straight forward. Exchange 2010 Database HTML Email Report http://gallery.technet.microsoft.com/scriptcenter/d9af4a66-a908-4a3f-af10-380aa63c3a74 Database Name Server Database File Database Size(MB) # of Mailboxes WhiteSpace(MB) Top Mailbox Top Mailbox Size Last Full Backup No Backup Since? MDB01 TIER1 DCEXMAILP02 E:\Exchsrvr\MDB01\MDB01.edb 94607.36 40 459.59MB Jenn 8.72GB 05/14/2012 17:57:36 8 MDB05 TIER3 DCEXMAILP02 E:\Exchsrvr\MDB05\MDB05.edb 49674.24 93 2.09MB David 2.87GB 05/23/2012 01:08:10 0 MDB02 TIER1 DCEXMAILP02 E:\Exchsrvr\MDB02\MDB02.edb 105861.12 35 5.83GB Carson 8.17GB 05/13/2012 23:08:37 9 MDB04 TIER2 DCEXMAILP02 E:\Exchsrvr\MDB04\MDB04.edb 65157.12 33 3.84GB Tim 5.97GB 05/22/2012 22:26:55 0 MDB06 TIER3 DCEXMAILP02 E:\Exchsrvr\MDB06\MDB06.edb 140687.36 398 6.26GB Brett 1.28GB 05/13/2012 23:08:37 9 MDB03 TIER3 DCEXMAILP02 E:\Exchsrvr\MDB03\MDB03 TIER3.edb 29829.12 8 2.76GB Emily 6.89GB 05/22/2012 21:51:16 0 MDB07 TIER3 DCEXMAILP02 E:\Exchsrvr\MDB07\MDB07.edb 8.06 2.16MB SystemMailbox{3a420d7a-4d93-4fbf-b774-eaf49a08e998} 318Bytes null Never Backed Up James Chong MCITP | EA | EMA; MCSE | M+, S+ Security+, Project+, ITIL msexchangetips.blogspot.com
May 25th, 2012 10:00am

James, Thanks for the script but i am still using EX2007 and need script for that. Using csv import file which will have users smtp address it should export out following details in csv. DisplayName,TotalItemSize(MB),ItemCount,DBSize(GB),Database,DiskCapacity,DiskFreeSpace,LogDiskCapacity,LogDiskFreeSpace,EDBFilepath I searched over the internet but couldn't find a script which exports all of the above. I tried to merge couple of script into one but due to lack of scripting knowledge i couldn't. Thanks, Shahid Shahid I have some servers with MountPoint Volumes and some without mountpoint volumes. With the script i need to extract data from both.
Free Windows Admin Tool Kit Click here and download it now
May 25th, 2012 10:50am

Did you even try the above script ?
May 26th, 2012 9:19pm

Hi KadarShahid You need several steps to meet your requirement, And there is no existing script that could meet all your requirements. Try James's script first, that is the most similar one, then you could modify the Script by your own to meet what you want. If you have more question about Script, you could also ask on the Script Forum http://social.technet.microsoft.com/Forums/pl-pl/ITCG/threads CheersZi Feng TechNet Community Support
Free Windows Admin Tool Kit Click here and download it now
May 28th, 2012 2:22am

Hi KadarShahid You need several steps to meet your requirement, And there is no existing script that could meet all your requirements. Try James's script first, that is the most similar one, then you could modify the Script by your own to meet what you want. If you have more question about Script, you could also ask on the Script Forum http://social.technet.microsoft.com/Forums/pl-pl/ITCG/threads CheersZi Feng TechNet Community Support
May 28th, 2012 2:26am

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics