Includes&Samples |
offset - property in ROOT\Microsoft\SqlServer\ServerEvents\MSSQLSERVER namespaceoffset in other namespacesList of classes with offset local property in ROOT\Microsoft\SqlServer\ServerEvents\MSSQLSERVER namespace
List of classes with offset derived property in ROOT\Microsoft\SqlServer\ServerEvents\MSSQLSERVER namespace
Code samples for offset propertyThe class LOCK_ESCALATION is abstract and serves only as a base for new classes. Get a Class as objectShort VB Script code to get the abstract class LOCK_ESCALATION.
'https://wutils.com/wmi/ Dim wmiClass, oProperty Set wmiClass = GetObject( _ "WINMGMTS:\\.\ROOT\Microsoft\SqlServer\ServerEvents\MSSQLSERVER:" + _ "LOCK_ESCALATION") 'get some class property Wscript.Echo wmiClass.properties_("offset").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 LOCK_ESCALATION.
'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 LOCK_ESCALATION - all instances of this class and derived classes Set Instances = oWMI.InstancesOf("LOCK_ESCALATION") 'Enumerate instances For Each Instance In Instances 'Do something with the instance Wscript.Echo Instance.offset 'or other property name Next 'Instance |