Yunlong Notes Index: Sample Admin Script: Performance Monitoring Script using VBScript and WMI

Saturday 22 March 2014

Sample Admin Script: Performance Monitoring Script using VBScript and WMI

My friend asks me whether I have a sample script for Performance Monitoring.
I have created a sample script for performance monitoring using VBScript and WMI.
The output is in html.

To modify, you must understand VBScript and WMI.

Have a great day

Steps

1. Save All Admin Scripts in the same location

2. Execute "WindowsSystem_PerfMon_Snapshot.cmd"

3. Open "WindowsSystem_PerfMon_Snapshot.html" for output

Admin Scripts

Script #1:
WindowsSystem_PerfMon_Snapshot.cmd

@ECHO ON

SET ADMIN_SCRIPTS=WindowsSystem_PerfMon_Snapshot.vbs
SET ADMIN_OUTPUT=WindowsSystem_PerfMon_Snapshot.html

cscript /NoLogo "%ADMIN_SCRIPTS%" > "%ADMIN_OUTPUT%"

Script #2:
WindowsSystem_PerfMon_Snapshot.vbs

Option Explicit

Dim objWMIService, colItems, objItem

wscript.echo "<html>"
wscript.echo "<body>"
wscript.echo "<table border='1'>"
wscript.echo "
<tr>"
wscript.echo "<td>Date/Time</td>"
wscript.echo "<td>Hostname</td>"
wscript.echo "<td>% Processor Time</td>"
wscript.echo "<td>% Committed Bytes In Used</td>"
wscript.echo "<td>Disk Space</td>"
wscript.echo "</tr>
"

Set objWMIService = GetObject("winmgmts:\\.\root\cimv2")

wscript.echo "
<tr>"
 
  wscript.echo "<td>" & Now & "</td>"

 '==========================================================================
 
  Set colItems = objWMIService.ExecQuery("Select * From Win32_ComputerSystem")

  For Each objItem in colItems
   wscript.echo "<td>" & objItem.Name & "</td>"
  Next

 '==========================================================================

  Set colItems = objWMIService.ExecQuery("SELECT * FROM Win32_PerfFormattedData_PerfOS_Processor WHERE Name = '_Total'") 

  For Each objItem In colItems
   wscript.echo "<td>" & objItem.PercentProcessorTime & "%" & "</td>"
  Next

 '==========================================================================

  Set colItems = objWMIService.ExecQuery("SELECT * FROM Win32_PerfFormattedData_PerfOS_Memory") 

  For Each objItem In colItems
   wscript.echo "<td>" & objItem.PercentCommittedBytesInUse & "%" & "</td>"
  Next

 '==========================================================================

  Set colItems = objWMIService.ExecQuery("Select * from Win32_LogicalDisk Where DriveType = 3")

  wscript.echo "<td><table border=1 cellpadding=3 cellspacing=0>"
  wscript.echo "
<tr>"
  wscript.echo "<td>Drive</td>"
  wscript.echo "<td align=center>Used</td>"
  wscript.echo "<td align=center>Free</td>"
  wscript.echo "<td align=center>Total</td>"
  wscript.echo "<td>% Used</td>"
  wscript.echo "<td>% Free</td>"
  wscript.echo "</tr>
"
   
  Dim pctFreeSpace 
  For Each objItem in colItems
   
   pctFreeSpace = objItem.FreeSpace / objItem.Size
   
   wscript.echo "
<tr>"
   wscript.echo "<td>" & Left(objItem.DeviceID, 1) & "</td>"
   wscript.echo "<td align=right>" & FormatDiskSizeCapacity((objItem.Size - objItem.FreeSpace)) & "</td>"
   wscript.echo "<td align=right>" & FormatDiskSizeCapacity(objItem.FreeSpace) & "</td>"
   wscript.echo "<td align=right>" & FormatDiskSizeCapacity(objItem.Size) & "</td>"
   wscript.echo "<td align=right>" & FormatPercent(1-pctFreeSpace) & "</td>"
   wscript.echo "<td align=right>" & FormatPercent(pctFreeSpace) & "</td>"
   wscript.echo "</tr>
"

  Next
  wscript.echo "</table>
</td>"

  '==========================================================================

wscript.echo "</tr>
</table>
"

wscript.echo "</body>"
wscript.echo "</html>"

'************************************************************************************************

 Function FormatDiskSizeCapacity(intSize)
  'Digital Unit Symbol
  ' KB  KiloByte
  ' MB  MegaByte
  ' GB  GigaByte
  ' TB  TeraByte
  ' PB  PetaByte
  ' EB  ExaByte
  ' ZB  ZettaByte
  ' YB  YottaByte
  
  Dim arrCapacityInfo : arrCapacityInfo = Array("KB","MB","GB","TB","PB","EB","ZB","YB")
  Dim intCurrentSize  : intCurrentSize = intSize
  Dim intLoopCount    : intLoopCount = -1
  
  Do
   intCurrentSize = intCurrentSize / 1024
   intLoopCount = intLoopCount + 1
  Loop While intCurrentSize >= 1024

  FormatDiskSizeCapacity = FormatNumber(intCurrentSize,2) & " " & arrCapacityInfo(intLoopCount)
   
 End Function

Yunlong Notes Index

Saturday 22 March 2014

Sample Admin Script: Performance Monitoring Script using VBScript and WMI

No comments :

Post a Comment