SolarWinds Firewall Security Manager (FSM) reduces the risk of data loss and external threats.
Other benefits include:
• Automate auditing & reporting
• Leverage over 120 standards-based security checks
• Detect high risk firewalls in minutes
• Expose hidden network vulnerabilities
In a great blog entry by Michael B. Smith, he has outlined a scripted method of obtaining the Mailbox and Public Folder store sizes on all Exchange servers in your organization.
As Michael explains, it is a common request is to find out how much disk space Exchange is using in all of the various EDB and STM files spread out everywhere. By running Michael's fine script, you will get an output similar to this (I've used Michael's own report, as I do not have a test environment with more than one server right now):
Exchange Organization Name: We Do Email best
Default SMTP address for organization: e12beta.com
All Exchange Servers in forest DC=e12beta,DC=com
Server Name: VOLCANO
Server Name: E12BETA
Server name: VOLCANO
Storage group: First Storage Group
Store: Public Folder Store (VOLCANO)
EDB file: C:\Program Files\Exchsrvr\mdbdata\pub1.edb
Size: 11 megabytes
SLV file: C:\Program Files\Exchsrvr\mdbdata\pub1.stm
Size: 4 megabytes
Store Size Total: 15 megabytes
Store: Mailbox Store (VOLCANO)
EDB file: C:\Program Files\Exchsrvr\mdbdata\priv1.edb
Size: 6 megabytes
SLV file: C:\Program Files\Exchsrvr\mdbdata\priv1.stm
Size: 8 megabytes
Store Size Total: 14 megabytes
Storage Group total: 29 megabytes
Server total: 29 megabytes
Server name: E12BETA
Storage group: First Storage Group
Store: Public Folder Store (E12BETA)
EDB file: D:\Exchsrvr\MDBDATA\pub1.edb
Size: 897 megabytes
SLV file: D:\Exchsrvr\MDBDATA\pub1.stm
Size: 212 megabytes
Store Size Total: 1,109 megabytes
Store: 7-Day-DIR
EDB file: D:\Exchsrvr\MDBDATA\7-Day-DIR.edb
Size: 22,189 megabytes
SLV file: D:\Exchsrvr\MDBDATA\7-Day-DIR.stm
Size: 15,296 megabytes
Store Size Total: 37,485 megabytes
Store: DBI Archive Store
EDB file: D:\Exchsrvr\MDBDATA\DBI Archive Store.edb
Size: 4,752 megabytes
SLV file: D:\Exchsrvr\MDBDATA\DBI Archive Store.stm
Size: 4,288 megabytes
Store Size Total: 9,040 megabytes
Store: Mailbox Store (E12BETA)
EDB file: D:\Exchsrvr\MDBDATA\priv1.edb
Size: 92,861 megabytes
SLV file: D:\Exchsrvr\MDBDATA\priv1.stm
Size: 46,632 megabytes
Store Size Total: 139,493 megabytes
Store: Mailbox Store 2
EDB file: D:\Exchsrvr\MDBDATA\Mailbox Store 2.edb
Size: 4,047 megabytes
SLV file: D:\Exchsrvr\MDBDATA\Mailbox Store 2.stm
Size: 18 megabytes
Store Size Total: 4,065 megabytes
Storage Group total: 191,192 megabytes
Storage group: Second Storage Group
Store: Mailbox Store 3
EDB file: D:\Exchsrvr\SecondStorageGroup\Mailbox Store 3.edb
Size: 5,180 megabytes
SLV file: D:\Exchsrvr\SecondStorageGroup\Mailbox Store 3.stm
Size: 1,508 megabytes
Store Size Total: 6,688 megabytes
Storage Group total: 6,688 megabytes
Server total: 197,909 megabytes
Organization total: 197,938 megabytes
As you see, this text report (which can easily be piped into a file) gives you some nice information about your servers, store locations, and store sizes. For each storage group a subtotal is generated, for each server a subtotal is generated, and for the entire organization a total is generated. This presents a nice little hierarchical view of your storage usage.
The script should work on Exchange 2000, 2003, and 2007, but in order to use it you also need to create some more script files that can be found in another of Michael's posts. However some readers asked me if I could help them in understanding what these scripts do and how to use them. I will not go into technical details on how these scripts work, the author does a much better job than me, but I can help by creating the scripts for you, placing them into a zipped file, and adding a simple installing batch.
So, here goes. Download the attached ex_report_store_sizes.zip (10kb). Extract it by using WinZip or similar, and run the enclosed batch file. It'll create the right folder structure on your server.
When done, go to the %Systemdrive%\Scripts folder and run the following command:
Cool.
