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