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