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

Success in other namespaces

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

propertyClassOrigin
SuccessASSEMBLY_LOADASSEMBLY_LOAD
SuccessTRC_SECURITY_AUDITTRC_SECURITY_AUDIT

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

propertyClassOrigin
SuccessAUDIT_ADD_DB_USER_EVENTTRC_SECURITY_AUDIT
SuccessAUDIT_ADD_LOGIN_TO_SERVER_ROLE_EVENTTRC_SECURITY_AUDIT
SuccessAUDIT_ADD_MEMBER_TO_DB_ROLE_EVENTTRC_SECURITY_AUDIT
SuccessAUDIT_ADD_ROLE_EVENTTRC_SECURITY_AUDIT
SuccessAUDIT_ADDLOGIN_EVENTTRC_SECURITY_AUDIT
SuccessAUDIT_APP_ROLE_CHANGE_PASSWORD_EVENTTRC_SECURITY_AUDIT
SuccessAUDIT_BACKUP_RESTORE_EVENTTRC_SECURITY_AUDIT
SuccessAUDIT_CHANGE_AUDIT_EVENTTRC_SECURITY_AUDIT
SuccessAUDIT_CHANGE_DATABASE_OWNERTRC_SECURITY_AUDIT
SuccessAUDIT_DATABASE_MANAGEMENT_EVENTTRC_SECURITY_AUDIT
SuccessAUDIT_DATABASE_OBJECT_ACCESS_EVENTTRC_SECURITY_AUDIT
SuccessAUDIT_DATABASE_OBJECT_GDR_EVENTTRC_SECURITY_AUDIT
SuccessAUDIT_DATABASE_OBJECT_MANAGEMENT_EVENTTRC_SECURITY_AUDIT
SuccessAUDIT_DATABASE_OBJECT_TAKE_OWNERSHIP_EVENTTRC_SECURITY_AUDIT
SuccessAUDIT_DATABASE_OPERATION_EVENTTRC_SECURITY_AUDIT
SuccessAUDIT_DATABASE_PRINCIPAL_IMPERSONATION_EVENTTRC_SECURITY_AUDIT
SuccessAUDIT_DATABASE_PRINCIPAL_MANAGEMENT_EVENTTRC_SECURITY_AUDIT
SuccessAUDIT_DATABASE_SCOPE_GDR_EVENTTRC_SECURITY_AUDIT
SuccessAUDIT_DBCC_EVENTTRC_SECURITY_AUDIT
SuccessAUDIT_FULLTEXTTRC_SECURITY_AUDIT
SuccessAUDIT_LOGINTRC_SECURITY_AUDIT
SuccessAUDIT_LOGIN_CHANGE_PASSWORD_EVENTTRC_SECURITY_AUDIT
SuccessAUDIT_LOGIN_CHANGE_PROPERTY_EVENTTRC_SECURITY_AUDIT
SuccessAUDIT_LOGIN_FAILEDTRC_SECURITY_AUDIT
SuccessAUDIT_LOGIN_GDR_EVENTTRC_SECURITY_AUDIT
SuccessAUDIT_LOGOUTTRC_SECURITY_AUDIT
SuccessAUDIT_SCHEMA_OBJECT_ACCESS_EVENTTRC_SECURITY_AUDIT
SuccessAUDIT_SCHEMA_OBJECT_GDR_EVENTTRC_SECURITY_AUDIT
SuccessAUDIT_SCHEMA_OBJECT_MANAGEMENT_EVENTTRC_SECURITY_AUDIT
SuccessAUDIT_SCHEMA_OBJECT_TAKE_OWNERSHIP_EVENTTRC_SECURITY_AUDIT
SuccessAUDIT_SERVER_ALTER_TRACE_EVENTTRC_SECURITY_AUDIT
SuccessAUDIT_SERVER_OBJECT_GDR_EVENTTRC_SECURITY_AUDIT
SuccessAUDIT_SERVER_OBJECT_MANAGEMENT_EVENTTRC_SECURITY_AUDIT
SuccessAUDIT_SERVER_OBJECT_TAKE_OWNERSHIP_EVENTTRC_SECURITY_AUDIT
SuccessAUDIT_SERVER_OPERATION_EVENTTRC_SECURITY_AUDIT
SuccessAUDIT_SERVER_PRINCIPAL_IMPERSONATION_EVENTTRC_SECURITY_AUDIT
SuccessAUDIT_SERVER_PRINCIPAL_MANAGEMENT_EVENTTRC_SECURITY_AUDIT
SuccessAUDIT_SERVER_SCOPE_GDR_EVENTTRC_SECURITY_AUDIT

Code samples for Success property

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

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


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