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 » |