Discussion on:

DOWNLOAD: Infrastructure Monitoring VBScripts

Monitoring your servers and network can run from cheap to way-too-expensive-to-bother, and it can run from simple to way-too-hard-to-care. Unfortunately, as the profile of Information Technology is raised and systems become more integrated, it's critical to be able to provide some semblance of monitoring of your systems and network.

Scott Lowe has created a series of VBScripts will collect a variety of network monitoring information and store that data in a Microsoft SQL Server 2005 Express database. You can download and try the VBScripts from the following URL:

http://techrepublic.com.com/5264-1-0.html?query=infrastructure%20monitoring%20project

After downloading and trying out the scripts, join this ongoing discussion and let us know if this script is helpful and if there's anything we can do to improve the download's format or content.

Why reinvent the wheel (and with VBScript, no less)? I just use Nagios for this sort of thing.

I setup the SQL server, but am running into issues when running the initial gathersysteminfo.vbs script. From the logfile
5/23/2006 12:51:38 PM -- An error occurred opening the read connection to the database. Error number: -2147467259. Error description: [DBNETLIB][ConnectionOpen (Connect()).]Specified SQL server not found.
5/23/2006 12:51:38 PM -- An error occurred opening the update connection to the database. Error number: -2147467259. Error description: [DBNETLIB][ConnectionOpen (Connect()).]Specified SQL server not found.
5/23/2006 12:51:38 PM -- An error occurred opening the read connection to the database. Error number: 3709. Error description: The connection cannot be used to perform this operation. It is either closed or invalid in this context.

I modified the servername entry in the constant line to reflect the computername that the SQL server is running on. What am I missing?

I had a similar error. I change the connection settings to enable both TCP/IP and named pipes. I am sure you would only need TCP/IP. Change it in the SQL Server Configuration Manager.

Hope this helps.

Hi
I am getting syntax errors when running the scripts. Project is very appealing to my needs and I would like to get it up and running..

[An error occurred writing OS WMI information. Error number: -2147217900. Error description: Incorrect syntax near ', [systemlist].[Version] = '.]

Appreciate any pointers you have to correct these errors.


regards

Warren

The only change I made to the scripts is changing the system name. He's got it listed as sDBserver = "dbe\SQLEXPRESS" I changed the dbe to reflect the name of the computer it's running on. sDBserver = "computername\SQLEXPRESS"

This script at least from my limited testing only identifies and gives stats on the C: drive and D: drive I have a system which has an C: D:, F: and H: drive and the script only reports two drives.

The information seems to be just one servers information replicated for machines which come after it in the list.

I reported this problem two weeks ago and the link is still broken. When I try to download the script for Server Up/Downtime, I get the e-mail scripts instead.

I'd really like to use this one too - all of these scripts have worked very well for me and I'm looking forward to more.

Can somebody fix this download link?

I'll have a look at it and make sure it has the right script.

I can't download the scripts for hard disk utilization or system information either. Is there another way to download these scripts?

have the reporting feature been released yet?

when is this script suppose to run? i dont understand why to have this script as it reports if the system is up, it cant really report when its down. the SQL data is a date and 1.

Am i missing the point?