IBM NETCOOL 4.3-W User Manual Page 241
- Page / 516
- Table of contents
- BOOKMARKS
Rated. / 5. Based on customer reviews
Chapter 7: Collection Formulas
Netcool/Proviso Cisco IP Telephony Technology Pack User’s Guide, Version 4.3-W 219
CCM SQL Server Cache Hit ratio (percent)
Type
SNMP (collection)
Description
The buffer cache hit ratio. The percentage of time that a requested data page was found in the data cache instead
of being read from disk.
Syntax
Dim I0 AS Integer Default * NAME Sql;
V1=OIDVAL(mssqlSrvInfoCacheHitRatio.%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® 4.3-W 1
- Trademarks 3
- Contents 5
- Contents 10
- Audience 19
- Organization 19
- Preface 20
- Chapter 1: Introduction 23
- Collection 24
- How is the Data Reported? 25
- CCM Server Quality Resource 35
- CCM Sql Server Group 36
- CCM Sql Server Resource 38
- CDR Call Distribution Group 40
- Reporter Set 41
- Tables and Charts 41
- Metrics Used in Report 41
- Navigation Path 41
- CDR Quality Detail Chart 43
- Perfmon MOH Resource 44
- CDR Quality Group 45
- CDR Quality Resource 46
- CDR Utilization Detail Chart 48
- CDR Utilization Group 49
- CDR Utilization Resource 50
- CDR VoiceMail Usage Resource 53
- Cluster Erlang-B Group 58
- Cluster IP vs Legacy Resource 60
- Cluster Quality Detail Chart 61
- Cluster Quality Group 62
- Cluster Quality Resource 63
- Global VOIP 64
- Cluster Utilization Group 66
- Cluster Utilization Resource 68
- Errors on Cluster by Codec 71
- K-Factor Detail Chart 83
- K-Factor Group 84
- K-Factor Resource 86
- Media Device Group 88
- Media Device Resource 90
- Perfmon Active Calls Group 92
- Perfmon Active Calls Resource 93
- Perfmon MOH Detail Chart 95
- Perfmon MOH Group 96
- Perfmon PSTN Detail Chart 98
- Perfmon PSTN Group 99
- Perfmon PSTN Resource 100
- Drilled Down From 101
- Perfmon Security Detail Chart 102
- Perfmon Security Group 103
- Perfmon Security Resource 104
- Chapter 2: Supported Reports 106
- Top 10 CDR Call Completion 117
- Drills Down To 118
- Top 10 CDR Call Duration 119
- Top 10 CDR K-Factor 121
- Top 10 CDR Number of Calls 123
- Top 10 CDR Number of Errors 125
- Overview 133
- Summary of Device Technology 133
- Sources of Collected Data 135
- Port for SQL Access 136
- Pre-Requisites 138
- Supported MIBs 139
- Properties 141
- AP_ifType 142
- CDRclusterId 143
- CDRcustomerId 144
- CDRsiteId 145
- Description 146
- Used in CME Formulas 146
- Used in Reports 146
- Used in Grouping Rules 146
- Element.NAME 149
- Element.STATE 150
- VoIPCallMgrClusterId 155
- VoIPCallMgrCustomerId 156
- VoIPCallMgrDSPMaxChannel 157
- VoIPCallMgrFileSystemName 158
- VoIPCallMgrGatewayIpAddress 159
- VoIPCallMgrGatewayName 160
- VoIPCallMgrGatewayType 161
- VoIPCallMgrMediaDeviceName 163
- VoIPCallMgrMediaDeviceType 164
- VoIPCallMgrProcessName 165
- VoIPCallMgrSerialOrDsp 166
- VoIPCallMgrServerDescr 167
- VoIPCallMgrServerId 168
- VoIPCallMgrServerVersion 169
- VoIPCallMgrSqlDbName 170
- VoIPDeviceType 171
- Chapter 5: Defined Resources 174
- Sub-Element Types 175
- CallManager Gateway Device 176
- CallManager Media Device 176
- CallManager Server Device 177
- CallManager Server Interface 177
- CallManager Server Process 178
- Cluster 178
- Extension 179
- Gatekeeper Device 180
- Extension (cont.) 180
- Gateway 181
- Perfmon 182
- PSTN Gateway Device 182
- PSTN Gateway DSP Card 183
- NOC Grouping 186
- Infrastructure Branch 191
- Sub-Element Collect Grouping 193
- Data Collection 198
- Formulas and Metrics 198
- Formula Reference 199
- AttendantConsoleClientsOnline 200
- Generic Database Alias 201
- Formula Editor Path 201
- AuthenticatedCallsActive 202
- AuthenticatedRegisteredPhones 204
- Availability (percent) 205
- BRIChannelsActive 206
- BRISpansInService 207
- CallDuration 208
- CallsActive 209
- CallsInProgress 210
- CauseCallRejected 211
- CauseChannelUnacceptable 212
- CauseDestinationOutOfOrder 213
- CauseInvalidNumberFormat 214
- CauseMisdialedTrunkPrefix 215
- CauseNetworkOutOfOrder 216
- CauseNoAnswerFromUser 217
- CauseNoChannelAvailable 218
- CauseNoRouteToDestination 219
- CauseNoRouteTransitNetwork 220
- CauseNoUserResponding 221
- CauseNumberChanged 222
- CauseOther 223
- CauseResourceUnavailable 224
- CauseSubscriberAbsent 225
- CauseSwitchCongestion 226
- CauseTemporaryFailure 227
- CauseUnassignedNumber 228
- CauseUserBusy 229
- SNMP (collection) 230
- V2=OIDVAL(Sum(*, %V1)); 232
- V3=OIDVAL(hrMemorySize.0); 232
- 100*(%V2/%V3) 232
- CISCO-CCM-MIB.my 233
- Sum(*, %V1) 241
- MSSQL-MIB.my 242
- Cluster Erlang 250
- ClusterForwardToVoiceMail 251
- Percentage of Drop Calls 254
- ^(duration/3600) 258
- Cluster Total Number of 259
- External Calls (Nb) 259
- ClusterIncomingCall) 262
- ClusterBlocking 265
- ClusterCallDuration 266
- ClusterCauseCallRejected 267
- ClusterCauseNetworkOutOfOrder 272
- ClusterCauseNoAnswerFromUser 273
- ClusterCauseNoUserResponding 277
- ClusterCauseNumberChanged 278
- ClusterCauseOther 279
- ClusterCauseSubscriberAbsent 281
- ClusterCauseSwitchCongestion 282
- ClusterCauseTemporaryFailure 283
- ClusterCauseUnassignedNumber 284
- ClusterCauseUserBusy 285
- ClusterDropCall 286
- ClusterErlangB 287
- ClusterErlang 288
- ClusterIncomingCall 290
- ClusterInternalCall 291
- ClusterInternationalCall 292
- ClusterIntersiteIPCall 293
- ClusterIntersiteLegacyPBXCall 294
- ClusterIntrasiteIPCall 295
- ClusterIntrasiteLegacyPBXCall 296
- ClusterJitter 297
- ClusterLatency 298
- ClusterLines 299
- ClusterLocalCall 300
- ClusterLongDistanceCall 301
- ClusterMOS 302
- ClusterNbPacketsLost 303
- ClusterNbPacketsReceived 304
- ClusterNbPacketsSent 305
- ClusterOffNetCall 306
- ClusterOnNetCall 307
- ClusterShortCall 308
- ClusterSuccessfulCall 309
- ClusterTollBypassCall 310
- ClusterTotalCall 311
- ClusterTotalHoursOfTraffic 312
- ClusterUnsuccessfulCall 313
- ClusterVoicemailCallDuration 314
- ClusterVoiceMailCall 315
- ClusterVoicemailPackets 316
- DropCall 318
- CISCO-DSP-MGMT-MIB.my 320
- EncryptedCallsActive 321
- EncryptedRegisteredPhones 323
- ForwardToVoiceMail 324
- FXOPortsActive 325
- FXOPortsInService 326
- FXSPortsActive 327
- FXSPortsInService 328
- CISCO-GATEKEEPER-MIB.my 330
- Gatekeeper Packet Errors (Nb) 334
- Gatekeeper Total Packets (Nb) 341
- GatewayCallsActive 342
- H323CallsActive 343
- H323CallsInProgress 344
- HuntlistCallsActive 345
- HuntlistCallsInProgress 346
- Inbound Loss (percent) 349
- Incoming 350
- Alias For 351
- Internal 364
- International 365
- IntersiteIPCall 366
- IntersiteLegacyPBXCall 367
- IntrasiteIPCall 368
- IntrasiteLegacyPBXCall 369
- LongDistance 375
- MOHMulticastResourceActive 379
- MOHMulticastResourceAvailable 380
- MOHTotalMulticastResources 381
- MOHTotalUnicastResources 382
- MOHUnicastResourceActive 383
- MOHUnicastResourceAvailable 384
- NbPacketsLost 386
- NbPacketsReceived 387
- NbPacketsSent 388
- Outbound Loss (percent) 391
- CISCO-POP-MGMT-MIB.my 397
- PSTN Gateway Packet Discards 407
- DEF SaveAlias 10705; 410
- V1= OIDVAL(sum(* 410
- ShortCall 423
- SIPCallsActive 424
- SIPCallsInProgress 425
- ^(100 - avail) 433
- SuccessfulCall 434
- T1ChannelsActive 435
- T1SpansInService 436
- TollbypassCallDuration 437
- TollBypassCall 438
- ^(isCaller + isCallee) 439
- ForwardToVoiceMai 441
- UnsuccessfulCall 442
- VoicemailCallDuration 443
- VoiceMailCall 444
- VoicemailPackets 445
- Discovery Formula Structure 448
- CCM_Gateway_Device 449
- CCM_Media_Device 450
- CCM_Server_Device 451
- CCM_Server_FileSystem 452
- CCM_Server_Interface 453
- CCM_Server_Process 454
- CCM_Server_SqlDatabase 455
- Gatekeeper_Device 456
- PSTN_Gateway_Device 457
- CISCO-CDP-MIB.my 458
- PSTN_Gateway_DSP_Card 459
- Appendix A: Configuration 461
- . /opt/datamart/dataMart.env 462
- Appendix A: Configuration 463
- DATA_CHANNEL_HOME/scripts 466
- Verifying Resources 477
- Topology Editor) 479
- INSTANCES 481
- Component 484
- VOIP_CISCO_IPT.CCMINPUT.URI 485
- VOIP_CISCO_IPT.CDRINPUT.URI 487
- VOIP_CISCO_IPT.DESIGNFILE 488
- VOIP_CISCO_IPT.INPUT_HOST 494
- Pack-Specific UBA Parameters 507
- <instance> 508
- Examples 509
- SCOTTY Stack 511
- BLT 2.4u 513
- CMU-SNMP 1.14 513
- UCD SNMP 4.2.5 514
- JDOM 1.0 515
- Regex 1.1a 515
- Sieve of Erastothenes 516
Related products and manuals for Software IBM NETCOOL 4.3-W
Software IBM Server OS/390 User Manual
(76 pages)
(76 pages)
Software IBM Switch 15 User Manual
(270 pages)
(270 pages)
Software IBM SC34-7012-01 User Manual
(268 pages)
(268 pages)
Software IBM SC41-5420-04 User Manual
(116 pages)
(116 pages)
Software IBM Transaction Server OS User Manual
(103 pages)
(103 pages)
Software IBM SC34-5764-01 User Manual
(481 pages)
(481 pages)
Software IBM TIVOLI SC32-0129-00 User Manual
(82 pages)
(82 pages)
Software IBM G325-2585-02 User Manual
(90 pages)
(90 pages)
Software IBM SG24-6526-00 User Manual
(184 pages)
(184 pages)
Software IBM SC33-1686-02 User Manual
(317 pages)
(317 pages)
Software IBM 5697-VM3 User Manual
(6 pages)
(6 pages)
Software IBM DS6000 User Manual
(406 pages)
(406 pages)
Software IBM CDI5UG1107 User Manual
(178 pages)
(178 pages)
Software IBM GC28-1982-02 User Manual
(216 pages)
(216 pages)
Software IBM 12.1(22)EA6 User Manual
(550 pages)
(550 pages)
© 2020, manymanuals.com. All rights reserved. | 0.103 s |
Manymanuals.com
Manymanuals.de
Manymanuals.fr
Manymanuals.it
Manymanuals.pl
Manymanuals.cz
Manymanuals.es
Manymanuals-pt.com
Comments to this Manuals