General discussion

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.

16 total posts (Page 1 of 2)   01 | 02   Next
| Thread display: Collapse - | Expand +

All Comments

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.

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.

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?

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.

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.

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

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"

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

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.

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
16 total posts (Page 1 of 2)   01 | 02   Next

Related Discussions

Related Forums