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