Procedure

Installation and Usage:

• Create the log table:
  • Open Intelli-Site and enter Design mode.
  • Expand "Database"->"Cardlist".
  • Right-click the "Tables" node and choose "Add Node and Edit"
  • In the resulting Window Enter "DriveMonitor" into the "New Table Name" field.
  • Click the "Add Field" button and enter the parameters for each field as follows:
    • Field Name: "Server" Type:"Text"
    • Field Name: "Drive" Type:"Text"
    • Field Name: "FreeSpace" Type:"Text"
    • Field Name: "TimeStamp" Type:"Date"
  • Click "OK"
• Install and Configure the Script File:
  • Copy the vbs file to a location of your choice to which all users have write access. For simplicity, we will place the file in the Windows folder and use the %WINDIR% variable for the path.
  • Open the Windows Start Menu, right-click the "Startup" folder and choose "Explore All Users".
  • In the resulting Explorer window, click the "File" menu and choose "New"->"Shortcut".
  • Follow the instructions on the screen to create a shortcut for the DriveMonitor.vbs file.
  • Right-click the resulting shortcut icon and choose "Properties".
  • Change the "Target:" field to the following:
    • Method 1:
      • "wscript %WINDIR%DriveMonitor.vbs" and append the appropriate parameters as follows:
        • /emailFrom:
          • Email account from which to send alert emails
        • /emailTo: 
          • Email address to send alert emails to
        • /emailPassword:
          • Password for the sender's email account
        • /SMTPServer:
          •  Email server name
        • /SMTPPort:
          • SMTP Port for sending emails
        • /SMTPUseSSL
          • Connect to email server using SSL
        • /WaitTime:
          • Amount of time in minutes between checking disk space
        • /SQLServer:
          • SQL Server name for logging
        • /Database:
          • Database name for logging results
        • /dbUser:
          • SQL username, if none specified, windows authentication will be used
        • /dbPassword:
          • SQL password
        • /AlertHigh:
          • Minimum percentage of disk space before warning email is sent expressed as decimal
        • /hosts:
          • list of machines to monitor separated by commas, no spaces, please
      • Apply your changes.
    • Method 2:
      • "wscript %WINDIR%DriveMonitor.vbs /D"
      • Apply your changes.
      • Edit the DriveMonitor.vbs and set the default values to match your requirements.