IT Employment·20,069 discussions

DOWNLOAD: Infrastructure Monitoring VBScripts

Locked

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.

Topic

reinventing the wheel

In reply to DOWNLOAD: Infrastructure Monitoring VBScripts

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

linux only?

In reply to reinventing the wheel

It appears Nagios is for Linux only. I want it on a Win32 server.

issues

In reply to DOWNLOAD: Infrastructure Monitoring VBScripts

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?

Similar error

In reply to issues

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.

update

In reply to Similar error

I had enabled both settings without any change. I uninstalled SQL Express and then reloaded following same steps I used before. Now working.

Syntax Errors

In reply to DOWNLOAD: Infrastructure Monitoring VBScripts

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

syntax issue

In reply to Syntax Errors

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”

or use a DOT

In reply to Syntax Errors

Same solutions but the difference is in not specifically naming the host and using the DOT prefix, you can then run this from and computer running the SQL database. If you want to test on a lab server before running it in production.
example: .\sqlexpress
instead of computername\sqlexpress

Only Identifies the drives C: and D:

In reply to DOWNLOAD: Infrastructure Monitoring VBScripts

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.

And the information doesn’t appear correct

In reply to DOWNLOAD: Infrastructure Monitoring VBScripts

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

Problem with Server up/downtime download

In reply to DOWNLOAD: Infrastructure Monitoring VBScripts

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?

Taking a look

In reply to Problem with Server up/downtime download

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

Problem with others too

In reply to Taking a look

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

Still need scripts

In reply to Problem with others too

I have a copy of the scripts if you need them, let me know and I will get them to you.

Does anyone know if the SNMP scripts are available?

Reports

In reply to DOWNLOAD: Infrastructure Monitoring VBScripts

have the reporting feature been released yet?

time to run?

In reply to DOWNLOAD: Infrastructure Monitoring VBScripts

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?

[Author]

Replies