Contact Info

Crumbtrail

ActiveXperts.com » Administration » Scripts » WMI » VBScript

Win32-PerfFormattedData-msftesqlFDExchange-MSFTESQLExchangeFD - WMI VBScript sample

The foundations for Manageability in Windows 2019/2016/2012/2008 and Windows 10/7/XP are 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.

On this site, you can find many WMI samples.

The Win32_PerfFormattedData_msftesqlFDExchange_MSFTESQLExchangeFD WMI class can be used in ActiveXperts Network Monitor to monitor your servers.


Win32-PerfFormattedData-msftesqlFDExchange-MSFTESQLExchangeFD

Example(s)

  On Error Resume Next
strComputer = "."
Set objWMIService = GetObject("winmgmts:\\" & strComputer & "\root\cimv2")
Set colItems = objWMIService.ExecQuery("Select * from Win32_PerfFormattedData_msftesqlFDExchange_MSFTESQLExchangeFD",,48)
For Each objItem in colItems
    Wscript.Echo "Batchescompleted: " & objItem.Batchescompleted
    Wscript.Echo "Batchesinprogress: " & objItem.Batchesinprogress
    Wscript.Echo "Batchesreceived: " & objItem.Batchesreceived
    Wscript.Echo "Batchesrejected: " & objItem.Batchesrejected
    Wscript.Echo "Caption: " & objItem.Caption
    Wscript.Echo "Description: " & objItem.Description
    Wscript.Echo "Filters: " & objItem.Filters
    Wscript.Echo "Frequency_Object: " & objItem.Frequency_Object
    Wscript.Echo "Frequency_PerfTime: " & objItem.Frequency_PerfTime
    Wscript.Echo "Frequency_Sys100NS: " & objItem.Frequency_Sys100NS
    Wscript.Echo "Name: " & objItem.Name
    Wscript.Echo "NoiseWordLists: " & objItem.NoiseWordLists
    Wscript.Echo "Timestamp_Object: " & objItem.Timestamp_Object
    Wscript.Echo "Timestamp_PerfTime: " & objItem.Timestamp_PerfTime
    Wscript.Echo "Timestamp_Sys100NS: " & objItem.Timestamp_Sys100NS
    Wscript.Echo "Transactionscompleted: " & objItem.Transactionscompleted
    Wscript.Echo "Transactionsreceived: " & objItem.Transactionsreceived
    Wscript.Echo "Transactionsstarted: " & objItem.Transactionsstarted
    Wscript.Echo "TransErrors: " & objItem.TransErrors
    Wscript.Echo "TransSuccess: " & objItem.TransSuccess
    Wscript.Echo "WordBreakers: " & objItem.WordBreakers
Next