Win32_PerfFormattedData_MSSQLSQLEXPRESS_MSSQLSQLEXPRESSDatabaseMirroring vbscript sample code

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_MSSQLSQLEXPRESS_MSSQLSQLEXPRESSDatabaseMirroring 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_MSSQLSQLEXPRESS_MSSQLSQLEXPRESSDatabaseMirroring",,48)
For Each objItem in colItems
    Wscript.Echo "BytesReceivedPersec: " & objItem.BytesReceivedPersec
    Wscript.Echo "BytesSentPersec: " & objItem.BytesSentPersec
    Wscript.Echo "Caption: " & objItem.Caption
    Wscript.Echo "Description: " & objItem.Description
    Wscript.Echo "Frequency_Object: " & objItem.Frequency_Object
    Wscript.Echo "Frequency_PerfTime: " & objItem.Frequency_PerfTime
    Wscript.Echo "Frequency_Sys100NS: " & objItem.Frequency_Sys100NS
    Wscript.Echo "LogBytesReceivedPersec: " & objItem.LogBytesReceivedPersec
    Wscript.Echo "LogBytesRedonefromCachePersec: " & objItem.LogBytesRedonefromCachePersec
    Wscript.Echo "LogBytesSentfromCachePersec: " & objItem.LogBytesSentfromCachePersec
    Wscript.Echo "LogBytesSentPersec: " & objItem.LogBytesSentPersec
    Wscript.Echo "LogCompressedBytesRcvdPersec: " & objItem.LogCompressedBytesRcvdPersec
    Wscript.Echo "LogCompressedBytesSentPersec: " & objItem.LogCompressedBytesSentPersec
    Wscript.Echo "LogHardenTimems: " & objItem.LogHardenTimems
    Wscript.Echo "LogRemainingforUndoKB: " & objItem.LogRemainingforUndoKB
    Wscript.Echo "LogScannedforUndoKB: " & objItem.LogScannedforUndoKB
    Wscript.Echo "LogSendFlowControlTimems: " & objItem.LogSendFlowControlTimems
    Wscript.Echo "LogSendQueueKB: " & objItem.LogSendQueueKB
    Wscript.Echo "MirroredWriteTransactionsPersec: " & objItem.MirroredWriteTransactionsPersec
    Wscript.Echo "Name: " & objItem.Name
    Wscript.Echo "PagesSentPersec: " & objItem.PagesSentPersec
    Wscript.Echo "ReceivesPersec: " & objItem.ReceivesPersec
    Wscript.Echo "RedoBytesPersec: " & objItem.RedoBytesPersec
    Wscript.Echo "RedoQueueKB: " & objItem.RedoQueueKB
    Wscript.Echo "SendPerReceiveAckTime: " & objItem.SendPerReceiveAckTime
    Wscript.Echo "SendsPersec: " & objItem.SendsPersec
    Wscript.Echo "Timestamp_Object: " & objItem.Timestamp_Object
    Wscript.Echo "Timestamp_PerfTime: " & objItem.Timestamp_PerfTime
    Wscript.Echo "Timestamp_Sys100NS: " & objItem.Timestamp_Sys100NS
    Wscript.Echo "TransactionDelay: " & objItem.TransactionDelay
Next