Total Size of Multiple Files

[zacherynuk]

Hi,

Just starting to get to grips with the trial version and I must say I am quite impressed!

I am grafting through covering most bases I need, however, one test I really need to be able to perform is Exchange datastore size - in exchange 2k/2k3 I need to be able to add together the size of the STM and EDB files and ensure they do not exceed certain sizes - for example 16 or 75 GB

I'm sure this would be useful for other applications also.

I suppose I could just move the databases into their own respective folders though...

[Yoorix]

You may use WMI test to query information from MS Exchange Server.
http://www.ks-soft.net/hostmon.eng/mfra ... ts.htm#wmi
Could you read following article:
http://msdn.microsoft.com/library/en-us ... erence.asp
It might help.

Also you may write simple perl or JS script to obtain addition of STM and EDB files and use ActiveScript test method to perform it.
http://www.ks-soft.net/hostmon.eng/mfra ... htm#script

Regards,
Yoorix

[KS-Soft Europe]

one test I really need to be able to perform is Exchange datastore size - in exchange 2k/2k3 I need to be able to add together the size of the STM and EDB files and ensure they do not exceed certain sizes - for example 16 or 75 GB

I agree with Yoorix you should use WMI test, but in another way.
You should setup WMI test with following query:
Select filesize from CIM_DATAFILE where name='D:\\temp\\aaa.STM' or name = 'D:\\temp\\aaa.EDB'

Also you should specify "Alert if" dropdown as "total" and define value to compare with. Obviously, you should specify your own values instead of 'D:\\temp\\aaa'. Please note, double slashes are required!

Regards,
Max

[zacherynuk]

Guys, Thank you kindly for your replies!

I shall look into the WMI and see what I can do, it does, at first glance, the whole WMI thing seems to be VERY powerful indeed.

I shall study the reference and play with the CIM_DATAFILE and see where I get to:)

Be nice to get some guides for common monitoring situations going - once I have this all up n running with the more complex stuff, Backups, AV updates etc I shall post my methods in the hope it is useful..

Thanks again,

z

[zacherynuk]

Hi,

Select filesize from CIM_DATAFILE where name='D:\\temp\\aaa.STM' or name = 'D:\\temp\\aaa.EDB'

Worked an absolute treat! Thank you so much, I feel a little humbled. I have much to learn about WMI and this whole product.


z

[KS-Soft Europe]

Be nice to get some guides for common monitoring situations going - once I have this all up n running with the more complex stuff, Backups, AV updates etc I shall post my methods in the hope it is useful..

Sure, It would be nice if you share your knowledge with our comunity. There is a special branch on our forum for such purposes:
http://www.ks-soft.net/cgi-bin/phpBB/vi ... 8ce1aa2a20

Regards,
Max