Win32_PerfFormattedData_msftesqlExchange_MSFTESQLExchangeService vbscript sample code | ActiveXperts Network Monitor

The foundations for Manageability in Windows is Windows Management Instrumentation (WMI; formerly WBEM) and WMI extensions for Windows Driver Model (WDM).

ActiveXperts Network Monitor provides the ability to build monitor check routines based on WMI. ActiveXperts has collected more than a hundred WMI samples. You can use these samples as a base for new check routines you can write yourself. The Win32_PerfFormattedData_msftesqlExchange_MSFTESQLExchangeService WMI class can be used in ActiveXperts Network Monitor to monitor your servers.

---

Sample Code

On Error Resume Next
strComputer = "."
Set objWMIService = GetObject("winmgmts:\\" & strComputer & "\root\cimv2")
Set colItems = objWMIService.ExecQuery("Select * from Win32_PerfFormattedData_msftesqlExchange_MSFTESQLExchangeService",,48)
For Each objItem in colItems
    Wscript.Echo "Batchesaborted: " & objItem.Batchesaborted
    Wscript.Echo "BatchescompletedwPererrors: " & objItem.BatchescompletedwPererrors
    Wscript.Echo "BatchescompletedwPerwarnings: " & objItem.BatchescompletedwPerwarnings
    Wscript.Echo "Batchescompletelysuccessful: " & objItem.Batchescompletelysuccessful
    Wscript.Echo "Batchesdone: " & objItem.Batchesdone
    Wscript.Echo "BatchesFPC: " & objItem.BatchesFPC
    Wscript.Echo "Batchesinprogress: " & objItem.Batchesinprogress
    Wscript.Echo "Batchesinreadyqueue: " & objItem.Batchesinreadyqueue
    Wscript.Echo "Batchesreceived: " & objItem.Batchesreceived
    Wscript.Echo "Caption: " & objItem.Caption
    Wscript.Echo "Catalogsmonitored: " & objItem.Catalogsmonitored
    Wscript.Echo "Catalogsmounted: " & objItem.Catalogsmounted
    Wscript.Echo "CBsacquired: " & objItem.CBsacquired
    Wscript.Echo "CBsdestroyed: " & objItem.CBsdestroyed
    Wscript.Echo "CBsgarbagecollected: " & objItem.CBsgarbagecollected
    Wscript.Echo "CBsgiven: " & objItem.CBsgiven
    Wscript.Echo "CBsinuse: " & objItem.CBsinuse
    Wscript.Echo "CBsize: " & objItem.CBsize
    Wscript.Echo "CBsreleased: " & objItem.CBsreleased
    Wscript.Echo "CBstotal: " & objItem.CBstotal
    Wscript.Echo "Description: " & objItem.Description
    Wscript.Echo "FDHDactive: " & objItem.FDHDactive
    Wscript.Echo "FDHDCBempty: " & objItem.FDHDCBempty
    Wscript.Echo "FDHDlaunched: " & objItem.FDHDlaunched
    Wscript.Echo "FDHDterminatedAV: " & objItem.FDHDterminatedAV
    Wscript.Echo "FDHDterminatedexcessivememory: " & objItem.FDHDterminatedexcessivememory
    Wscript.Echo "FDHDterminatedidle: " & objItem.FDHDterminatedidle
    Wscript.Echo "FDHDterminatedother: " & objItem.FDHDterminatedother
    Wscript.Echo "FDHDterminatedpipe: " & objItem.FDHDterminatedpipe
    Wscript.Echo "FDHDterminatedtimeout: " & objItem.FDHDterminatedtimeout
    Wscript.Echo "FDHDunresponsivetoshutdown: " & objItem.FDHDunresponsivetoshutdown
    Wscript.Echo "FDMTactive: " & objItem.FDMTactive
    Wscript.Echo "FDMTCBempty: " & objItem.FDMTCBempty
    Wscript.Echo "FDMTlaunched: " & objItem.FDMTlaunched
    Wscript.Echo "FDMTterminatedAV: " & objItem.FDMTterminatedAV
    Wscript.Echo "FDMTterminatedexcessivememory: " & objItem.FDMTterminatedexcessivememory
    Wscript.Echo "FDMTterminatedidle: " & objItem.FDMTterminatedidle
    Wscript.Echo "FDMTterminatedother: " & objItem.FDMTterminatedother
    Wscript.Echo "FDMTterminatedpipe: " & objItem.FDMTterminatedpipe
    Wscript.Echo "FDMTterminatedtimeout: " & objItem.FDMTterminatedtimeout
    Wscript.Echo "FDMTunresponsivetoshutdown: " & objItem.FDMTunresponsivetoshutdown
    Wscript.Echo "FDSTactive: " & objItem.FDSTactive
    Wscript.Echo "FDSTCBempty: " & objItem.FDSTCBempty
    Wscript.Echo "FDSTlaunched: " & objItem.FDSTlaunched
    Wscript.Echo "FDSTterminatedAV: " & objItem.FDSTterminatedAV
    Wscript.Echo "FDSTterminatedexcessivememory: " & objItem.FDSTterminatedexcessivememory
    Wscript.Echo "FDSTterminatedidle: " & objItem.FDSTterminatedidle
    Wscript.Echo "FDSTterminatedother: " & objItem.FDSTterminatedother
    Wscript.Echo "FDSTterminatedpipe: " & objItem.FDSTterminatedpipe
    Wscript.Echo "FDSTterminatedtimeout: " & objItem.FDSTterminatedtimeout
    Wscript.Echo "FDSTunresponsivetoshutdown: " & objItem.FDSTunresponsivetoshutdown
    Wscript.Echo "Frequency_Object: " & objItem.Frequency_Object
    Wscript.Echo "Frequency_PerfTime: " & objItem.Frequency_PerfTime
    Wscript.Echo "Frequency_Sys100NS: " & objItem.Frequency_Sys100NS
    Wscript.Echo "Heartbeats: " & objItem.Heartbeats
    Wscript.Echo "Indexperflevel: " & objItem.Indexperflevel
    Wscript.Echo "Name: " & objItem.Name
    Wscript.Echo "Queryperflevel: " & objItem.Queryperflevel
    Wscript.Echo "Timestamp_Object: " & objItem.Timestamp_Object
    Wscript.Echo "Timestamp_PerfTime: " & objItem.Timestamp_PerfTime
    Wscript.Echo "Timestamp_Sys100NS: " & objItem.Timestamp_Sys100NS
    Wscript.Echo "Totalnoisewordfiles: " & objItem.Totalnoisewordfiles
    Wscript.Echo "Totalstemmers: " & objItem.Totalstemmers
    Wscript.Echo "Totalthesaurus: " & objItem.Totalthesaurus
    Wscript.Echo "Totalwordbreakers: " & objItem.Totalwordbreakers
Next