General discussion

  • Creator
    Topic
  • #2194603
    Avatar photo

    DOWNLOAD: Infrastructure Monitoring VBScripts

    Locked

    by Bill Detwiler ·

    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.

All Comments

  • Author
    Replies
    • #3160432

      reinventing the wheel

      by apotheon ·

      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.

    • #3146782

      issues

      by jon_bjerke ·

      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?

      • #3157944

        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.

        • #3157753

          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.

    • #3157943

      Syntax Errors

      by warreno ·

      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

      • #3157750

        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”

      • #2657456

        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

    • #3110975

      Only Identifies the drives C: and D:

      by saulgoode ·

      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.

    • #3110964

      And the information doesn’t appear correct

      by saulgoode ·

      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.

    • #3168408

      Problem with Server up/downtime download

      by svilla8874 ·

      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?

      • #3211636

        Taking a look

        by Mark W. Kaelin ·

        In reply to Problem with Server up/downtime download

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

        • #3211565

          Problem with others too

          by chris_alabama ·

          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?

        • #3276728

          Still need scripts

          by jon_bjerke ·

          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?

    • #2499822

      Reports

      by cwelty ·

      In reply to DOWNLOAD: Infrastructure Monitoring VBScripts

      have the reporting feature been released yet?

    • #2585502

      time to run?

      by alexxxxx ·

      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?

Viewing 7 reply threads