Contact Info

Crumbtrail

ActiveXperts.com » Administration » Scripts » WMI » Category

MsSQL

ActiveXperts Network Monitor is an advanced and easy tool for monitoring LAN and WAN networks, network servers, workstations and TCP/IP devices. It has a large set of built-in checks, and you can add new checks by writing scripts. You can use VBScript (Windows) or RSH (UNIX) for it. VBScript checks can use WMI and ADSI. WMI is an interface to a broad range of properties of a computer/OS/application. With ADSI, you can monitor Directory Services.

Use the samples below to get used to various WMI classes, and use these classes in your own, custom ActiveXperts Network Monitor check. Each sample below can also be copied to a new file and then run from the command prompt (CSCRIPT.EXE <file>.vbs).

Overview of the MsSQL WMI classes

Win32_PerfFormattedData_MSSQLSQLEXPRESS_MSSQLSQLEXPRESSAccessMethods
  The Win32_PerfFormattedData_MSSQLSQLEXPRESS_MSSQLSQLEXPRESSAccessMethods WMI class can be used into your custom scripts.
  VBScript »     Python »  
Win32_PerfFormattedData_MSSQLSQLEXPRESS_MSSQLSQLEXPRESSBackupDevice
  The Win32_PerfFormattedData_MSSQLSQLEXPRESS_MSSQLSQLEXPRESSBackupDevice WMI class can be used into your custom scripts.
  VBScript »     Python »  
Win32_PerfFormattedData_MSSQLSQLEXPRESS_MSSQLSQLEXPRESSBrokerActivation
  The Win32_PerfFormattedData_MSSQLSQLEXPRESS_MSSQLSQLEXPRESSBrokerActivation WMI class can be used into your custom scripts.
  VBScript »     Python »  
Win32_PerfFormattedData_MSSQLSQLEXPRESS_MSSQLSQLEXPRESSBrokerDBMTransport
  The Win32_PerfFormattedData_MSSQLSQLEXPRESS_MSSQLSQLEXPRESSBrokerDBMTransport WMI class can be used into your custom scripts.
  VBScript »     Python »  
Win32_PerfFormattedData_MSSQLSQLEXPRESS_MSSQLSQLEXPRESSBrokerStatistics
  The Win32_PerfFormattedData_MSSQLSQLEXPRESS_MSSQLSQLEXPRESSBrokerStatistics WMI class can be used into your custom scripts.
  VBScript »     Python »  
Win32_PerfFormattedData_MSSQLSQLEXPRESS_MSSQLSQLEXPRESSBrokerTOStatistics
  The Win32_PerfFormattedData_MSSQLSQLEXPRESS_MSSQLSQLEXPRESSBrokerTOStatistics WMI class can be used into your custom scripts.
  VBScript »     Python »  
Win32_PerfFormattedData_MSSQLSQLEXPRESS_MSSQLSQLEXPRESSBufferManager
  The Win32_PerfFormattedData_MSSQLSQLEXPRESS_MSSQLSQLEXPRESSBufferManager WMI class can be used into your custom scripts.
  VBScript »     Python »  
Win32_PerfFormattedData_MSSQLSQLEXPRESS_MSSQLSQLEXPRESSBufferNode
  The Win32_PerfFormattedData_MSSQLSQLEXPRESS_MSSQLSQLEXPRESSBufferNode WMI class can be used into your custom scripts.
  VBScript »     Python »  
Win32_PerfFormattedData_MSSQLSQLEXPRESS_MSSQLSQLEXPRESSBufferPartition
  The Win32_PerfFormattedData_MSSQLSQLEXPRESS_MSSQLSQLEXPRESSBufferPartition WMI class can be used into your custom scripts.
  VBScript »     Python »  
Win32_PerfFormattedData_MSSQLSQLEXPRESS_MSSQLSQLEXPRESSCatalogMetadata
  The Win32_PerfFormattedData_MSSQLSQLEXPRESS_MSSQLSQLEXPRESSCatalogMetadata WMI class can be used into your custom scripts.
  VBScript »     Python »  
Win32_PerfFormattedData_MSSQLSQLEXPRESS_MSSQLSQLEXPRESSCLR
  The Win32_PerfFormattedData_MSSQLSQLEXPRESS_MSSQLSQLEXPRESSCLR WMI class can be used into your custom scripts.
  VBScript »     Python »  
Win32_PerfFormattedData_MSSQLSQLEXPRESS_MSSQLSQLEXPRESSCursorManagerbyType
  The Win32_PerfFormattedData_MSSQLSQLEXPRESS_MSSQLSQLEXPRESSCursorManagerbyType WMI class can be used into your custom scripts.
  VBScript »     Python »  
Win32_PerfFormattedData_MSSQLSQLEXPRESS_MSSQLSQLEXPRESSCursorManagerTotal
  The Win32_PerfFormattedData_MSSQLSQLEXPRESS_MSSQLSQLEXPRESSCursorManagerTotal WMI class can be used into your custom scripts.
  VBScript »     Python »  
Win32_PerfFormattedData_MSSQLSQLEXPRESS_MSSQLSQLEXPRESSDatabaseMirroring
  The Win32_PerfFormattedData_MSSQLSQLEXPRESS_MSSQLSQLEXPRESSDatabaseMirroring WMI class can be used into your custom scripts.
  VBScript »     Python »  
Win32_PerfFormattedData_MSSQLSQLEXPRESS_MSSQLSQLEXPRESSDatabases
  The Win32_PerfFormattedData_MSSQLSQLEXPRESS_MSSQLSQLEXPRESSDatabases WMI class can be used into your custom scripts.
  VBScript »     Python »  
Win32_PerfFormattedData_MSSQLSQLEXPRESS_MSSQLSQLEXPRESSDeprecatedFeatures
  The Win32_PerfFormattedData_MSSQLSQLEXPRESS_MSSQLSQLEXPRESSDeprecatedFeatures WMI class can be used into your custom scripts.
  VBScript »     Python »  
Win32_PerfFormattedData_MSSQLSQLEXPRESS_MSSQLSQLEXPRESSExecStatistics
  The Win32_PerfFormattedData_MSSQLSQLEXPRESS_MSSQLSQLEXPRESSExecStatistics WMI class can be used into your custom scripts.
  VBScript »     Python »  
Win32_PerfFormattedData_MSSQLSQLEXPRESS_MSSQLSQLEXPRESSGeneralStatistics
  The Win32_PerfFormattedData_MSSQLSQLEXPRESS_MSSQLSQLEXPRESSGeneralStatistics WMI class can be used into your custom scripts.
  VBScript »     Python »  
Win32_PerfFormattedData_MSSQLSQLEXPRESS_MSSQLSQLEXPRESSLatches
  The Win32_PerfFormattedData_MSSQLSQLEXPRESS_MSSQLSQLEXPRESSLatches WMI class can be used into your custom scripts.
  VBScript »     Python »  
Win32_PerfFormattedData_MSSQLSQLEXPRESS_MSSQLSQLEXPRESSLocks
  The Win32_PerfFormattedData_MSSQLSQLEXPRESS_MSSQLSQLEXPRESSLocks WMI class can be used into your custom scripts.
  VBScript »     Python »  
Win32_PerfFormattedData_MSSQLSQLEXPRESS_MSSQLSQLEXPRESSMemoryManager
  The Win32_PerfFormattedData_MSSQLSQLEXPRESS_MSSQLSQLEXPRESSMemoryManager WMI class can be used into your custom scripts.
  VBScript »     Python »  
Win32_PerfFormattedData_MSSQLSQLEXPRESS_MSSQLSQLEXPRESSPlanCache
  The Win32_PerfFormattedData_MSSQLSQLEXPRESS_MSSQLSQLEXPRESSPlanCache WMI class can be used into your custom scripts.
  VBScript »     Python »  
Win32_PerfFormattedData_MSSQLSQLEXPRESS_MSSQLSQLEXPRESSReplicationAgents
  The Win32_PerfFormattedData_MSSQLSQLEXPRESS_MSSQLSQLEXPRESSReplicationAgents WMI class can be used into your custom scripts.
  VBScript »     Python »  
Win32_PerfFormattedData_MSSQLSQLEXPRESS_MSSQLSQLEXPRESSReplicationDist
  The Win32_PerfFormattedData_MSSQLSQLEXPRESS_MSSQLSQLEXPRESSReplicationDist WMI class can be used into your custom scripts.
  VBScript »     Python »  
Win32_PerfFormattedData_MSSQLSQLEXPRESS_MSSQLSQLEXPRESSReplicationLogreader
  The Win32_PerfFormattedData_MSSQLSQLEXPRESS_MSSQLSQLEXPRESSReplicationLogreader WMI class can be used into your custom scripts.
  VBScript »     Python »  
Win32_PerfFormattedData_MSSQLSQLEXPRESS_MSSQLSQLEXPRESSReplicationMerge
  The Win32_PerfFormattedData_MSSQLSQLEXPRESS_MSSQLSQLEXPRESSReplicationMerge WMI class can be used into your custom scripts.
  VBScript »     Python »  
Win32_PerfFormattedData_MSSQLSQLEXPRESS_MSSQLSQLEXPRESSReplicationSnapshot
  The Win32_PerfFormattedData_MSSQLSQLEXPRESS_MSSQLSQLEXPRESSReplicationSnapshot WMI class can be used into your custom scripts.
  VBScript »     Python »  
Win32_PerfFormattedData_MSSQLSQLEXPRESS_MSSQLSQLEXPRESSResourcePoolStats
  The Win32_PerfFormattedData_MSSQLSQLEXPRESS_MSSQLSQLEXPRESSResourcePoolStats WMI class can be used into your custom scripts.
  VBScript »     Python »  
Win32_PerfFormattedData_MSSQLSQLEXPRESS_MSSQLSQLEXPRESSSQLErrors
  The Win32_PerfFormattedData_MSSQLSQLEXPRESS_MSSQLSQLEXPRESSSQLErrors WMI class can be used into your custom scripts.
  VBScript »     Python »  
Win32_PerfFormattedData_MSSQLSQLEXPRESS_MSSQLSQLEXPRESSSQLStatistics
  The Win32_PerfFormattedData_MSSQLSQLEXPRESS_MSSQLSQLEXPRESSSQLStatistics WMI class can be used into your custom scripts.
  VBScript »     Python »  
Win32_PerfFormattedData_MSSQLSQLEXPRESS_MSSQLSQLEXPRESSTransactions
  The Win32_PerfFormattedData_MSSQLSQLEXPRESS_MSSQLSQLEXPRESSTransactions WMI class can be used into your custom scripts.
  VBScript »     Python »  
Win32_PerfFormattedData_MSSQLSQLEXPRESS_MSSQLSQLEXPRESSUserSettable
  The Win32_PerfFormattedData_MSSQLSQLEXPRESS_MSSQLSQLEXPRESSUserSettable WMI class can be used into your custom scripts.
  VBScript »     Python »  
Win32_PerfFormattedData_MSSQLSQLEXPRESS_MSSQLSQLEXPRESSWaitStatistics
  The Win32_PerfFormattedData_MSSQLSQLEXPRESS_MSSQLSQLEXPRESSWaitStatistics WMI class can be used into your custom scripts.
  VBScript »     Python »  
Win32_PerfFormattedData_MSSQLSQLEXPRESS_MSSQLSQLEXPRESSWorkloadGroupStats
  The Win32_PerfFormattedData_MSSQLSQLEXPRESS_MSSQLSQLEXPRESSWorkloadGroupStats WMI class can be used into your custom scripts.
  VBScript »     Python »  
Win32_PerfFormattedData_SQLAgentSQLEXPRESS_SQLAgentSQLEXPRESSAlerts
  The Win32_PerfFormattedData_SQLAgentSQLEXPRESS_SQLAgentSQLEXPRESSAlerts WMI class can be used into your custom scripts.
  VBScript »     Python »  
Win32_PerfFormattedData_SQLAgentSQLEXPRESS_SQLAgentSQLEXPRESSJobs
  The Win32_PerfFormattedData_SQLAgentSQLEXPRESS_SQLAgentSQLEXPRESSJobs WMI class can be used into your custom scripts.
  VBScript »     Python »  
Win32_PerfFormattedData_SQLAgentSQLEXPRESS_SQLAgentSQLEXPRESSJobSteps
  The Win32_PerfFormattedData_SQLAgentSQLEXPRESS_SQLAgentSQLEXPRESSJobSteps WMI class can be used into your custom scripts.
  VBScript »     Python »  
Win32_PerfFormattedData_SQLAgentSQLEXPRESS_SQLAgentSQLEXPRESSStatistics
  The Win32_PerfFormattedData_SQLAgentSQLEXPRESS_SQLAgentSQLEXPRESSStatistics WMI class can be used into your custom scripts.
  VBScript »     Python »  
Win32_PerfRawData_MSSQLSQLEXPRESS_MSSQLSQLEXPRESSAccessMethods
  The Win32_PerfRawData_MSSQLSQLEXPRESS_MSSQLSQLEXPRESSAccessMethods WMI class can be used into your custom scripts.
  VBScript »   Powershell » Python »  
Win32_PerfRawData_MSSQLSQLEXPRESS_MSSQLSQLEXPRESSBackupDevice
  The Win32_PerfRawData_MSSQLSQLEXPRESS_MSSQLSQLEXPRESSBackupDevice WMI class can be used into your custom scripts.
  VBScript »   Powershell » Python »  
Win32_PerfRawData_MSSQLSQLEXPRESS_MSSQLSQLEXPRESSBrokerActivation
  The Win32_PerfRawData_MSSQLSQLEXPRESS_MSSQLSQLEXPRESSBrokerActivation WMI class can be used into your custom scripts.
  VBScript »   Powershell » Python »  
Win32_PerfRawData_MSSQLSQLEXPRESS_MSSQLSQLEXPRESSBrokerDBMTransport
  The Win32_PerfRawData_MSSQLSQLEXPRESS_MSSQLSQLEXPRESSBrokerDBMTransport WMI class can be used into your custom scripts.
  VBScript »   Powershell » Python »  
Win32_PerfRawData_MSSQLSQLEXPRESS_MSSQLSQLEXPRESSBrokerStatistics
  The Win32_PerfRawData_MSSQLSQLEXPRESS_MSSQLSQLEXPRESSBrokerStatistics WMI class can be used into your custom scripts.
  VBScript »   Powershell » Python »  
Win32_PerfRawData_MSSQLSQLEXPRESS_MSSQLSQLEXPRESSBrokerTOStatistics
  The Win32_PerfRawData_MSSQLSQLEXPRESS_MSSQLSQLEXPRESSBrokerTOStatistics WMI class can be used into your custom scripts.
  VBScript »     Python »  
Win32_PerfRawData_MSSQLSQLEXPRESS_MSSQLSQLEXPRESSBufferManager
  The Win32_PerfRawData_MSSQLSQLEXPRESS_MSSQLSQLEXPRESSBufferManager WMI class can be used into your custom scripts.
  VBScript »   Powershell » Python »  
Win32_PerfRawData_MSSQLSQLEXPRESS_MSSQLSQLEXPRESSBufferNode
  The Win32_PerfRawData_MSSQLSQLEXPRESS_MSSQLSQLEXPRESSBufferNode WMI class can be used into your custom scripts.
  VBScript »   Powershell » Python »  
Win32_PerfRawData_MSSQLSQLEXPRESS_MSSQLSQLEXPRESSBufferPartition
  The Win32_PerfRawData_MSSQLSQLEXPRESS_MSSQLSQLEXPRESSBufferPartition WMI class can be used into your custom scripts.
  VBScript »   Powershell » Python »  
Win32_PerfRawData_MSSQLSQLEXPRESS_MSSQLSQLEXPRESSCatalogMetadata
  The Win32_PerfRawData_MSSQLSQLEXPRESS_MSSQLSQLEXPRESSCatalogMetadata WMI class can be used into your custom scripts.
  VBScript »   Powershell » Python »  
Win32_PerfRawData_MSSQLSQLEXPRESS_MSSQLSQLEXPRESSCLR
  The Win32_PerfRawData_MSSQLSQLEXPRESS_MSSQLSQLEXPRESSCLR WMI class can be used into your custom scripts.
  VBScript »   Powershell » Python »  
Win32_PerfRawData_MSSQLSQLEXPRESS_MSSQLSQLEXPRESSCursorManagerbyType
  The Win32_PerfRawData_MSSQLSQLEXPRESS_MSSQLSQLEXPRESSCursorManagerbyType WMI class can be used into your custom scripts.
  VBScript »   Powershell » Python »  
Win32_PerfRawData_MSSQLSQLEXPRESS_MSSQLSQLEXPRESSCursorManagerTotal
  The Win32_PerfRawData_MSSQLSQLEXPRESS_MSSQLSQLEXPRESSCursorManagerTotal WMI class can be used into your custom scripts.
  VBScript »   Powershell » Python »  
Win32_PerfRawData_MSSQLSQLEXPRESS_MSSQLSQLEXPRESSDatabaseMirroring
  The Win32_PerfRawData_MSSQLSQLEXPRESS_MSSQLSQLEXPRESSDatabaseMirroring WMI class can be used into your custom scripts.
  VBScript »   Powershell » Python »  
Win32_PerfRawData_MSSQLSQLEXPRESS_MSSQLSQLEXPRESSDatabases
  The Win32_PerfRawData_MSSQLSQLEXPRESS_MSSQLSQLEXPRESSDatabases WMI class can be used into your custom scripts.
  VBScript »   Powershell » Python »  
Win32_PerfRawData_MSSQLSQLEXPRESS_MSSQLSQLEXPRESSDeprecatedFeatures
  The Win32_PerfRawData_MSSQLSQLEXPRESS_MSSQLSQLEXPRESSDeprecatedFeatures WMI class can be used into your custom scripts.
  VBScript »     Python »  
Win32_PerfRawData_MSSQLSQLEXPRESS_MSSQLSQLEXPRESSExecStatistics
  The Win32_PerfRawData_MSSQLSQLEXPRESS_MSSQLSQLEXPRESSExecStatistics WMI class can be used into your custom scripts.
  VBScript »   Powershell » Python »  
Win32_PerfRawData_MSSQLSQLEXPRESS_MSSQLSQLEXPRESSGeneralStatistics
  The Win32_PerfRawData_MSSQLSQLEXPRESS_MSSQLSQLEXPRESSGeneralStatistics WMI class can be used into your custom scripts.
  VBScript »   Powershell » Python »  
Win32_PerfRawData_MSSQLSQLEXPRESS_MSSQLSQLEXPRESSLatches
  The Win32_PerfRawData_MSSQLSQLEXPRESS_MSSQLSQLEXPRESSLatches WMI class can be used into your custom scripts.
  VBScript »   Powershell » Python »  
Win32_PerfRawData_MSSQLSQLEXPRESS_MSSQLSQLEXPRESSLocks
  The Win32_PerfRawData_MSSQLSQLEXPRESS_MSSQLSQLEXPRESSLocks WMI class can be used into your custom scripts.
  VBScript »   Powershell » Python »  
Win32_PerfRawData_MSSQLSQLEXPRESS_MSSQLSQLEXPRESSMemoryManager
  The Win32_PerfRawData_MSSQLSQLEXPRESS_MSSQLSQLEXPRESSMemoryManager WMI class can be used into your custom scripts.
  VBScript »   Powershell » Python »  
Win32_PerfRawData_MSSQLSQLEXPRESS_MSSQLSQLEXPRESSPlanCache
  The Win32_PerfRawData_MSSQLSQLEXPRESS_MSSQLSQLEXPRESSPlanCache WMI class can be used into your custom scripts.
  VBScript »   Powershell » Python »  
Win32_PerfRawData_MSSQLSQLEXPRESS_MSSQLSQLEXPRESSReplicationAgents
  The Win32_PerfRawData_MSSQLSQLEXPRESS_MSSQLSQLEXPRESSReplicationAgents WMI class can be used into your custom scripts.
  VBScript »   Powershell » Python »  
Win32_PerfRawData_MSSQLSQLEXPRESS_MSSQLSQLEXPRESSReplicationDist
  The Win32_PerfRawData_MSSQLSQLEXPRESS_MSSQLSQLEXPRESSReplicationDist WMI class can be used into your custom scripts.
  VBScript »   Powershell » Python »  
Win32_PerfRawData_MSSQLSQLEXPRESS_MSSQLSQLEXPRESSReplicationLogreader
  The Win32_PerfRawData_MSSQLSQLEXPRESS_MSSQLSQLEXPRESSReplicationLogreader WMI class can be used into your custom scripts.
  VBScript »   Powershell » Python »  
Win32_PerfRawData_MSSQLSQLEXPRESS_MSSQLSQLEXPRESSReplicationMerge
  The Win32_PerfRawData_MSSQLSQLEXPRESS_MSSQLSQLEXPRESSReplicationMerge WMI class can be used into your custom scripts.
  VBScript »   Powershell » Python »  
Win32_PerfRawData_MSSQLSQLEXPRESS_MSSQLSQLEXPRESSReplicationSnapshot
  The Win32_PerfRawData_MSSQLSQLEXPRESS_MSSQLSQLEXPRESSReplicationSnapshot WMI class can be used into your custom scripts.
  VBScript »   Powershell » Python »  
Win32_PerfRawData_MSSQLSQLEXPRESS_MSSQLSQLEXPRESSResourcePoolStats
  The Win32_PerfRawData_MSSQLSQLEXPRESS_MSSQLSQLEXPRESSResourcePoolStats WMI class can be used into your custom scripts.
  VBScript »     Python »  
Win32_PerfRawData_MSSQLSQLEXPRESS_MSSQLSQLEXPRESSSQLErrors
  The Win32_PerfRawData_MSSQLSQLEXPRESS_MSSQLSQLEXPRESSSQLErrors WMI class can be used into your custom scripts.
  VBScript »   Powershell » Python »  
Win32_PerfRawData_MSSQLSQLEXPRESS_MSSQLSQLEXPRESSSQLStatistics
  The Win32_PerfRawData_MSSQLSQLEXPRESS_MSSQLSQLEXPRESSSQLStatistics WMI class can be used into your custom scripts.
  VBScript »   Powershell » Python »  
Win32_PerfRawData_MSSQLSQLEXPRESS_MSSQLSQLEXPRESSTransactions
  The Win32_PerfRawData_MSSQLSQLEXPRESS_MSSQLSQLEXPRESSTransactions WMI class can be used into your custom scripts.
  VBScript »   Powershell » Python »  
Win32_PerfRawData_MSSQLSQLEXPRESS_MSSQLSQLEXPRESSUserSettable
  The Win32_PerfRawData_MSSQLSQLEXPRESS_MSSQLSQLEXPRESSUserSettable WMI class can be used into your custom scripts.
  VBScript »   Powershell » Python »  
Win32_PerfRawData_MSSQLSQLEXPRESS_MSSQLSQLEXPRESSWaitStatistics
  The Win32_PerfRawData_MSSQLSQLEXPRESS_MSSQLSQLEXPRESSWaitStatistics WMI class can be used into your custom scripts.
  VBScript »   Powershell » Python »  
Win32_PerfRawData_MSSQLSQLEXPRESS_MSSQLSQLEXPRESSWorkloadGroupStats
  The Win32_PerfRawData_MSSQLSQLEXPRESS_MSSQLSQLEXPRESSWorkloadGroupStats WMI class can be used into your custom scripts.
  VBScript »     Python »