database_name - property in ROOT\WMI namespace

database_name in other namespaces

List of classes with database_name local property in ROOT\WMI namespace

propertyClassOrigin
database_nameauto_statsauto_stats
database_namebackground_job_errorbackground_job_error
database_namebad_memory_fixedbad_memory_fixed
database_nameblocked_process_reportblocked_process_report
database_namebroker_conversationbroker_conversation
database_namebroker_queue_activation_alertbroker_queue_activation_alert
database_namebroker_queue_disabledbroker_queue_disabled
database_nameclustered_columnstore_index_rebuildclustered_columnstore_index_rebuild
database_namedatabase_agent_local_operation_begindatabase_agent_local_operation_begin
database_namedatabase_agent_local_operation_enddatabase_agent_local_operation_end
database_namedatabase_agent_request_begindatabase_agent_request_begin
database_namedatabase_agent_request_enddatabase_agent_request_end
database_namedatabase_createddatabase_created
database_namedatabase_ddl_stmt_runtime_checkdatabase_ddl_stmt_runtime_check
database_namedatabase_ddl_stmt_startdatabase_ddl_stmt_start
database_namedatabase_file_size_changedatabase_file_size_change
database_namedatabase_mirroring_state_changedatabase_mirroring_state_change
database_namedatabase_suspect_data_pagedatabase_suspect_data_page
database_namedatabase_uncontained_usagedatabase_uncontained_usage
database_namedatabase_xml_deadlock_reportdatabase_xml_deadlock_report
database_nameddl_with_wait_at_low_priorityddl_with_wait_at_low_priority
database_nameexisting_connectionexisting_connection
database_namefull_text_crawl_startedfull_text_crawl_started
database_namefull_text_crawl_stoppedfull_text_crawl_stopped
database_namehadr_database_replica_disjoin_completionhadr_database_replica_disjoin_completion
database_namelock_acquiredlock_acquired
database_namelock_cancellock_cancel
database_namelock_deadlocklock_deadlock
database_namelock_deadlock_chainlock_deadlock_chain
database_namelock_escalationlock_escalation
database_namelock_redo_blockedlock_redo_blocked
database_namelock_redo_unblockedlock_redo_unblocked
database_namelock_releasedlock_released
database_namelock_timeoutlock_timeout
database_namelock_timeout_greater_than_0lock_timeout_greater_than_0
database_nameloginlogin
database_nameobject_alteredobject_altered
database_nameobject_createdobject_created
database_nameobject_deletedobject_deleted
database_namepreconnect_completedpreconnect_completed
database_namepreconnect_startingpreconnect_starting
database_nameprogress_report_online_index_operationprogress_report_online_index_operation
database_namequery_post_compilation_showplanquery_post_compilation_showplan
database_namequery_post_execution_showplanquery_post_execution_showplan
database_namequery_pre_execution_showplanquery_pre_execution_showplan
database_namescan_startedscan_started
database_namescan_stoppedscan_stopped
database_namesp_cache_hitsp_cache_hit
database_namesp_cache_insertsp_cache_insert
database_namesp_cache_misssp_cache_miss
database_namesp_cache_removesp_cache_remove
database_nametransaction_logtransaction_log

Code samples for database_name property

Get instance of WMI class using GetObject, database_name property of database_ddl_stmt_start

Short VBS code - get a single specified instance of database_ddl_stmt_start 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\WMI:" + _
 "database_ddl_stmt_start.PropertyName=""SomeText""")
Wscript.Echo wmiObject.database_name 'or other property name, see properties
See more VBS samples of database_ddl_stmt_start class

WMI query - sample windows WQL with C#, database_name property of database_ddl_stmt_start

Get a specified instance of database_ddl_stmt_start by a key, get a default unnamed instance (singleton) of the class or list instances of the class by wmi query using this c# sample code.
See in another language: VBScript, VB.Net.
//https://wutils.com/wmi/

//Project -> Add reference -> System.Management
//using System.Management;

//create a management scope object
ManagementScope scope = new ManagementScope("\\\\.\\ROOT\\WMI");

//create object query
ObjectQuery query = new ObjectQuery("SELECT * FROM database_ddl_stmt_start Where PropertyName=\"SomeText\"");

//create object searcher
ManagementObjectSearcher searcher =
                        new ManagementObjectSearcher(scope, query);

//get a collection of WMI objects
ManagementObjectCollection queryCollection = searcher.Get();

//enumerate the collection.
foreach (ManagementObject m in queryCollection) 
{
  // access properties of the WMI object
  Console.WriteLine("database_name : {0}", m["database_name"]);
  
}

WMI query - sample windows WQL with VB.Net, database_name property of database_ddl_stmt_start

Get a specified instance of database_ddl_stmt_start by a key, get a default unnamed instance (singleton) of the class or list instances of the class by wmi query using this VB.Net sample code.
See in another language: VBScript, C#
'Project -> Add reference -> System.Management
'Imports System.Management

'Get the namespace management scope
Dim Scope As New ManagementScope("\\.\ROOT\WMI")

'Get a result of WML query 
Dim Query As New ObjectQuery("SELECT * FROM database_ddl_stmt_start Where PropertyName="SomeText"")

'Create object searcher
Dim Searcher As New ManagementObjectSearcher(Scope, Query)

'Get a collection of WMI objects
Dim queryCollection As ManagementObjectCollection = Searcher.Get

'Enumerate wmi object 
For Each mObject As ManagementObject In queryCollection
  'write out some property value
  Console.WriteLine("database_name : {0}", mObject("database_name"))
Next
comments powered by Disqus
WUtils.com