Includes&Samples |
Win32_PerfFormattedData_MSSQLSERVER_SQLServerBrokerTOStatistics, ROOT\cimv2, VBScript samplesClass | Methods | Properties (15) | Qualifiers (15) | Instances (1) | Namespaces (1)Samples: VB Script | C# | VB.Net | Search on:Microsoft Win32_PerfFormattedData_MSSQLSERVER_SQLServerBrokerTOStatistics - VB Script code samplesGet instance of WMI class using GetObject, AvgLengthofBatchedWrites property of Win32_PerfFormattedData_MSSQLSERVER_SQLServerBrokerTOStatisticsShort VBS code - get a single specified instance of Win32_PerfFormattedData_MSSQLSERVER_SQLServerBrokerTOStatistics class or get
a default unnamed instance (singleton) of the class, using one single command GetObject
with exact path of the wmi object.
'https://wutils.com/wmi/ Dim wmiObject Set wmiObject = GetObject( _ "WINMGMTS:\\.\ROOT\cimv2:" + _ "Win32_PerfFormattedData_MSSQLSERVER_SQLServerBrokerTOStatistics=@") Wscript.Echo wmiObject.AvgLengthofBatchedWrites 'or other property name, see properties Alternative codesSWbemServices.GetQuickest and most efficient VB Script code to get a single instance by a key - SWbemServices.Get
'https://wutils.com/wmi/ Dim oWMI, Instance 'Get base WMI object, "." means computer name (local) Set oWMI = GetObject("WINMGMTS:\\.\ROOT\cimv2") Do 'Get the instance of Win32_PerfFormattedData_MSSQLSERVER_SQLServerBrokerTOStatistics Set Instance = oWMI.Get("Win32_PerfFormattedData_MSSQLSERVER_SQLServerBrokerTOStatistics=@") 'Do something with the instance Wscript.Echo Instance.AvgLengthofBatchedWrites 'or other property name, see properties 'Wait for some time to get next value Wscript.Sleep 1000 Loop While True WMI query - sample windows WQLGet a specified instance of Win32_PerfFormattedData_MSSQLSERVER_SQLServerBrokerTOStatistics by a key, get a default unnamed instance (singleton) of the class or list instances of the class by wmi query using this VB Script.
'https://wutils.com/wmi/ Dim oWMI, WQL, Instances, Instance 'Get base WMI object, "." means computer name (local) Set oWMI = GetObject("WINMGMTS:\\.\ROOT\cimv2") 'Create a WMI query text WQL = "Select * from Win32_PerfFormattedData_MSSQLSERVER_SQLServerBrokerTOStatistics" 'Get instances of Win32_PerfFormattedData_MSSQLSERVER_SQLServerBrokerTOStatistics Set Instances = oWMI.ExecQuery(WQL) 'Enumerate instances For Each Instance In Instances 'Do something with the instance Wscript.Echo Instance.AvgLengthofBatchedWrites 'or other property name Next 'Instance InstancesOfList of all instances, wmi class Win32_PerfFormattedData_MSSQLSERVER_SQLServerBrokerTOStatistics.
'https://wutils.com/wmi/ Dim oWMI, Instances, Instance 'Get base WMI object, "." means computer name (local) Set oWMI = GetObject("WINMGMTS:\\.\ROOT\cimv2") 'Get instances of Win32_PerfFormattedData_MSSQLSERVER_SQLServerBrokerTOStatistics - all instances of this class and derived classes 'Set Instances = oWMI.InstancesOf("Win32_PerfFormattedData_MSSQLSERVER_SQLServerBrokerTOStatistics") 'Get instances of Win32_PerfFormattedData_MSSQLSERVER_SQLServerBrokerTOStatistics Set Instances = oWMI.InstancesOf("Win32_PerfFormattedData_MSSQLSERVER_SQLServerBrokerTOStatistics", 1) 'Enumerate instances For Each Instance In Instances 'Do something with the instance Wscript.Echo Instance.AvgLengthofBatchedWrites 'or other property name Next 'Instance WMI remote scripting - Locator, ConnectGet WMI management object using SWbemLocator.ConnectServer method.
You can connect to a remote computer and specify Username/Password for the WMI connection.
'https://wutils.com/wmi/ Dim Locator, oWMI, WQL, Instances, Instance 'Create Locator object Set Locator = CreateObject("WbemScripting.SWbemLocator") 'Get base WMI object Set oWMI = Locator.ConnectServer("MachineName", "ROOT\cimv2", "MachineName\administrator", "Password") '.... continue using oWMI object |