Win32_PerfFormattedData_SQLSERVERAGENT python 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_SQLSERVERAGENT WMI class can be used in ActiveXperts Network Monitor to monitor your servers.
Sample Code
from win32com.client import GetObject objWMI = GetObject('winmgmts:').InstancesOf('Win32_PerfFormattedData_SQLSERVERAGENT_SQLAgentAlerts') for obj in objWMI: if obj.Activatedalerts != None: print("Activatedalerts:" + str(obj.Activatedalerts)) if obj.AlertsactivatedPerminute != None: print("AlertsactivatedPerminute:" + str(obj.AlertsactivatedPerminute)) if obj.Caption != None: print("Caption:" + str(obj.Caption)) if obj.Description != None: print("Description:" + str(obj.Description)) if obj.Frequency_Object != None: print("Frequency_Object:" + str(obj.Frequency_Object)) if obj.Frequency_PerfTime != None: print("Frequency_PerfTime:" + str(obj.Frequency_PerfTime)) if obj.Frequency_Sys100NS != None: print("Frequency_Sys100NS:" + str(obj.Frequency_Sys100NS)) if obj.Name != None: print("Name:" + str(obj.Name)) if obj.Timestamp_Object != None: print("Timestamp_Object:" + str(obj.Timestamp_Object)) if obj.Timestamp_PerfTime != None: print("Timestamp_PerfTime:" + str(obj.Timestamp_PerfTime)) if obj.Timestamp_Sys100NS != None: print("Timestamp_Sys100NS:" + str(obj.Timestamp_Sys100NS)) print("") print("########") print("")