IntegerData2 - property in ROOT\Microsoft\SqlServer\ServerEvents\MSSQLSERVER namespace

List of classes with IntegerData2 local property in ROOT\Microsoft\SqlServer\ServerEvents\MSSQLSERVER namespace

property	Class	Origin
IntegerData2	LOCK_DEADLOCK	LOCK_DEADLOCK
IntegerData2	LOCK_DEADLOCK_CHAIN	LOCK_DEADLOCK_CHAIN
IntegerData2	LOCK_ESCALATION	LOCK_ESCALATION
IntegerData2	SP_RECOMPILE	SP_RECOMPILE
IntegerData2	SQL_STMTRECOMPILE	SQL_STMTRECOMPILE
IntegerData2	TRC_DEPRECATION	TRC_DEPRECATION

…

List of classes with IntegerData2 derived property in ROOT\Microsoft\SqlServer\ServerEvents\MSSQLSERVER namespace

property	Class	Origin
IntegerData2	DEPRECATION_ANNOUNCEMENT	TRC_DEPRECATION
IntegerData2	DEPRECATION_FINAL_SUPPORT	TRC_DEPRECATION

Code samples for IntegerData2 property

The class LOCK_ESCALATION is abstract and serves only as a base for new classes.

Get a Class as object

Short VB Script code to get the abstract class LOCK_ESCALATION.

See in another language: C#, VB.Net.

…

'https://wutils.com/wmi/
Dim wmiClass, oProperty
Set wmiClass = GetObject( _
 "WINMGMTS:\\.\ROOT\Microsoft\SqlServer\ServerEvents\MSSQLSERVER:" + _
 "LOCK_ESCALATION")

'get some class property 
Wscript.Echo wmiClass.properties_("IntegerData2").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

InstancesOf

List of all instances, wmi class LOCK_ESCALATION.

…

'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 LOCK_ESCALATION - all instances of this class and derived classes 
Set Instances = oWMI.InstancesOf("LOCK_ESCALATION")


'Enumerate instances  
For Each Instance In Instances 
  'Do something with the instance
  Wscript.Echo Instance.IntegerData2 'or other property name
Next 'Instance

WUtils.com

Includes&Samples