Exchange server DB size and White space

by berlin144 at 2012-11-02 02:45:46

Hi,
I am facing a problem to collect the server db size and white size.

I have multiple servers in different locations. On each server there is different disk drives like D:,C: etc… On each drive there will be multiple DB files. I need to find each file’s size and white space on that day. I will get the server names as input…

How can I solve my issue using "Get-WMIObject Win32_NTLogEvent -ComputerName xxx.xxx.xxx.xxx -Filter “LogFile=‘Application’ AND EventCode=1221” …

Now I can find the DB size using CMI_DiskFile class… But how can I find Whitespace using Win32_NTLogEvent OR can I find both using Win32_NTLogEvent ???

Can Anyone provide me a solution…

Thanks in Advance…
Berlin
by coderaven at 2012-11-05 03:37:01
I would read this post about the white space.

It shows getting the white space with this command:
Get-MailboxDatabase Database1 -Status | FT Name,AvailableNewMailboxSpace
You can also go get the Get-ExchangeWhiteSpace command here that was created by author of the article linked above.
by cdolar at 2012-12-23 11:27:16
Hi, There is a great report which gives the information you want, I have this schedules on the server to send me an email daily, check it out: http://www.stevieg.org/2011/06/exchange … nt-report/

Regards.
Bulent - http://www.cdolar.com