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

IsSystem in other namespaces

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

propertyClassOrigin
IsSystemBITMAP_WARNINGBITMAP_WARNING
IsSystemBLOCKED_PROCESS_REPORTBLOCKED_PROCESS_REPORT
IsSystemCPU_THRESHOLD_EXCEEDEDCPU_THRESHOLD_EXCEEDED
IsSystemERRORLOGERRORLOG
IsSystemEVENTLOGEVENTLOG
IsSystemEXCEPTIONEXCEPTION
IsSystemEXCHANGE_SPILL_EVENTEXCHANGE_SPILL_EVENT
IsSystemEXECUTION_WARNINGSEXECUTION_WARNINGS
IsSystemHASH_WARNINGHASH_WARNING
IsSystemMISSING_COLUMN_STATISTICSMISSING_COLUMN_STATISTICS
IsSystemMISSING_JOIN_PREDICATEMISSING_JOIN_PREDICATE
IsSystemSORT_WARNINGSSORT_WARNINGS
IsSystemTRC_DATABASETRC_DATABASE
IsSystemTRC_DEPRECATIONTRC_DEPRECATION
IsSystemTRC_FULL_TEXTTRC_FULL_TEXT
IsSystemTRC_LOCKSTRC_LOCKS
IsSystemTRC_OBJECTSTRC_OBJECTS
IsSystemTRC_OLEDBTRC_OLEDB
IsSystemTRC_PERFORMANCETRC_PERFORMANCE
IsSystemTRC_QUERY_NOTIFICATIONSTRC_QUERY_NOTIFICATIONS
IsSystemTRC_SECURITY_AUDITTRC_SECURITY_AUDIT
IsSystemTRC_SERVERTRC_SERVER
IsSystemTRC_STORED_PROCEDURESTRC_STORED_PROCEDURES
IsSystemTRC_TSQLTRC_TSQL
IsSystemTRC_USER_CONFIGURABLETRC_USER_CONFIGURABLE
IsSystemUSER_ERROR_MESSAGEUSER_ERROR_MESSAGE

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

propertyClassOrigin
IsSystemAUDIT_ADD_DB_USER_EVENTTRC_SECURITY_AUDIT
IsSystemAUDIT_ADD_LOGIN_TO_SERVER_ROLE_EVENTTRC_SECURITY_AUDIT
IsSystemAUDIT_ADD_MEMBER_TO_DB_ROLE_EVENTTRC_SECURITY_AUDIT
IsSystemAUDIT_ADD_ROLE_EVENTTRC_SECURITY_AUDIT
IsSystemAUDIT_ADDLOGIN_EVENTTRC_SECURITY_AUDIT
IsSystemAUDIT_APP_ROLE_CHANGE_PASSWORD_EVENTTRC_SECURITY_AUDIT
IsSystemAUDIT_BACKUP_RESTORE_EVENTTRC_SECURITY_AUDIT
IsSystemAUDIT_CHANGE_AUDIT_EVENTTRC_SECURITY_AUDIT
IsSystemAUDIT_CHANGE_DATABASE_OWNERTRC_SECURITY_AUDIT
IsSystemAUDIT_DATABASE_MANAGEMENT_EVENTTRC_SECURITY_AUDIT
IsSystemAUDIT_DATABASE_OBJECT_ACCESS_EVENTTRC_SECURITY_AUDIT
IsSystemAUDIT_DATABASE_OBJECT_GDR_EVENTTRC_SECURITY_AUDIT
IsSystemAUDIT_DATABASE_OBJECT_MANAGEMENT_EVENTTRC_SECURITY_AUDIT
IsSystemAUDIT_DATABASE_OBJECT_TAKE_OWNERSHIP_EVENTTRC_SECURITY_AUDIT
IsSystemAUDIT_DATABASE_OPERATION_EVENTTRC_SECURITY_AUDIT
IsSystemAUDIT_DATABASE_PRINCIPAL_IMPERSONATION_EVENTTRC_SECURITY_AUDIT
IsSystemAUDIT_DATABASE_PRINCIPAL_MANAGEMENT_EVENTTRC_SECURITY_AUDIT
IsSystemAUDIT_DATABASE_SCOPE_GDR_EVENTTRC_SECURITY_AUDIT
IsSystemAUDIT_DBCC_EVENTTRC_SECURITY_AUDIT
IsSystemAUDIT_FULLTEXTTRC_SECURITY_AUDIT
IsSystemAUDIT_LOGINTRC_SECURITY_AUDIT
IsSystemAUDIT_LOGIN_CHANGE_PASSWORD_EVENTTRC_SECURITY_AUDIT
IsSystemAUDIT_LOGIN_CHANGE_PROPERTY_EVENTTRC_SECURITY_AUDIT
IsSystemAUDIT_LOGIN_FAILEDTRC_SECURITY_AUDIT
IsSystemAUDIT_LOGIN_GDR_EVENTTRC_SECURITY_AUDIT
IsSystemAUDIT_LOGOUTTRC_SECURITY_AUDIT
IsSystemAUDIT_SCHEMA_OBJECT_ACCESS_EVENTTRC_SECURITY_AUDIT
IsSystemAUDIT_SCHEMA_OBJECT_GDR_EVENTTRC_SECURITY_AUDIT
IsSystemAUDIT_SCHEMA_OBJECT_MANAGEMENT_EVENTTRC_SECURITY_AUDIT
IsSystemAUDIT_SCHEMA_OBJECT_TAKE_OWNERSHIP_EVENTTRC_SECURITY_AUDIT
IsSystemAUDIT_SERVER_ALTER_TRACE_EVENTTRC_SECURITY_AUDIT
IsSystemAUDIT_SERVER_OBJECT_GDR_EVENTTRC_SECURITY_AUDIT
IsSystemAUDIT_SERVER_OBJECT_MANAGEMENT_EVENTTRC_SECURITY_AUDIT
IsSystemAUDIT_SERVER_OBJECT_TAKE_OWNERSHIP_EVENTTRC_SECURITY_AUDIT
IsSystemAUDIT_SERVER_OPERATION_EVENTTRC_SECURITY_AUDIT
IsSystemAUDIT_SERVER_PRINCIPAL_IMPERSONATION_EVENTTRC_SECURITY_AUDIT
IsSystemAUDIT_SERVER_PRINCIPAL_MANAGEMENT_EVENTTRC_SECURITY_AUDIT
IsSystemAUDIT_SERVER_SCOPE_GDR_EVENTTRC_SECURITY_AUDIT
IsSystemDATA_FILE_AUTO_GROWTRC_DATABASE
IsSystemDATA_FILE_AUTO_SHRINKTRC_DATABASE
IsSystemDATABASE_MIRRORING_STATE_CHANGETRC_DATABASE
IsSystemDEADLOCK_GRAPHTRC_LOCKS
IsSystemDEPRECATION_ANNOUNCEMENTTRC_DEPRECATION
IsSystemDEPRECATION_FINAL_SUPPORTTRC_DEPRECATION
IsSystemFT_CRAWL_ABORTEDTRC_FULL_TEXT
IsSystemFT_CRAWL_STARTEDTRC_FULL_TEXT
IsSystemFT_CRAWL_STOPPEDTRC_FULL_TEXT
IsSystemLOCK_DEADLOCKTRC_LOCKS
IsSystemLOCK_DEADLOCK_CHAINTRC_LOCKS
IsSystemLOCK_ESCALATIONTRC_LOCKS
IsSystemLOG_FILE_AUTO_GROWTRC_DATABASE
IsSystemLOG_FILE_AUTO_SHRINKTRC_DATABASE
IsSystemMOUNT_TAPETRC_SERVER
IsSystemOBJECT_ALTEREDTRC_OBJECTS
IsSystemOBJECT_CREATEDTRC_OBJECTS
IsSystemOBJECT_DELETEDTRC_OBJECTS
IsSystemOLEDB_CALL_EVENTTRC_OLEDB
IsSystemOLEDB_DATAREAD_EVENTTRC_OLEDB
IsSystemOLEDB_ERRORSTRC_OLEDB
IsSystemOLEDB_PROVIDER_INFORMATIONTRC_OLEDB
IsSystemOLEDB_QUERYINTERFACE_EVENTTRC_OLEDB
IsSystemQN__DYNAMICSTRC_QUERY_NOTIFICATIONS
IsSystemQN__PARAMETER_TABLETRC_QUERY_NOTIFICATIONS
IsSystemQN__SUBSCRIPTIONTRC_QUERY_NOTIFICATIONS
IsSystemQN__TEMPLATETRC_QUERY_NOTIFICATIONS
IsSystemSERVER_MEMORY_CHANGETRC_SERVER
IsSystemSHOWPLAN_ALL_FOR_QUERY_COMPILETRC_PERFORMANCE
IsSystemSHOWPLAN_XMLTRC_PERFORMANCE
IsSystemSHOWPLAN_XML_FOR_QUERY_COMPILETRC_PERFORMANCE
IsSystemSHOWPLAN_XML_STATISTICS_PROFILETRC_PERFORMANCE
IsSystemSP_CACHEINSERTTRC_STORED_PROCEDURES
IsSystemSP_CACHEMISSTRC_STORED_PROCEDURES
IsSystemSP_CACHEREMOVETRC_STORED_PROCEDURES
IsSystemSP_RECOMPILETRC_STORED_PROCEDURES
IsSystemSQL_STMTRECOMPILETRC_TSQL
IsSystemTRACE_FILE_CLOSETRC_SERVER
IsSystemUSERCONFIGURABLE_0TRC_USER_CONFIGURABLE
IsSystemUSERCONFIGURABLE_1TRC_USER_CONFIGURABLE
IsSystemUSERCONFIGURABLE_2TRC_USER_CONFIGURABLE
IsSystemUSERCONFIGURABLE_3TRC_USER_CONFIGURABLE
IsSystemUSERCONFIGURABLE_4TRC_USER_CONFIGURABLE
IsSystemUSERCONFIGURABLE_5TRC_USER_CONFIGURABLE
IsSystemUSERCONFIGURABLE_6TRC_USER_CONFIGURABLE
IsSystemUSERCONFIGURABLE_7TRC_USER_CONFIGURABLE
IsSystemUSERCONFIGURABLE_8TRC_USER_CONFIGURABLE
IsSystemUSERCONFIGURABLE_9TRC_USER_CONFIGURABLE
IsSystemXQUERY_STATIC_TYPETRC_TSQL

Code samples for IsSystem property

The class ERRORLOG 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 ERRORLOG.
See in another language: C#, VB.Net.
'https://wutils.com/wmi/
Dim wmiClass, oProperty
Set wmiClass = GetObject( _
 "WINMGMTS:\\.\ROOT\Microsoft\SqlServer\ServerEvents\MSSQLSERVER:" + _
 "ERRORLOG")

'get some class property 
Wscript.Echo wmiClass.properties_("IsSystem").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 ERRORLOG.
'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 ERRORLOG - all instances of this class and derived classes 
Set Instances = oWMI.InstancesOf("ERRORLOG")


'Enumerate instances  
For Each Instance In Instances 
  'Do something with the instance
  Wscript.Echo Instance.IsSystem 'or other property name
Next 'Instance
comments powered by Disqus
WUtils.com