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