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