IBM NETCOOL 4.3-W - Manual (Page 240)

Chapter 7: Collection Formulas
218 Netcool/Proviso Cisco IP Telephony Technology Pack User’s Guide, Version 4.3-W
CCM SQL Server Availability percentage
Type
SNMP (collection)
Description
The availability percentage of the CallManager SQL server.
Syntax
Def DefaultNoRespResult 0;
Dim I0 AS Integer Default * NAME Sqlserver;
100 * abs( delta(sysUpTime.0) * (1 + distrib(mssqlSrvState.%I0,"==1:1,==2:-
1,==3:-1,==4:1,5==-1,6==1,7==-1") )/2 - delta(sysUpTime.0)/2 * abs(
delta(distrib(mssqlSrvState.%I0,"==1:1,==2:-1,==3:-1,==4:1,5==-1,6==1,7==-1"))/2
) ) / delta(sysUpTime.0)
Generic Database Alias
None.
Formula Editor Path
AP > Specific > SNMP > VOIP > Cisco > CCM Server > Sql Server
MIB
MSSQL-MIB.my
rfc1213-MIB-II