Roy,

Excellent article. 

Can this script be run for multiple servers?  Can I set the strComputer variable multiple times similar to the multiple databases?

Thanks,
John

Roy,

Pretty good article.

I have a little script I use to determine if I'm running out of space on each of the server drives and send me an email when the freespace gets below a threshold, rather than look at the space of each of the individual files.  This might be useful as well....

Mark

I have no VB skills.  When you say "Type cscript //H:Cscript. This will make cscript the default so that to run a vbscript all you need to type is the yourScript.vbs at the prompt without the cscript preface.".  Default of what?  Since I have no VB background I want to make sure setting this as a default does not break any existing processes.

Thanks,    Dave

I moved that script into Excel, It Work like a charm!!

Thanks

Works perfectly for smaller databases but the variables don't seem to hold GB sized files.  What is the syntax for defining a larger variable type instead of just the default?  The culprit is this line:

strFileMB = objFile.FileSize / CONVERSION_FACTOR

When objFile.FileSize is too big this displays blank for sime reason.  Commenting out the division part and just trying to print objFile.FileSize is also a blank so I suspect the problem is there.  How is that built in var defined and how can it be made to handle a large file size?

Nice easy to follow article.

I wonder if it would be possible (as I have no vb/coding experience either so going a little blind here), to monitor different instances and servers through the same page?

Great article. I look forward to the next in the series.

I did have one problem. I tried the post-script code for adding the date and time to the filename, and got a Windows Script Host error.

Line: 10

Char: 1

Error: 'Invalid procedure call or argument: 'DatePart'

Code: 800A0005

Source Microsoft VBScript runtime error

I am running WSH v 5.6, so i am not sure what is causing the error.

David