Includes&Samples |
CPU - property in ROOT\Microsoft\SqlServer\ServerEvents\MSSQLSERVER namespaceCPU in other namespacesList of classes with CPU local property in ROOT\Microsoft\SqlServer\ServerEvents\MSSQLSERVER namespace
Code samples for CPU propertyThe class CPU_THRESHOLD_EXCEEDED is abstract and serves only as a base for new classes. Get a Class as objectShort VB Script code to get the abstract class CPU_THRESHOLD_EXCEEDED.
'https://wutils.com/wmi/ Dim wmiClass, oProperty Set wmiClass = GetObject( _ "WINMGMTS:\\.\ROOT\Microsoft\SqlServer\ServerEvents\MSSQLSERVER:" + _ "CPU_THRESHOLD_EXCEEDED") 'get some class property Wscript.Echo wmiClass.properties_("CPU").Origin 'or other property name, see properties 'Check if the class is singleton Wscript.Echo wmiClass.Path_.IsSingleton 'Get number of methods in the class Wscript.Echo wmiClass.Methods_.Count 'List class properties For Each oProperty In wmiClass.properties_ 'get property name and origin. Property value in the class is null, of course. Wscript.Echo oProperty.Name, oProperty.Origin, oProperty.Value Next InstancesOfList of all instances, wmi class CPU_THRESHOLD_EXCEEDED.
'https://wutils.com/wmi/ Dim oWMI, Instances, Instance 'Get base WMI object, "." means computer name (local) Set oWMI = GetObject("WINMGMTS:\\.\ROOT\Microsoft\SqlServer\ServerEvents\MSSQLSERVER") 'Get instances of CPU_THRESHOLD_EXCEEDED - all instances of this class and derived classes Set Instances = oWMI.InstancesOf("CPU_THRESHOLD_EXCEEDED") 'Enumerate instances For Each Instance In Instances 'Do something with the instance Wscript.Echo Instance.CPU 'or other property name Next 'Instance |