IT Employment

General discussion

Gravatar
0 Votes
Locked

DOWNLOA Infrastructure Monitoring VBScripts

By Bill Detwiler Editor ·
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.

This conversation is currently closed to new comments.

Thread display: Collapse - | Expand +

All Comments

gravatar
Collapse -

reinventing the wheel

by apotheon In reply to DOWNLOAD: Infrastructure ...

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

gravatar
Collapse -

linux only?

by jon_bjerke In reply to reinventing the wheel

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

gravatar
Collapse -

issues

by jon_bjerke In reply to DOWNLOAD: Infrastructure ...

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?

gravatar
Collapse -

Similar error

by warreno 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.

gravatar
Collapse -

update

by jon_bjerke 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.

gravatar
Collapse -

Syntax Errors

by warreno In reply to DOWNLOAD: Infrastructure ...

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

gravatar
Collapse -

syntax issue

by jon_bjerke 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"

gravatar
Collapse -

or use a DOT

by wchaster 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

gravatar
Collapse -

Only Identifies the drives C: and

by SaulGoode In reply to DOWNLOAD: Infrastructure ...

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

gravatar
Collapse -

And the information doesn't appear correct

by SaulGoode In reply to DOWNLOAD: Infrastructure ...

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

Back to IT Employment Forum

Start or search

Related Discussions

Related Forums