Chapter 7: Collection Formulas

CCM SQL Server number active user connections

Type

SNMP (collection)

Description

The total number of open user connections.

Syntax

Dim I0 AS Integer Default * NAME Sql;

V1=OIDVAL(mssqlSrvInfoUserConnections.%I0);

Sum(*, %V1)

Generic Database Alias

None.

Formula Editor Path

AP > Specific > SNMP > VOIP > Cisco > CCM Server > Sql Server

MIB

MSSQL-MIB.my

Netcool/Proviso Cisco IP Telephony Technology Pack User’s Guide, Version 4.3-W

221

Page 243
Image 243
IBM 4.3-W manual CCM SQL Server number active user connections, Total number of open user connections