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