Tivoli Netcool®/Proviso® 4.
Notices This information was developed for products and services offered in the U.S.A. IBM® may not offer the products, services, or features discussed in this document in other countries. Consult your local IBM representative for information about the products and services currently available in your area. Any reference to an IBM product, program, or service is not intended to state or imply that only that IBM product, program, or service may be used.
Questions on the capabilities of non-IBM products should be addressed to the suppliers of those products. All statements regarding IBM’s future direction or intent are subject to change or withdrawal without notice, and represent goals and objectives only. This information is for planning purposes only. The information herein is subject to change before the products described become available. This information contains examples of data and reports used in daily business operations.
Contents Audience . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . xix Organization . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . xix Chapter 1: Introduction . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 1 Overview . . . . . . .
Contents Cluster Call Distribution Detail Chart . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 33 Cluster Call Distribution Group. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 34 Cluster Call Distribution Resource. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 35 Cluster Erlang-B Group . . . . . . . . . . . . . . . . . . . . . . . . .
Contents Perfmon MOH Resource . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 75 Perfmon PSTN Detail Chart . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 76 Perfmon PSTN Group . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 77 Perfmon PSTN Resource . . . . . . . . . . . . . . . . . . . . . . . .
Contents Pre-Requisites . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 116 SNMP Access . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 116 Cisco CallManager Configuration . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 116 Supported MIBs . . . . . . . . . . . . . . . . . . . . . . . . . .
Contents VoIPDeviceType. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 149 Chapter 5: Defined Resources . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 151 Overview . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .
Contents CauseMisdialedTrunkPrefix . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 193 CauseNetworkOutOfOrder . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 194 CauseNoAnswerFromUser. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 195 CauseNoChannelAvailable . . . . . . . . . . . . . . . . . . . . . . . . . .
Contents Cluster Number of Direct VoiceMail Calls (Nb). . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 229 Cluster Percentage of Company Calls (percent) . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 230 Cluster Percentage of Drop Calls (percent). . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 231 Cluster Percentage of Normal Call Clearing (percent) . . . . . . . . . . . . . . . . . . . . . . . . .
Contents ClusterErlangB . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 265 ClusterErlang. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 266 ClusterForwardToVoiceMail. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 267 ClusterIncomingCall . . . . . . . . . . . . . . . .
Contents EncryptedRegisteredPhones . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 301 ForwardToVoiceMail . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 302 FXOPortsActive . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 303 FXOPortsInService . . . . . . . . . . . . . . . . . . . . . .
Contents Interface Packet Loss (percent) . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 337 Interface Throughput In (kbps) . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 338 Interface Throughput In (kbps) . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 339 Interface Throughput Out (kbps) . . . . . . . . . . . . . . . . . . . .
Contents Percentage of Successful Calls (Nb) CME(Bulk) VOIP Cisco. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 373 Percentage of TollBypass Calls (percent) CME(Bulk) VOIP Cisco . . . . . . . . . . . . . . . . . . . . . . . . . . 374 PSTN Gateway Active DS0 Channels (Nb) (Gauge) . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 375 PSTN Gateway Active DS0 Channels (Nb) (Gauge) . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .
Contents SNMP Response Time (ms) (avg last hour). . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 409 SNMP Response Time (ms) (avg last hour). . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 410 SNMP Unavailable (percent) (avg last hour) . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 411 SuccessfulCall . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .
Contents Other Tasks and Considerations . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 455 Verifying Resources . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 455 Appendix B: UBA Parameters Reference (443, Topology Editor) . . . . . . . . . . . . . . . . . . . . . 457 UBA Parameters Reference . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .
Contents xviii Netcool/Proviso Cisco IP Telephony Technology Pack User’s Guide, Version 4.
Preface This manual describes the Netcool/Proviso Cisco IP Telephony Technology Pack, focusing on the Cisco IP Telephony environment. Specifically, the manual describes the reports for displaying information about the devices and technologies that operate in the Cisco IP Telephony environment. The manual also describes the data collection model, properties, resources, collection formulas, and metrics that the Cisco IP Telephony Technology Pack provides to create the associated reporter sets.
Preface • Chapter 4, Element and Sub-Element Properties Describes the properties that the Cisco IP Telephony Technology Pack discovers during the inventory process. • Chapter 6, Sub-Element Grouping Rules Describes the sub-element collection grouping rules and the NOC reporting grouping rules that the Cisco IP Telephony Technology Pack defines. • Chapter 5, Defined Resources Provides information about the elements and sub-elements that the technology pack defines in the Proviso database.
Preface • Netcool/Proviso Technology Packs extend the Netcool/Proviso system with service-ready reports for network operations, business development, and customer viewing. The following figure shows the different Netcool/Proviso modules. Figure 1: Netcool/Proviso Modules DataLoad collects network data. DataChannel computes aggregations and stores data in DataMart. DataMart provides data management and applications. DataView produces and manages reports.
Preface xxii Netcool/Proviso Cisco IP Telephony Technology Pack User’s Guide, Version 4.
Chapter 1: Introduction This chapter discusses the following topics: Topic Page Overview 1 How is the Data Collected? 1 How is the Data Processed and Loaded into the Database? 2 How is the Data Reported? 3 Overview Netcool/Proviso Technology Packs are individually installed modules that contain discovery, grouping, collection, and reporting instructions created by Technology Pack developers or Professional Services personnel for a specific network technology or network equipment provider, such as
Chapter 1: Introduction Technology Pack. The grouping rules use the properties and values defined within inventory formulas or adaptor design files to filter the sub-elements into their appropriate collection or reporting groups. • For non-SNMP network resources, a Technology Pack provides a Bulk Adaptor Design File. Bulk Adaptor Design Files define how data fields that reside in files generated by network resources are used to create subelements and set values for items defined as properties.
Chapter 1: Introduction CME Operation The CME is designed to work with data that is gathered over the space of one hour. Within that hour, there are several distinct phases that characterize the operation of the CME: • Loading Phase • Building Phase • Processing Phase • Output Phase Loading Phase During the beginning of each hour, the CME creates a new network configuration model based on the inventory structure that exists in the database at that time.
Chapter 1: Introduction A Technology Pack reporter set is a related group of reports that provide performance information on a specific set of devices or resources that exist in a network. Each report consists of a series of queries that retrieve related sub-elements and their corresponding metrics from the database using the RIDs and MIDs assigned during the inventory and collection processes.
Chapter 1: Introduction NOTES Netcool/Proviso Cisco IP Telephony Technology Pack User’s Guide, Version 4.
Chapter 1: Introduction 6 Netcool/Proviso Cisco IP Telephony Technology Pack User’s Guide, Version 4.
Chapter 2: Supported Reports This chapter discusses the following topics: Topic Page Overview 7 Reporter Sets 7 Reports 9 Overview The Cisco IP Telephony Technology Pack supplies a set of reports suitable for displaying information about the devices and activity associated with the Cisco IP Telephony environment. Reports contain metrics that are generated by the formulas that this technology pack provides. Metric names are the same as the names of the formulas that generate them.
Chapter 2: Supported Reports ...Infrastructure ......CallManager Server ......PSTN Gateway .........Interface .........Device .........DSP Card ......Media Devices ......Gatekeeper .........Device .........Interface ......Perfmon 8 Netcool/Proviso Cisco IP Telephony Technology Pack User’s Guide, Version 4.
Chapter 2: Supported Reports Reports This technology pack provides the following reports: CCM Server Quality Resource CCM Server Quality Resource Detail Chart CCM Sql Server Group CCM Sql Server Resource CCM Sql Server Resource Detail Chart CDR Call Distribution Detail Chart CDR Call Distribution Group CDR Call Distribution Resource CDR Quality Detail Chart CDR Quality Group CDR Quality Resource CDR Utilization Detail Chart CDR Utilization Group CDR Utilization Resource CDR VoiceMail Usage Detail Chart CDR
Chapter 2: Supported Reports Gatekeeper Availability Resource Detail Chart Gatekeeper Device Quality Resource Gatekeeper Device Quality Resource Detail Chart Gatekeeper Interface Availability Resource Gatekeeper Interface Availability Resource Detail Chart Gatekeeper Interface Utilization Resource Gatekeeper Interface Utilization Resource Detail Chart Global VOIP K-Factor Detail Chart K-Factor Group K-Factor Resource Media Device Group Media Device Resource Media Device Resource Detail Chart Perfmon Active
Chapter 2: Supported Reports PSTN Gateway E1/T1Availability Resource Top 10 CDR Call Completion Top 10 CDR Call Duration Top 10 CDR K-Factor Top 10 CDR Number of Calls Top 10 CDR Number of Errors Top 10 Cluster Call Completion Top 10 Cluster Number of Calls Top 10 Cluster Number of Errors Top 10 E1/T1 Utilization Resource The reports in this technology pack are described on the following pages. Netcool/Proviso Cisco IP Telephony Technology Pack User’s Guide, Version 4.
Chapter 2: Supported Reports CCM Server Quality Resource Detail Chart Description Detail chart showing CallManager cluster and server quality.
Chapter 2: Supported Reports CCM Server Quality Resource Description Resource summary chart showing CallManager cluster and server quality.
Chapter 2: Supported Reports CCM Sql Server Group Description Group summary chart showing CallManager SQL server usage.
Chapter 2: Supported Reports CCM Sql Server Resource Detail Chart Description Detail chart showing CallManager SQL server usage.
Chapter 2: Supported Reports CCM Sql Server Resource Description Resource summary chart showing CallManager SQL server usage.
Chapter 2: Supported Reports CDR Call Distribution Detail Chart Description Detail chart showing the specific sub-element call distribution based on information collected through CDRs and CMRs.
Chapter 2: Supported Reports CDR Call Distribution Group Description Group summary chart showing the specific sub-element call distribution based on information collected through CDRs and CMRs.
Chapter 2: Supported Reports CDR Call Distribution Resource Description Resource summary chart showing the specific sub-element call distribution based on information collected through CDRs and CMRs.
Chapter 2: Supported Reports NOC Reporting > VOIP > Cisco > IP Telephony Call Detail Record > Extensions > By Customer > %(CDRcustomerId) NOC Reporting > VOIP > Cisco > IP Telephony Call Detail Record > Extensions > By Site > %(CDRsiteId) NOC Reporting > VOIP > Cisco > IP Telephony Call Detail Record > Media Gateways > By Cluster > %(CDRclusterId) NOC Reporting > VOIP > Cisco > IP Telephony Call Detail Record > Media Gateways > By Customer > %(CDRcustomerId) NOC Reporting > VOIP > Cisco > IP Telephony Call
Chapter 2: Supported Reports CDR Quality Detail Chart Description Detail chart showing the specific sub-element quality based on information collected through Call Detail records (call signaling) and Call Maintenance Records.
Chapter 2: Supported Reports Perfmon MOH Resource Perfmon PSTN Resource Perfmon Security Resource Top 10 CDR Call Completion Top 10 CDR Number of Errors 22 Netcool/Proviso Cisco IP Telephony Technology Pack User’s Guide, Version 4.
Chapter 2: Supported Reports CDR Quality Group Description Group summary chart showing the specific sub-element quality based on information collected through Call Detail records (call signaling) and Call Maintenance Records.
Chapter 2: Supported Reports CDR Quality Resource Description Resource summary chart showing the specific sub-element quality based on information collected through Call Detail records (call signaling) and Call Maintenance Records.
Chapter 2: Supported Reports NOC Reporting > VOIP > Cisco > IP Telephony Call Detail Record > Extensions > By Cluster > %(CDRclusterId) NOC Reporting > VOIP > Cisco > IP Telephony Call Detail Record > Extensions > By Customer > %(CDRcustomerId) NOC Reporting > VOIP > Cisco > IP Telephony Call Detail Record > Extensions > By Site > %(CDRsiteId) NOC Reporting > VOIP > Cisco > IP Telephony Call Detail Record > Media Gateways > By Cluster > %(CDRclusterId) NOC Reporting > VOIP > Cisco > IP Telephony Call Detai
Chapter 2: Supported Reports CDR Utilization Detail Chart Description Detail chart showing the specific sub-element utilization based on information collected through CDRs and CMRs.
Chapter 2: Supported Reports CDR Utilization Group Description Group summary chart showing the specific sub-element utilization based on information collected through CDRs and CMRs.
Chapter 2: Supported Reports CDR Utilization Resource Description Resource summary chart showing the specific sub-element utilization based on information collected through CDRs and CMRs.
Chapter 2: Supported Reports NOC Reporting > VOIP > Cisco > IP Telephony Call Detail Record > Extensions > By Customer > %(CDRcustomerId) NOC Reporting > VOIP > Cisco > IP Telephony Call Detail Record > Extensions > By Site > %(CDRsiteId) NOC Reporting > VOIP > Cisco > IP Telephony Call Detail Record > Media Gateways > By Cluster > %(CDRclusterId) NOC Reporting > VOIP > Cisco > IP Telephony Call Detail Record > Media Gateways > By Customer > %(CDRcustomerId) NOC Reporting > VOIP > Cisco > IP Telephony Call
Chapter 2: Supported Reports CDR VoiceMail Usage Detail Chart Description Detail chart showing the specific sub-element voicemail utilization based on information collected through CDRs and CMRs.
Chapter 2: Supported Reports CDR VoiceMail Usage Resource Description Resource summary chart showing the specific sub-element voicemail utilization based on information collected through CDRs and CMRs.
Chapter 2: Supported Reports NOC Reporting > VOIP > Cisco > IP Telephony Call Detail Record > Extensions > By Site > %(CDRsiteId) NOC Reporting > VOIP > Cisco > IP Telephony Call Detail Record > Media Gateways > By Cluster > %(CDRclusterId) NOC Reporting > VOIP > Cisco > IP Telephony Call Detail Record > Media Gateways > By Customer > %(CDRcustomerId) NOC Reporting > VOIP > Cisco > IP Telephony Call Detail Record > Media Gateways > By Site > %(CDRsiteId) NOC Reporting > VOIP > Cisco > IP Telephony Call Det
Chapter 2: Supported Reports Cluster Call Distribution Detail Chart Description Detail chart showing cluster call distribution based on information collected through CDRs and CMRs.
Chapter 2: Supported Reports Cluster Call Distribution Group Description Group summary chart showing cluster call distribution based on information collected through CDRs and CMRs.
Chapter 2: Supported Reports Cluster Call Distribution Resource Description Resource summary chart showing cluster call distribution based on information collected through CDRs and CMRs.
Chapter 2: Supported Reports Cluster Erlang-B Group Description Group summary report for predicting call loss in a cluster.
Chapter 2: Supported Reports Cluster IP vs Legacy Detail Chart Description Detail chart showing cluster company call distribution based on information collected through CDRs and CMRs.
Chapter 2: Supported Reports Cluster IP vs Legacy Resource Description Resource summary chart showing cluster company call distribution based on information collected through CDRs and CMRs.
Chapter 2: Supported Reports Cluster Quality Detail Chart Description Detail chart showing cluster quality based on information collected through Call Detail Records (call signaling) and Call Maintenance Records.
Chapter 2: Supported Reports Cluster Quality Group Description Group summary chart showing cluster quality based on information collected through Call Detail Records (call signaling) and Call Maintenance Records.
Chapter 2: Supported Reports Cluster Quality Resource Description Resource summary chart showing cluster quality based on information collected through Call Detail Records (call signaling) and Call Maintenance Records.
Chapter 2: Supported Reports Global VOIP 42 Netcool/Proviso Cisco IP Telephony Technology Pack User’s Guide, Version 4.
Chapter 2: Supported Reports Cluster Utilization Detail Chart Description Detail chart showing cluster utilization based on information collected through CDRs and CMRs.
Chapter 2: Supported Reports Cluster Utilization Group Description Group summary chart showing cluster utilization based on information collected through CDRs and CMRs.
Chapter 2: Supported Reports Cluster Utilization MLH Resource Description Resource summary report showing cluster utilization based on multi-line hunt (MLH) metrics. Reporter Set Cluster Tables and Charts No table and chart information is available for this report (stylesheet PVLsRatio_MLH_RST.html).
Chapter 2: Supported Reports Cluster Utilization Resource Description Resource summary chart showing cluster utilization based on information collected through CDRs and CMRs.
Chapter 2: Supported Reports Cluster VoiceMail Usage Detail Chart Description Detail chart showing cluster voicemail utilization based on information collected through CDRs and CMRs.
Chapter 2: Supported Reports Cluster VoiceMail Usage Resource Description Resource summary chart showing cluster voicemail utilization based on information collected through CDRs and CMRs.
Chapter 2: Supported Reports Errors on Cluster by Codec Description Resource summary report for codec errors in a cluster.
Chapter 2: Supported Reports NOC Reporting > VOIP > Cisco > IP Telephony Call Detail Record > Codec > By Cluster > %(clusterId) NOC Reporting > VOIP > Cisco > IP Telephony Call Detail Record > Codec > By Cluster > %(CDRclusterId) Drills Down To CDR Quality Detail Chart Drilled Down From None. 50 Netcool/Proviso Cisco IP Telephony Technology Pack User’s Guide, Version 4.
Chapter 2: Supported Reports Gatekeeper Availability Resource Detail Chart Description Detail chart based on gatekeeper device reachability and response time.
Chapter 2: Supported Reports Gatekeeper Availability Resource Description Resource summary chart based on gatekeeper device reachability and response time.
Chapter 2: Supported Reports Gatekeeper Device Quality Resource Detail Chart Description Detail chart based on gatekeeper device CPU utilization and network errors.
Chapter 2: Supported Reports Gatekeeper Device Quality Resource Description Resource summary chart based on gatekeeper device CPU utilization and network errors.
Chapter 2: Supported Reports Gatekeeper Interface Availability Resource Detail Chart Description Detail chart showing gatekeeper’s interface availability percentage.
Chapter 2: Supported Reports Gatekeeper Interface Availability Resource Description Resource summary chart showing gatekeeper’s interface availability percentage.
Chapter 2: Supported Reports Gatekeeper Interface Utilization Resource Detail Chart Description Detail chart showing gatekeeper’s interface bandwidth utilization percentage.
Chapter 2: Supported Reports Gatekeeper Interface Utilization Resource Description Resource summary chart showing gatekeeper’s interface bandwidth utilization percentage.
Chapter 2: Supported Reports Global VOIP Description A multi-technologies report that targets the customerís decision maker. In a single view, the decision maker will have a global overview about the quality of the IP Telephony application in terms of call setup and termination, voice quality, network infrastructure, and system and service performances. Reporter Set Global Customer Reports Tables and Charts No table and chart information is available for this report (stylesheet PVLs_Cisco_VOIP_Global.
Chapter 2: Supported Reports Cluster Utilization Resource PSTN Gateway Device Quality Resource Detail Chart Top 10 E1/T1 Utilization Resource Drilled Down From None. 60 Netcool/Proviso Cisco IP Telephony Technology Pack User’s Guide, Version 4.
Chapter 2: Supported Reports K-Factor Detail Chart Description Detail report on listening quality using ITU-standard K-Factor metrics. Reporter Set K-Factor Tables and Charts Charts: Resource Time Series Chart (5 of 8 implemented) Metric Ratio Chart (0 of 2 implemented) Metrics Used in Report CCR CS ICR ICRmx SCS Navigation Path This report is not deployed on the portal navigation path during the initial configuration of the technology pack.
Chapter 2: Supported Reports K-Factor Group Description Group summary report on listening quality using ITU-standard K-Factor metrics.
Chapter 2: Supported Reports Drilled Down From None. Netcool/Proviso Cisco IP Telephony Technology Pack User’s Guide, Version 4.
Chapter 2: Supported Reports K-Factor Resource Description Resource summary report on listening quality using ITU-standard K-Factor metrics.
Chapter 2: Supported Reports NOC Reporting > VOIP > Cisco > IP Telephony Call Detail Record > Extensions > By Cluster > %(CDRclusterId) NOC Reporting > VOIP > Cisco > IP Telephony Call Detail Record > Extensions > By Customer > %(CDRcustomerId) NOC Reporting > VOIP > Cisco > IP Telephony Call Detail Record > Extensions > By Site > %(CDRsiteId) Drills Down To CDR Quality Detail Chart K-Factor Detail Chart Drilled Down From K-Factor Group Netcool/Proviso Cisco IP Telephony Technology Pack User’s Guide, Ve
Chapter 2: Supported Reports Media Device Group Description Group summary chart showing the media device’s registration availability percentage.
Chapter 2: Supported Reports Media Device Resource Detail Chart Description Detail chart showing the media device’s registration availability percentage. Reporter Set Media Devices Tables and Charts Charts: Resource Time Series Chart (1 of 8 implemented) Metric Ratio Chart (0 of 2 implemented) Metrics Used in Report CCM Media Device Registration Availability (percent) Navigation Path This report is not deployed on the portal navigation path during the initial configuration of the technology pack.
Chapter 2: Supported Reports Media Device Resource Description Resource summary chart showing the media device’s registration availability percentage.
Chapter 2: Supported Reports Perfmon Active Calls Detail Chart Description Detail report for Microsoft performance counter metrics.
Chapter 2: Supported Reports Perfmon Active Calls Group Description Group summary report for Microsoft performance counter metrics.
Chapter 2: Supported Reports Perfmon Active Calls Resource Description Resource summary report for Microsoft performance counter metrics.
Chapter 2: Supported Reports Drilled Down From Perfmon Active Calls Group Perfmon MOH Group Perfmon PSTN Group Perfmon Security Group 72 Netcool/Proviso Cisco IP Telephony Technology Pack User’s Guide, Version 4.
Chapter 2: Supported Reports Perfmon MOH Detail Chart Description Detail report for Perfmon Music on Hold (MOH) counter metrics.
Chapter 2: Supported Reports Perfmon MOH Group Description Group summary report for Perfmon Music on Hold (MOH) counter metrics.
Chapter 2: Supported Reports Perfmon MOH Resource Description Resource summary report for Perfmon Music on Hold (MOH) counter metrics.
Chapter 2: Supported Reports Perfmon PSTN Detail Chart Description Detail report for Perfmon PSTN counter metrics. Reporter Set Perfmon Tables and Charts Charts: Resource Time Series Chart (8 of 9 implemented) Metrics Used in Report BRIChannelsActive BRISpansInService FXOPortsActive FXOPortsInService FXSPortsActive FXSPortsInService T1ChannelsActive T1SpansInService Navigation Path This report is not deployed on the portal navigation path during the initial configuration of the technology pack.
Chapter 2: Supported Reports Perfmon PSTN Group Description Group summary report for Perfmon PSTN counter metrics.
Chapter 2: Supported Reports Perfmon PSTN Resource Description Resource summary report for Perfmon PSTN counter metrics.
Chapter 2: Supported Reports Drilled Down From Perfmon PSTN Group Netcool/Proviso Cisco IP Telephony Technology Pack User’s Guide, Version 4.
Chapter 2: Supported Reports Perfmon Security Detail Chart Description Detail chart for Perfmon counter metrics on active calls.
Chapter 2: Supported Reports Perfmon Security Group Description Group summary report for Perfmon security metrics.
Chapter 2: Supported Reports Perfmon Security Resource Description Resource summary report for Perfmon security metrics.
Chapter 2: Supported Reports Drilled Down From Perfmon Security Group Netcool/Proviso Cisco IP Telephony Technology Pack User’s Guide, Version 4.
Chapter 2: Supported Reports PSTN Gateway Availability Resource Detail Chart Description Detail chart based on PSTN gateway errors and availability on the network.
Chapter 2: Supported Reports PSTN Gateway Availability Resource Description Resource summary chart based on PSTN gateway errors and availability on the network.
Chapter 2: Supported Reports PSTN Gateway Device DS0 Usage Detail Chart Description Detail chart showing PSTN gateway DS0 usage and quality.
Chapter 2: Supported Reports PSTN Gateway Device Quality Resource Detail Chart Description Detail chart showing PSTN gateway CPU utilization, number of packets, and errors.
Chapter 2: Supported Reports PSTN Gateway Device Quality Resource Description Resource summary chart showing PSTN gateway CPU utilization, number of packets, and errors.
Chapter 2: Supported Reports PSTN Gateway DSP Card Resource Detail Chart Description Detail chart showing DSP card utlization percentage. Reporter Set DSP Card Tables and Charts Charts: Resource Time Series Chart (2 of 8 implemented) Metric Ratio Chart (0 of 2 implemented) Metrics Used in Report DSP Card Availability (percent) DSP Card Resource Utilization (percent) Navigation Path This report is not deployed on the portal navigation path during the initial configuration of the technology pack.
Chapter 2: Supported Reports PSTN Gateway DSP Card Resource Description Resource summary chart showing DSP card utlization percentage.
Chapter 2: Supported Reports PSTN Gateway E1/T1 Availability Resource Detail Chart Description Detail chart showing E1 or T1 interface availability. Reporter Set Interface Tables and Charts Charts: Resource Time Series Chart (2 of 8 implemented) Metric Ratio Chart (0 of 2 implemented) Metrics Used in Report Interface Availability (percent) Interface Packet Loss (percent) Navigation Path This report is not deployed on the portal navigation path during the initial configuration of the technology pack.
Chapter 2: Supported Reports PSTN Gateway E1/T1 Interface Utilization Resource Detail Chart Description Detail chart showing E1 or T1 interface utilization percentage.
Chapter 2: Supported Reports PSTN Gateway E1/T1 Interface Utilization Resource Description Resource summary chart showing E1 or T1 interface utilization percentage.
Chapter 2: Supported Reports PSTN Gateway E1/T1Availability Resource Description Resource summary chart showing E1 or T1 interface availability.
Chapter 2: Supported Reports Top 10 CDR Call Completion Description Top 10 and bottom 10 extensions, gateways, or paths based on successful or unsuccessful calls.
Chapter 2: Supported Reports NOC Reporting > VOIP > Cisco > IP Telephony Call Detail Record > Media Gateways > By Site > %(CDRsiteId) NOC Reporting > VOIP > Cisco > IP Telephony Call Detail Record > Paths > By Cluster > %(CDRclusterId) NOC Reporting > VOIP > Cisco > IP Telephony Call Detail Record > Paths > By Customer > %(CDRcustomerId) Drills Down To CDR Quality Detail Chart Drilled Down From None. 96 Netcool/Proviso Cisco IP Telephony Technology Pack User’s Guide, Version 4.
Chapter 2: Supported Reports Top 10 CDR Call Duration Description Top 10 extensions, gateways, or paths based on total call duration.
Chapter 2: Supported Reports NOC Reporting > VOIP > Cisco > IP Telephony Call Detail Record > Media Gateways > By Site > %(CDRsiteId) NOC Reporting > VOIP > Cisco > IP Telephony Call Detail Record > Paths > By Cluster > %(CDRclusterId) NOC Reporting > VOIP > Cisco > IP Telephony Call Detail Record > Paths > By Customer > %(CDRcustomerId) Drills Down To CDR Utilization Detail Chart Drilled Down From None. 98 Netcool/Proviso Cisco IP Telephony Technology Pack User’s Guide, Version 4.
Chapter 2: Supported Reports Top 10 CDR K-Factor Description Top-10 CDR data using IDU-standard K-factor metrics.
Chapter 2: Supported Reports Drills Down To K-Factor Detail Chart Drilled Down From None. 100 Netcool/Proviso Cisco IP Telephony Technology Pack User’s Guide, Version 4.
Chapter 2: Supported Reports Top 10 CDR Number of Calls Description Top 10 extensions, gateways, or paths based on total number of incoming or outgoing calls to PSTN.
Chapter 2: Supported Reports NOC Reporting > VOIP > Cisco > IP Telephony Call Detail Record > Media Gateways > By Cluster > %(CDRclusterId) NOC Reporting > VOIP > Cisco > IP Telephony Call Detail Record > Media Gateways > By Customer > %(CDRcustomerId) NOC Reporting > VOIP > Cisco > IP Telephony Call Detail Record > Media Gateways > By Site > %(CDRsiteId) NOC Reporting > VOIP > Cisco > IP Telephony Call Detail Record > Paths > By Cluster > %(CDRclusterId) NOC Reporting > VOIP > Cisco > IP Telephony Call De
Chapter 2: Supported Reports Top 10 CDR Number of Errors Description Top 10 extensions, gateways, or paths based on total number of errors.
Chapter 2: Supported Reports NOC Reporting > VOIP > Cisco > IP Telephony Call Detail Record > Media Gateways > By Cluster > %(CDRclusterId) NOC Reporting > VOIP > Cisco > IP Telephony Call Detail Record > Media Gateways > By Customer > %(CDRcustomerId) NOC Reporting > VOIP > Cisco > IP Telephony Call Detail Record > Media Gateways > By Site > %(CDRsiteId) NOC Reporting > VOIP > Cisco > IP Telephony Call Detail Record > Paths > By Cluster > %(CDRclusterId) NOC Reporting > VOIP > Cisco > IP Telephony Call De
Chapter 2: Supported Reports Top 10 Cluster Call Completion Description Top 10 and bottom 10 clusters based on the percentage of successful calls.
Chapter 2: Supported Reports Top 10 Cluster Number of Calls Description Top 10 clusters based on number of incoming and outgoing calls.
Chapter 2: Supported Reports Top 10 Cluster Number of Errors Description Top 10 cluster based on number of errors.
Chapter 2: Supported Reports Top 10 E1/T1 Utilization Resource Description Top 10 E1 or T1 interfaces based on bandwidth utilization percentage.
Chapter 2: Supported Reports NOTES Netcool/Proviso Cisco IP Telephony Technology Pack User’s Guide, Version 4.
Chapter 2: Supported Reports 110 Netcool/Proviso Cisco IP Telephony Technology Pack User’s Guide, Version 4.
Chapter 3: Devices and Services This chapter discusses the following topics: Topic Page Overview 111 Summary of Device Technology 111 Sources of Collected Data 113 Pre-Requisites 116 Supported MIBs 117 Overview This chapter provides a summary of Cisco IP Telephony device technology that the Cisco IP Telephony Technology Pack is designed to support.
Chapter 3: Devices and Services Categories of Service Reporting The technology pack provides the following categories of service reporting: • Voice Quality Management — Latency, jitter, packet loss, network bandwidth, Class Based QoS, and element availability. • Call Signaling Management — Call setup and termination metrics, based on data from Call Detail Records (CDRs). • Converged Network Infrastructure Management — Network and system devices in charge of the Service and Voice Data Packets Delivery.
Chapter 3: Devices and Services Sources of Collected Data The Netcool/Proviso Cisco IP Telephony Technology Pack uses both SNMP and bulk data collection.
Chapter 3: Devices and Services The following figure illustrates the technology pack’s data collection architecture in a CCM environment: Port for SQL Access CallManager Publisher runs on an MS-SQL2000 server. To collect SQL data from the CallManager Publisher, an SQL bridge must be set up on the machine where Netcool/Proviso DataLoad resides. This bridge is provided as part of the Netcool/Proviso Cisco IP Telephony Technology Pack.
Chapter 3: Devices and Services • With pre-4.4.3 Netcool/Proviso versions, ensure that the dc.cfg file contains a URI for each CCM Publisher bulk adaptor, and that the URI matches the URI of the associated data source in the odbc.ini file. Collecting CDR, CMR, and Perfmon Data with Cisco Unified Call Manager With Cisco Unified CallManager (CUCM), the technology pack collects CDR, CMR, and Perfmon data files in either of the following ways: • Through SOAP requests to the CUCM server and PerfmonPorts API.
Chapter 3: Devices and Services Pre-Requisites This section describes the pre-requisites for the Netcool/Proviso Cisco IP Telephony Technology Pack. SNMP Access The Netcool/Proviso Cisco IP Telephony Technology Pack needs read access to SNMP agents of PSTN gateway, gatekeeper, and CallManager Server devices. Customers must provide a valid IP address and community name to access these devices. UDP Port number 161 needs to be open in the remote firewalls.
Chapter 3: Devices and Services In addition, the following enterprise parameters must be set: • LocalCDRPath — A directory for local CDR files written by Cisco CallManager. If this value is empty or invalid, the CDR files will not be moved. • PrimaryCDRUNCPath — A central collection point for CDR files. If this value is empty or invalid, the CDR files will not be moved. The installation procedure sets this parameter.
Chapter 3: Devices and Services NOTES 118 Netcool/Proviso Cisco IP Telephony Technology Pack User’s Guide, Version 4.
Chapter 4: Element and Sub-Element Properties This chapter discusses the following topics: Topic Page Overview 119 Overview Note: To see a list of the properties that this technology pack defines for each of the sub-element it creates, see the chapter on defined resources. A Netcool/Proviso property is an attribute or characteristic of an element or sub-element.
Chapter 4: Element and Sub-Element Properties AP_ifType Description Open-format name of the specific type of resource represented (for example, Ethernet and DS1). Captured in Discovery Formulas None. Used in CME Formulas None. Used in Reports None. Used in Grouping Rules NOC Reporting Sub-Element Collect 120 Netcool/Proviso Cisco IP Telephony Technology Pack User’s Guide, Version 4.
Chapter 4: Element and Sub-Element Properties CDRclusterId Description The cluster identifier. Used with bulk data. Captured in Discovery Formulas None. Used in CME Formulas None. Used in Reports None. Used in Grouping Rules NOC Reporting Netcool/Proviso Cisco IP Telephony Technology Pack User’s Guide, Version 4.
Chapter 4: Element and Sub-Element Properties CDRcustomerId Description The customer identifier. Used with bulk data. Captured in Discovery Formulas None. Used in CME Formulas None. Used in Reports None. Used in Grouping Rules NOC Reporting 122 Netcool/Proviso Cisco IP Telephony Technology Pack User’s Guide, Version 4.
Chapter 4: Element and Sub-Element Properties CDRsiteId Description The site identifier. Used with bulk data. Captured in Discovery Formulas None. Used in CME Formulas None. Used in Reports None. Used in Grouping Rules NOC Reporting Netcool/Proviso Cisco IP Telephony Technology Pack User’s Guide, Version 4.
Chapter 4: Element and Sub-Element Properties cdrType Description The type of Call Detail Record (CDR) — for example, Extension, Gateway, Path. Used with bulk data. Captured in Discovery Formulas None. Used in CME Formulas None. Used in Reports CDR Quality Detail Chart CDR Utilization Resource K-Factor Detail Chart Used in Grouping Rules None. 124 Netcool/Proviso Cisco IP Telephony Technology Pack User’s Guide, Version 4.
Chapter 4: Element and Sub-Element Properties clusterId Description This property has been replaced by CDRclusterId. Captured in Discovery Formulas None. Used in CME Formulas None. Used in Reports None. Used in Grouping Rules NOC Reporting Netcool/Proviso Cisco IP Telephony Technology Pack User’s Guide, Version 4.
Chapter 4: Element and Sub-Element Properties customerId Description This property has been replaced by CDRcustomerId. Captured in Discovery Formulas None. Used in CME Formulas None. Used in Reports None. Used in Grouping Rules NOC Reporting 126 Netcool/Proviso Cisco IP Telephony Technology Pack User’s Guide, Version 4.
Chapter 4: Element and Sub-Element Properties Element.NAME Description The name of a Cisco IP element. Captured in Discovery Formulas None. Used in CME Formulas None. Used in Reports None. Used in Grouping Rules NOC Reporting Netcool/Proviso Cisco IP Telephony Technology Pack User’s Guide, Version 4.
Chapter 4: Element and Sub-Element Properties Element.STATE Description Indicates whether an element is active. Captured in Discovery Formulas None. Used in CME Formulas None. Used in Reports None. Used in Grouping Rules NOC Reporting Sub-Element Collect 128 Netcool/Proviso Cisco IP Telephony Technology Pack User’s Guide, Version 4.
Chapter 4: Element and Sub-Element Properties FAMILY Description Identifies a sub-element for reporting and sub-element grouping purposes. Captured in Discovery Formulas None. Used in CME Formulas None. Used in Reports None. Used in Grouping Rules NOC Reporting Sub-Element Collect Netcool/Proviso Cisco IP Telephony Technology Pack User’s Guide, Version 4.
Chapter 4: Element and Sub-Element Properties NAME Description The path name of collected path sub-elements. Captured in Discovery Formulas None. Used in CME Formulas None. Used in Reports None. Used in Grouping Rules NOC Reporting 130 Netcool/Proviso Cisco IP Telephony Technology Pack User’s Guide, Version 4.
Chapter 4: Element and Sub-Element Properties siteId Description This property has been replaced by CDRsiteId. Captured in Discovery Formulas None. Used in CME Formulas None. Used in Reports None. Used in Grouping Rules NOC Reporting Netcool/Proviso Cisco IP Telephony Technology Pack User’s Guide, Version 4.
Chapter 4: Element and Sub-Element Properties STATE Description Indicates whether the entry is active. Captured in Discovery Formulas None. Used in CME Formulas None. Used in Reports None. Used in Grouping Rules NOC Reporting Sub-Element Collect 132 Netcool/Proviso Cisco IP Telephony Technology Pack User’s Guide, Version 4.
Chapter 4: Element and Sub-Element Properties VoIPCallMgrClusterId Description The cluster ID. This value is based on the following MIB values: • ccmClusterId, with CallManager devices. • sysLocation, with PSTN Gateway devices. Captured in Discovery Formulas CCM_Gateway_Device CCM_Media_Device CCM_Server_Device CCM_Server_FileSystem CCM_Server_Interface CCM_Server_Process CCM_Server_SqlDatabase PSTN_Gateway_Device PSTN_Gateway_DSP_Card Used in CME Formulas None. Used in Reports None.
Chapter 4: Element and Sub-Element Properties VoIPCallMgrCustomerId Description The customer ID. This value is based on the following MIB values: • sysName, with PSTN Gateway E1/T1 interfaces and PSTN Gateway DSP. • cdpCacheVTPMgmtDomain, with other PSTN Gateway devices. Captured in Discovery Formulas CCM_Server_Interface PSTN_Gateway_Device PSTN_Gateway_DSP_Card Used in CME Formulas None. Used in Reports None. Used in Grouping Rules None.
Chapter 4: Element and Sub-Element Properties VoIPCallMgrDSPMaxChannel Description The maximum number of channels allowed in each DSP. The value of this property is based on the MIB object cdspCardMaxChanPerDSP. Captured in Discovery Formulas PSTN_Gateway_DSP_Card Used in CME Formulas None. Used in Reports None. Used in Grouping Rules None. Netcool/Proviso Cisco IP Telephony Technology Pack User’s Guide, Version 4.
Chapter 4: Element and Sub-Element Properties VoIPCallMgrFileSystemName Description The file server name, based on the MIB value hrStorageDescr. Captured in Discovery Formulas CCM_Server_FileSystem Used in CME Formulas None. Used in Reports None. Used in Grouping Rules None. 136 Netcool/Proviso Cisco IP Telephony Technology Pack User’s Guide, Version 4.
Chapter 4: Element and Sub-Element Properties VoIPCallMgrGatewayIpAddress Description The last known IP Address of the gateway. The value of this property is based on the MIB object ccmGatewayInetAddress. Captured in Discovery Formulas CCM_Gateway_Device Used in CME Formulas None. Used in Reports None. Used in Grouping Rules None. Netcool/Proviso Cisco IP Telephony Technology Pack User’s Guide, Version 4.
Chapter 4: Element and Sub-Element Properties VoIPCallMgrGatewayName Description The name that the CallManager assigns to the gateway. Captured in Discovery Formulas CCM_Gateway_Device Used in CME Formulas None. Used in Reports None. Used in Grouping Rules None. 138 Netcool/Proviso Cisco IP Telephony Technology Pack User’s Guide, Version 4.
Chapter 4: Element and Sub-Element Properties VoIPCallMgrGatewayType Description The gateway type. This value is based on the MIB object ccmGatewayType. Captured in Discovery Formulas CCM_Gateway_Device Used in CME Formulas None. Used in Reports None. Used in Grouping Rules None. Netcool/Proviso Cisco IP Telephony Technology Pack User’s Guide, Version 4.
Chapter 4: Element and Sub-Element Properties VoIPCallMgrMediaDeviceIpAddress Description The media device IP address, based on the MIB value ccmMediaDeviceInetAddress. Captured in Discovery Formulas CCM_Media_Device Used in CME Formulas None. Used in Reports None. Used in Grouping Rules None. 140 Netcool/Proviso Cisco IP Telephony Technology Pack User’s Guide, Version 4.
Chapter 4: Element and Sub-Element Properties VoIPCallMgrMediaDeviceName Description The media device name, based on the MIB value ccmMediaDeviceDescription. Captured in Discovery Formulas CCM_Media_Device Used in CME Formulas None. Used in Reports None. Used in Grouping Rules None. Netcool/Proviso Cisco IP Telephony Technology Pack User’s Guide, Version 4.
Chapter 4: Element and Sub-Element Properties VoIPCallMgrMediaDeviceType Description The media device type, based on the MIB value ccmMediaDeviceType. Captured in Discovery Formulas CCM_Media_Device Used in CME Formulas None. Used in Reports None. Used in Grouping Rules None. 142 Netcool/Proviso Cisco IP Telephony Technology Pack User’s Guide, Version 4.
Chapter 4: Element and Sub-Element Properties VoIPCallMgrProcessName Description The CallManager Server process identifier, based on the MIB value hrSWRunName. Captured in Discovery Formulas CCM_Server_Process Used in CME Formulas None. Used in Reports None. Used in Grouping Rules None. Netcool/Proviso Cisco IP Telephony Technology Pack User’s Guide, Version 4.
Chapter 4: Element and Sub-Element Properties VoIPCallMgrSerialOrDsp Description Indicates a voice device. Captured in Discovery Formulas None. Used in CME Formulas None. Used in Reports None. Used in Grouping Rules NOC Reporting Sub-Element Collect 144 Netcool/Proviso Cisco IP Telephony Technology Pack User’s Guide, Version 4.
Chapter 4: Element and Sub-Element Properties VoIPCallMgrServerDescr Description The CallManager Server description, based on the MIB value ccmDescription. Captured in Discovery Formulas CCM_Server_Device Used in CME Formulas None. Used in Reports None. Used in Grouping Rules None. Netcool/Proviso Cisco IP Telephony Technology Pack User’s Guide, Version 4.
Chapter 4: Element and Sub-Element Properties VoIPCallMgrServerId Description The CallManager Server ID. This value is based on the following MIB values: • • cdpGlobalDeviceId, with CallManager Server devices. cdpCacheDeviceId, with Win2000 server PSTN Gateway devices that are registered to the CallManager Server. Captured in Discovery Formulas CCM_Server_Device Used in CME Formulas None. Used in Reports None. Used in Grouping Rules None.
Chapter 4: Element and Sub-Element Properties VoIPCallMgrServerVersion Description The CallManager Server version, based on the MIB value ccmVersion. Captured in Discovery Formulas CCM_Server_Device Used in CME Formulas None. Used in Reports None. Used in Grouping Rules None. Netcool/Proviso Cisco IP Telephony Technology Pack User’s Guide, Version 4.
Chapter 4: Element and Sub-Element Properties VoIPCallMgrSqlDbName Description The CallManager Server SQL database name, based on the MIB value mssqlDbInfoDbName. Captured in Discovery Formulas CCM_Server_SqlDatabase Used in CME Formulas None. Used in Reports None. Used in Grouping Rules None. 148 Netcool/Proviso Cisco IP Telephony Technology Pack User’s Guide, Version 4.
Chapter 4: Element and Sub-Element Properties VoIPDeviceType Description One of the following Cisco IP Telephony devices: • CallManagerServer • CiscoGatekeeper • PSTNGatewayCisco3745 • PSTNGatewayCiscoAS5300 • PSTNGatewayCiscoOtherISDN • PSTNGatewayCiscoCat6k Captured in Discovery Formulas CCM_Server_Device Gatekeeper_Device PSTN_Gateway_Device Used in CME Formulas None. Used in Reports None.
Chapter 4: Element and Sub-Element Properties NOTES 150 Netcool/Proviso Cisco IP Telephony Technology Pack User’s Guide, Version 4.
Chapter 5: Defined Resources This chapter discusses the following topics: Topic Page Overview 151 Cisco IP Telephony Technology Pack Resources 151 Sub-Element Types 153 Overview A Netcool/Proviso resource is a network element or sub-element, such as a router or a hub. Typically, an IBM Technology Pack defines a set of Netcool/Proviso elements, sub-elements, and properties that map to specific devices and services operating in a network.
Chapter 5: Defined Resources Resource Description Sub-elements An element has one or more sub-elements for statistics that apply to the Cisco IP Telephony technology. The sub-element name identifies a sub-element that resides in the database. Subelement names are often used in reports to identify specific entities. With SNMP collection, the sub-element name is constructed from the element name plus the instance name. With bulk collection, the sub-element name is the same as the instance name.
Chapter 5: Defined Resources Sub-Element Types The Cisco IP Telephony Technology Pack creates the following kinds of sub-elements: • CallManager Gateway Device • CallManager Media Device • CallManager Server Device • CallManager Server File System • CallManager Server Interface • CallManager Server Process • CallManager Server SQL Database • Cluster • Codec • Extension • Gatekeeper Device • Gateway • Path • Perfmon • PSTN Gateway Device • PSTN Gateway DSP Card Tables of Sub-
Chapter 5: Defined Resources CallManager Gateway Device Collection Type SNMP Family VOIP_Cisco_CCM_Gateway_Device Sub-element name: ElementName_ Naming Structure Instance name: Gateway Label: Gateway: Properties Gateway VoIPCallMgrClusterId VoIPCallMgrGatewayIpAddress VoIPCallMgrGatewayName VoIPCallMgrGatewayType Comments This sub-element is a gateway device discovered through the ccmGatewayTable object in the CISCO-CCM-MIB.
Chapter 5: Defined Resources CallManager Server Device Collection Type SNMP Family 1213_Device Sub-element name: ElementName_ Naming Structure Instance name: If Label: -UNSPECIFIED Properties VoIPCallMgrClusterId VoIPCallMgrDeviceType VoIPCallMgrServerDescr VoIPCallMgrServerId VoIPCallMgrServerVersion Comments Each CallManager Server is part of one cluster.
Chapter 5: Defined Resources CallManager Server Process Collection Type SNMP Family VOIP_Cisco_CCM_Server_Process Sub-element name: ElementName_ Naming Structure Instance name: Process Label: Process Properties Process VoIPCallMgrClusterId VoIPCallMgrProcessName Comments None.
Chapter 5: Defined Resources Codec Collection Type Bulk Family VOIP_Cisco_CDR_Codec Sub-element name: ElementName_Codec_CodecType Naming Structure Instance name: ElementName_Codec_CodecType Label: ElementName_Codec_CodecType Properties CDRclusterId CDRcustomerId Comments None.
Chapter 5: Defined Resources Extension (cont.) This sub-element is the extension number for a phone or a CTI application. An extension can be any internal phone number managed by the CallManager’s DialPlan, according to its configuration. Supported extensions include: Comments • Cisco IP Phone (79xx series) registered to the CallManager cluster. • Analog Phone connected to a voice gateway (for example, ATA186 or Cisco VG200 Series,) and registered to the CallManager cluster.
Chapter 5: Defined Resources Gateway Collection Type Bulk Family VOIP_Cisco_CDR_Gateway Sub-element name: Gateway_ElementName_ Naming Structure Properties Instance name: Gateway_ElementName_ Label: Gateway_ElementName_ cdrType CDRclusterId CDRcustomerId CDRsiteId IP telephony sub-elements can be grouped according to family name and properties: Comments • Per customer: A customer can have one or several clusters deployed in a network.
Chapter 5: Defined Resources Perfmon Collection Type Bulk Family VOIP_Cisco_CCM_Server_PERFMON Sub-element name: CallManager_ Naming Structure Instance name: Label: CallManager_ Properties CDRclusterId CDRsiteId Comments None. PSTN Gateway Device Collection Type SNMP Family 1213_Device Sub-element name: ElementName_ Naming Structure Instance name: Label: -UNSPECIFIED Or...
Chapter 5: Defined Resources PSTN Gateway DSP Card Collection Type SNMP VOIP_Cisco_PSTN_Gateway_DSP_Card (for cards discovered through CISCO_DSP-MGMTMIB) Family Or... IETF_IF (for Catalyst 6500 DSP resources) Sub-element name: ElementName_ Naming Structure Instance name: DSPCard Label: DSPCard: Properties DSPCard VoIPCallMgrClusterId VoIPCallMgrCustomerId VoIPCallMgrDSPMaxChannel Comments None.
Chapter 5: Defined Resources NOTES 162 Netcool/Proviso Cisco IP Telephony Technology Pack User’s Guide, Version 4.
Chapter 6: Sub-Element Grouping Rules This chapter discusses the following topics: Topic Page Overview 163 NOC Grouping 164 Sub-Element Collect Grouping 171 Overview Typically, a Netcool/Proviso Technology Pack defines sub-element grouping rules. Grouping rules organize and filter networking data into a structure that makes it easier to collect data on thousands or millions of resources. Sub-element grouping rules organize data in tree structures.
Chapter 6: Sub-Element Grouping Rules NOC Grouping The NOC reporting tree provides the framework that allows users to navigate to reports. The NOC reporting tree for this technology pack contains the following high-level branches. The tree is shown as it appears in the DataMart Rule Editor: These high-level branches are used to organize the sub-branches of the tree. The following sections describe how sub-elements are grouped within these high-level branches.
Chapter 6: Sub-Element Grouping Rules The sub-branches are described as follows: Global Customer View Branch (No Rules or Conditions) Sub-branch Name Description CCM Servers Type: Static. Purpose: Filters by condition: %(FAMILY) LIKE 'VOIP_Cisco_CCM%' OR %(VoIPDeviceType) = 'CallManagerServer' Clusters Type: Static. Purpose: Filters by condition: %(FAMILY) = 'VOIP_Cisco_CDR_Cluster' DSP Type: Static.
Chapter 6: Sub-Element Grouping Rules IP Telephony Call Detail Record Branch The IP Telephony Call Detail Record branch of the Cisco IP Telephony NOC reporting tree contains the subbranches shown below: This branch has the following condition: %(FAMILY) LIKE 'VOIP_Cisco_CDR_%' 166 Netcool/Proviso Cisco IP Telephony Technology Pack User’s Guide, Version 4.
Chapter 6: Sub-Element Grouping Rules Sub-elements that match this condition are tested against the rules and conditions in the sub-branches. The subbranches are described as follows: IP Telephony Call Detail Record Branch — %(FAMILY) LIKE 'VOIP_Cisco_CDR_%' Sub-branch Name Description Clusters Type: Static. Purpose: Filters by condition: %(FAMILY) = 'VOIP_Cisco_CDR_Cluster' Clusters --%(CDRclusterId) Type: Rule. Purpose: Groups the collected cluster sub-elements by cluster ID. Codec Type: Static.
Chapter 6: Sub-Element Grouping Rules IP Telephony Call Detail Record Branch — %(FAMILY) LIKE 'VOIP_Cisco_CDR_%' (cont.) 168 Sub-branch Name Description Media Gateways Type: Static. Purpose: Filters by condition: %(FAMILY) = 'VOIP_Cisco_CDR_Gateway' Media Gateways --By Cluster Type: Static. Purpose: Filters by condition: %(FAMILY) = 'VOIP_Cisco_CDR_Gateway' Media Gateways --By Cluster ----%(CDRclusterId) Type: Rule. Purpose: Groups the collected media gateway sub-elements by cluster ID.
Chapter 6: Sub-Element Grouping Rules Infrastructure Branch The Infrastructure branch of the Cisco IP Telephony NOC reporting tree contains the sub-branches shown below: This branch has no rules or conditions. All sub-elements are tested against the rules and conditions in its subbranches. The sub-branches are described as follows: Infrastructure Branch (No Rules or Conditions) Sub-branch Name Description CCM Server Type: Static.
Chapter 6: Sub-Element Grouping Rules Infrastructure Branch (No Rules or Conditions) (cont.) 170 Sub-branch Name Description Perfmon --By Site ----%(CDRsiteID) Type: Rule. Purpose: Groups the collected Perfmon sub-elements by CCM site ID. Gatekeeper Type: Static. Purpose: Filters by condition: %(VoIPDeviceType) = 'CiscoGatekeeper' Gatekeeper --Device Type: Static. Purpose: Filters by condition: %(VoIPDeviceType) = 'CiscoGatekeeper' Gatekeeper --Interface Type: Static.
Chapter 6: Sub-Element Grouping Rules Infrastructure Branch (No Rules or Conditions) (cont.) Sub-branch Name Description Interface Type: Static. Purpose: Filters by condition: (%(AP_ifType) = 'ds1' AND %(VoIPCallMgrSerialOrDsp) NOT LIKE 'voice%') Interface --All Type: Static. Purpose: Filters by condition: %(AP_ifType) = 'ds1' AND %(VoIPCallMgrSerialOrDsp) NOT LIKE 'voice%' Interface --By Gateway Type: Static.
Chapter 6: Sub-Element Grouping Rules The branches are described as follows: 172 Sub-branch Name Description CCM Media Device Type: Static. Purpose: Filters by condition: %(FAMILY) = 'VOIP_Cisco_CCM_Media_Device' CCM Server Device Type: Static. Purpose: Filters by condition: %(VoIPDeviceType) = 'CallManagerServer' CDR Extension Path Gateway Type: Static.
Chapter 6: Sub-Element Grouping Rules NOTES Netcool/Proviso Cisco IP Telephony Technology Pack User’s Guide, Version 4.
Chapter 6: Sub-Element Grouping Rules 174 Netcool/Proviso Cisco IP Telephony Technology Pack User’s Guide, Version 4.
Chapter 7: Collection Formulas This chapter discusses the following topics: Topic Page Overview 175 Data Collection 176 Formulas and Metrics 176 Formula Reference 177 Overview This technology pack provides the following types of collection formulas: • SNMP collection formulas specific to the associated network devices and technologies on which it operates. These SNMP collection formulas are installed with the Cisco IP Telephony Technology Pack. • Bulk collection formulas.
Chapter 7: Collection Formulas Data Collection This technology pack uses both SNMP collection and bulk collection to gather data about Cisco IP Telephony devices and services: • With SNMP collection, data is gathered from objects in standard and vendor-specific MIBs. • With bulk collection, the Netcool/Proviso Bulk Collector gathers input files that contain non-SNMP data generated by Cisco IP Telephony devices. This data is processed by the technology pack’s Bulk Adaptor Design File, CCMAdaptor.js.
Chapter 7: Collection Formulas Formula Reference The following pages provide a reference of the formulas that this technology pack provides. The reference pages have the following sections: • Type. The source of data for the formula being described — for example, SNMP (collect). • Description. The description of the formula. • Syntax. The formula that generates the metric from the collected SNMP data.
Chapter 7: Collection Formulas AttendantConsoleClientsOnline Type Import Description Total number of attendant console clients currently online. Syntax #Bulk Metric Generic Database Alias None. Formula Editor Path AP > Specific > Bulk > VOIP > Cisco > Perfmon 178 Netcool/Proviso Cisco IP Telephony Technology Pack User’s Guide, Version 4.
Chapter 7: Collection Formulas AttendantConsoleClientsRegistered Type Import Description Total number of attendant console clients registered to the device. Syntax #Bulk Metric Generic Database Alias None. Formula Editor Path AP > Specific > Bulk > VOIP > Cisco > Perfmon Netcool/Proviso Cisco IP Telephony Technology Pack User’s Guide, Version 4.
Chapter 7: Collection Formulas AuthenticatedCallsActive Type Import Description Total number of active authenticated calls. Syntax #Bulk Metric Generic Database Alias None. Formula Editor Path AP > Specific > Bulk > VOIP > Cisco > Perfmon 180 Netcool/Proviso Cisco IP Telephony Technology Pack User’s Guide, Version 4.
Chapter 7: Collection Formulas AuthenticatedPartiallyRegisteredPhone Type Import Description Total number of active authenticated extensions that have not completed the registration process. Syntax #Bulk Metric Generic Database Alias None. Formula Editor Path AP > Specific > Bulk > VOIP > Cisco > Perfmon Netcool/Proviso Cisco IP Telephony Technology Pack User’s Guide, Version 4.
Chapter 7: Collection Formulas AuthenticatedRegisteredPhones Type Import Description Total number of active authenticated and fully registered extensions. Syntax #Bulk Metric Generic Database Alias None. Formula Editor Path AP > Specific > Bulk > VOIP > Cisco > Perfmon 182 Netcool/Proviso Cisco IP Telephony Technology Pack User’s Guide, Version 4.
Chapter 7: Collection Formulas Availability (percent) Type SNMP (collection) Description The percentage of time that this resource was in an operational state. Syntax DEF UseLib RFC1213Interface; DEF SaveAlias 2955; ifAvailability(Percent) Generic Database Alias Interface Availability (percent) Formula Editor Path AP > Specific > SNMP > Interfaces > Availability MIB rfc1213-MIB-II Netcool/Proviso Cisco IP Telephony Technology Pack User’s Guide, Version 4.
Chapter 7: Collection Formulas BRIChannelsActive Type Import Description Total number of BRI channels currently in use in the target device. Syntax #Bulk Metric Generic Database Alias None. Formula Editor Path AP > Specific > Bulk > VOIP > Cisco > Perfmon 184 Netcool/Proviso Cisco IP Telephony Technology Pack User’s Guide, Version 4.
Chapter 7: Collection Formulas BRISpansInService Type Import Description Total number of BRI spans available in the target device. Syntax #Bulk Metric Generic Database Alias None. Formula Editor Path AP > Specific > Bulk > VOIP > Cisco > Perfmon Netcool/Proviso Cisco IP Telephony Technology Pack User’s Guide, Version 4.
Chapter 7: Collection Formulas CallDuration Type Import Description The duration of the call, in seconds. Syntax #Bulk Metric Generic Database Alias None. Formula Editor Path AP > Specific > Bulk > VOIP > Cisco > CDR 186 Netcool/Proviso Cisco IP Telephony Technology Pack User’s Guide, Version 4.
Chapter 7: Collection Formulas CallsActive Type Import Description Total number of currently active calls for the resource or resources specified. Syntax #Bulk Metric Generic Database Alias None. Formula Editor Path AP > Specific > Bulk > VOIP > Cisco > Perfmon Netcool/Proviso Cisco IP Telephony Technology Pack User’s Guide, Version 4.
Chapter 7: Collection Formulas CallsInProgress Type Import Description Total number of calls being established at the time of sampling. Syntax #Bulk Metric Generic Database Alias None. Formula Editor Path AP > Specific > Bulk > VOIP > Cisco > Perfmon 188 Netcool/Proviso Cisco IP Telephony Technology Pack User’s Guide, Version 4.
Chapter 7: Collection Formulas CauseCallRejected Type Import Description Call rejected. Cause code 21. Syntax #Bulk Metric Generic Database Alias None. Formula Editor Path AP > Specific > Bulk > VOIP > Cisco > CDR Netcool/Proviso Cisco IP Telephony Technology Pack User’s Guide, Version 4.
Chapter 7: Collection Formulas CauseChannelUnacceptable Type Import Description Channel unacceptable. Cause code 6. Syntax #Bulk Metric Generic Database Alias None. Formula Editor Path AP > Specific > Bulk > VOIP > Cisco > CDR 190 Netcool/Proviso Cisco IP Telephony Technology Pack User’s Guide, Version 4.
Chapter 7: Collection Formulas CauseDestinationOutOfOrder Type Import Description Destination out of order. Cause code 27. Syntax #Bulk Metric Generic Database Alias None. Formula Editor Path AP > Specific > Bulk > VOIP > Cisco > CDR Netcool/Proviso Cisco IP Telephony Technology Pack User’s Guide, Version 4.
Chapter 7: Collection Formulas CauseInvalidNumberFormat Type Import Description Address incomplete, invalid number format. Cause code 28. Syntax #Bulk Metric Generic Database Alias None. Formula Editor Path AP > Specific > Bulk > VOIP > Cisco > CDR 192 Netcool/Proviso Cisco IP Telephony Technology Pack User’s Guide, Version 4.
Chapter 7: Collection Formulas CauseMisdialedTrunkPrefix Type Import Description Misdialed trunk prefix. Cause code 5. Syntax #Bulk Metric Generic Database Alias None. Formula Editor Path AP > Specific > Bulk > VOIP > Cisco > CDR Netcool/Proviso Cisco IP Telephony Technology Pack User’s Guide, Version 4.
Chapter 7: Collection Formulas CauseNetworkOutOfOrder Type Import Description Network out of order. Cause code 38. Syntax #Bulk Metric Generic Database Alias None. Formula Editor Path AP > Specific > Bulk > VOIP > Cisco > CDR 194 Netcool/Proviso Cisco IP Telephony Technology Pack User’s Guide, Version 4.
Chapter 7: Collection Formulas CauseNoAnswerFromUser Type Import Description No answer from user. Cause code 19. Syntax #Bulk Metric Generic Database Alias None. Formula Editor Path AP > Specific > Bulk > VOIP > Cisco > CDR Netcool/Proviso Cisco IP Telephony Technology Pack User’s Guide, Version 4.
Chapter 7: Collection Formulas CauseNoChannelAvailable Type Import Description No channel/circuit available. Cause code 34. Syntax #Bulk Metric Generic Database Alias None. Formula Editor Path AP > Specific > Bulk > VOIP > Cisco > CDR 196 Netcool/Proviso Cisco IP Telephony Technology Pack User’s Guide, Version 4.
Chapter 7: Collection Formulas CauseNoRouteToDestination Type Import Description No route to destination. Cause code 3. Syntax #Bulk Metric Generic Database Alias None. Formula Editor Path AP > Specific > Bulk > VOIP > Cisco > CDR Netcool/Proviso Cisco IP Telephony Technology Pack User’s Guide, Version 4.
Chapter 7: Collection Formulas CauseNoRouteTransitNetwork Type Import Description No route to specified transit network. Cause code 2. Syntax #Bulk Metric Generic Database Alias None. Formula Editor Path AP > Specific > Bulk > VOIP > Cisco > CDR 198 Netcool/Proviso Cisco IP Telephony Technology Pack User’s Guide, Version 4.
Chapter 7: Collection Formulas CauseNoUserResponding Type Import Description No user responding to the call. Cause code 18. Syntax #Bulk Metric Generic Database Alias None. Formula Editor Path AP > Specific > Bulk > VOIP > Cisco > CDR Netcool/Proviso Cisco IP Telephony Technology Pack User’s Guide, Version 4.
Chapter 7: Collection Formulas CauseNumberChanged Type Import Description CNumber changed. Cause code 22. Syntax #Bulk Metric Generic Database Alias None. Formula Editor Path AP > Specific > Bulk > VOIP > Cisco > CDR 200 Netcool/Proviso Cisco IP Telephony Technology Pack User’s Guide, Version 4.
Chapter 7: Collection Formulas CauseOther Type Import Description Unspecified error. Syntax #Bulk Metric Generic Database Alias None. Formula Editor Path AP > Specific > Bulk > VOIP > Cisco > CDR Netcool/Proviso Cisco IP Telephony Technology Pack User’s Guide, Version 4.
Chapter 7: Collection Formulas CauseResourceUnavailable Type Import Description Resource unavailable or unspecified. Cause code 47. Syntax #Bulk Metric Generic Database Alias None. Formula Editor Path AP > Specific > Bulk > VOIP > Cisco > CDR 202 Netcool/Proviso Cisco IP Telephony Technology Pack User’s Guide, Version 4.
Chapter 7: Collection Formulas CauseSubscriberAbsent Type Import Description Subscriber absent. Cause code 20. Syntax #Bulk Metric Generic Database Alias None. Formula Editor Path AP > Specific > Bulk > VOIP > Cisco > CDR Netcool/Proviso Cisco IP Telephony Technology Pack User’s Guide, Version 4.
Chapter 7: Collection Formulas CauseSwitchCongestion Type Import Description Switching equipment congestion. Cause code 42. Syntax #Bulk Metric Generic Database Alias None. Formula Editor Path AP > Specific > Bulk > VOIP > Cisco > CDR 204 Netcool/Proviso Cisco IP Telephony Technology Pack User’s Guide, Version 4.
Chapter 7: Collection Formulas CauseTemporaryFailure Type Import Description Temporary failure. Cause code 41. Syntax #Bulk Metric Generic Database Alias None. Formula Editor Path AP > Specific > Bulk > VOIP > Cisco > CDR Netcool/Proviso Cisco IP Telephony Technology Pack User’s Guide, Version 4.
Chapter 7: Collection Formulas CauseUnassignedNumber Type Import Description Unassigned or unallocated number. Cause code 1. Syntax #Bulk Metric Generic Database Alias None. Formula Editor Path AP > Specific > Bulk > VOIP > Cisco > CDR 206 Netcool/Proviso Cisco IP Telephony Technology Pack User’s Guide, Version 4.
Chapter 7: Collection Formulas CauseUserBusy Type Import Description User busy. Cause code 17. Syntax #Bulk Metric Generic Database Alias None. Formula Editor Path AP > Specific > Bulk > VOIP > Cisco > CDR Netcool/Proviso Cisco IP Telephony Technology Pack User’s Guide, Version 4.
Chapter 7: Collection Formulas CCM CPU Utilization (percent) (avg last 5 mn) Type SNMP (collection) Description The average percentage of time, over the last five minutes, that this processor was not idle. Syntax hrProcessorLoad.1 Generic Database Alias None. Formula Editor Path AP > Specific > SNMP > VOIP > Cisco > CCM Server > Device MIB rfc1514-HOSTRESOURCES 208 Netcool/Proviso Cisco IP Telephony Technology Pack User’s Guide, Version 4.
Chapter 7: Collection Formulas CCM Media Device Registration Availability (percent) Type SNMP (collection) Description The availability (percentage) that the media devices can register with a CCM server. Syntax Def DefaultNoRespResult 0; Dim I1 AS Integer Default * NAME MediaDevice; 100 * abs( delta(sysUpTime.0) * (1 + distrib(ccmMediaDeviceStatus.%I1,"==1:1,==2:1,==3:-1,==4:-1") )/2 - delta(sysUpTime.0)/2 * abs( delta(distrib(ccmMediaDeviceStatus.
Chapter 7: Collection Formulas CCM Physical Memory Utilization (percent) Type SNMP (collection) Description The percentage of CallManager physical memory utilization. The percentage is determined by finding the total amount of real system memory allocated to each process, and then dividing the total by the amount of physical memory contained by the host. Syntax Dim I0 AS Integer Default * NAME Mem; V1=OIDVAL(hrSWRunPerfMem.%I0); V2=OIDVAL(Sum(*, %V1)); V3=OIDVAL(hrMemorySize.
Chapter 7: Collection Formulas CCM Registered CTI Devices (Nb) (Gauge) Type SNMP (collection) Description The total number of CTI devices registered to the CallManager. Syntax ccmRegisteredCTIDevices.0 Generic Database Alias None. Formula Editor Path AP > Specific > SNMP > VOIP > Cisco > CCM Server > Device MIB CISCO-CCM-MIB.my Netcool/Proviso Cisco IP Telephony Technology Pack User’s Guide, Version 4.
Chapter 7: Collection Formulas CCM Registered Devices (Nb) (Gauge) Type SNMP (collection) Description The total number of devices currently registered to the CallManager device. Syntax ccmRegisteredPhones.0 + ccmRegisteredGateways.0 + ccmRegisteredMediaDevices.0 + ccmRegisteredCTIDevices.0 + ccmRegisteredVoiceMailDevices.0 Generic Database Alias None. Formula Editor Path AP > Specific > SNMP > VOIP > Cisco > CCM Server > Device MIB CISCO-CCM-MIB.
Chapter 7: Collection Formulas CCM Registered Gateways (Nb) (Gauge) Type SNMP (collection) Description The total number of media gateways registered to a CallManager device. Syntax ccmRegisteredGateways.0 Generic Database Alias None. Formula Editor Path AP > Specific > SNMP > VOIP > Cisco > CCM Server > Device MIB CISCO-CCM-MIB.my Netcool/Proviso Cisco IP Telephony Technology Pack User’s Guide, Version 4.
Chapter 7: Collection Formulas CCM Registered Media Devices (Nb) (Gauge) Type SNMP (collection) Description The total number of media devices registered to a CallManager Server. Syntax ccmRegisteredMediaDevices.0 Generic Database Alias None. Formula Editor Path AP > Specific > SNMP > VOIP > Cisco > CCM Server > Device MIB CISCO-CCM-MIB.my 214 Netcool/Proviso Cisco IP Telephony Technology Pack User’s Guide, Version 4.
Chapter 7: Collection Formulas CCM Registered Phones (Nb) (Gauge) Type SNMP (collection) Description The total number of IP phones registered to a CallManager device. Syntax ccmRegisteredPhones.0 Generic Database Alias None. Formula Editor Path AP > Specific > SNMP > VOIP > Cisco > CCM Server > Device MIB CISCO-CCM-MIB.my Netcool/Proviso Cisco IP Telephony Technology Pack User’s Guide, Version 4.
Chapter 7: Collection Formulas CCM Registered VoiceMail Devices (Nb) (Gauge) Type SNMP (collection) Description The total number of registered voicemail devices. Syntax ccmRegisteredVoiceMailDevices.0 Generic Database Alias None. Formula Editor Path AP > Specific > SNMP > VOIP > Cisco > CCM Server > Device MIB CISCO-CCM-MIB.my 216 Netcool/Proviso Cisco IP Telephony Technology Pack User’s Guide, Version 4.
Chapter 7: Collection Formulas CCM Rejected Devices (Nb) (Gauge) Type SNMP (collection) Description The total number of rejected devices. Syntax ccmRejectedPhones.0 + ccmRejectedGateways.0 + ccmRejectedMediaDevices.0 + ccmRejectedCTIDevices.0 + ccmRejectedVoiceMailDevices.0 Generic Database Alias None. Formula Editor Path AP > Specific > SNMP > VOIP > Cisco > CCM Server > Device MIB CISCO-CCM-MIB.my Netcool/Proviso Cisco IP Telephony Technology Pack User’s Guide, Version 4.
Chapter 7: Collection Formulas 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.
Chapter 7: Collection Formulas 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.
Chapter 7: Collection Formulas CCM SQL Server free buffers (Nb) Type SNMP (collection) Description The total number of data cache buffers currently in the free pool. Syntax Dim I0 AS Integer Default * NAME Sql; V1=OIDVAL(mssqlSrvInfoFreeBuffers.%I0); Sum(*, %V1) Generic Database Alias None. Formula Editor Path AP > Specific > SNMP > VOIP > Cisco > CCM Server > Sql Server MIB MSSQL-MIB.my 220 Netcool/Proviso Cisco IP Telephony Technology Pack User’s Guide, Version 4.
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.
Chapter 7: Collection Formulas CCM SQL Server number of blocked users Type SNMP (collection) Description The total Number of users blocked by other users. Syntax Dim I0 AS Integer Default * NAME Sql; V1=OIDVAL(mssqlSrvInfoUsersBlocked.%I0); Sum(*, %V1) Generic Database Alias None. Formula Editor Path AP > Specific > SNMP > VOIP > Cisco > CCM Server > Sql Server MIB MSSQL-MIB.my 222 Netcool/Proviso Cisco IP Telephony Technology Pack User’s Guide, Version 4.
Chapter 7: Collection Formulas CCM SQL Server number of locks blocking processes Type SNMP (collection) Description The total number of locks blocking other processes. Syntax Dim I0 AS Integer Default * NAME Sql; V1=OIDVAL(mssqlSrvInfoTotalBlockingLocks.%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.
Chapter 7: Collection Formulas CCM SQL Server number of locks Type SNMP (collection) Description The total number of locks in use by SQL Server. Syntax Dim I0 AS Integer Default * NAME Sql; V1=OIDVAL(mssqlSrvInfoTotalLocks.%I0); Sum(*, %V1) Generic Database Alias None. Formula Editor Path AP > Specific > SNMP > VOIP > Cisco > CCM Server > Sql Server MIB MSSQL-MIB.my 224 Netcool/Proviso Cisco IP Telephony Technology Pack User’s Guide, Version 4.
Chapter 7: Collection Formulas CCM SQL Server number of pending rw Type SNMP (collection) Description The total number of pending reads and writes. Syntax Dim I0 AS Integer Default * NAME Sql; V1=OIDVAL(mssqlSrvInfoOutstandingReads.%I0 + mssqlSrvInfoOutstandingWrites.%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.
Chapter 7: Collection Formulas CCM SQL Server Total number of Pages Type SNMP (collection) Description The total number of pages read and written. Syntax Dim I0 AS Integer Default * NAME Sql; V1=OIDVAL(delta(mssqlSrvInfoPageReads.%I0) + delta(mssqlSrvInfoSinglePageWrites.%I0)); Sum(*, %V1) Generic Database Alias None. Formula Editor Path AP > Specific > SNMP > VOIP > Cisco > CCM Server > Sql Server MIB MSSQL-MIB.my 226 Netcool/Proviso Cisco IP Telephony Technology Pack User’s Guide, Version 4.
Chapter 7: Collection Formulas CCR Type Import Description Cumulative concealment ratio during a call represented as concealment time / speech time. Syntax #Bulk Metric Generic Database Alias None. Formula Editor Path AP > Specific > Bulk > VOIP > Cisco > CMR Netcool/Proviso Cisco IP Telephony Technology Pack User’s Guide, Version 4.
Chapter 7: Collection Formulas Cluster Erlang Type CME Description Cluster Erlang measured in minutes: ClusterCallDuration / 60. Syntax ^(duration/60) Formula Input Input: duration Source: ClusterCallDuration (Formula) Generic Database Alias None. Formula Editor Path AP > Specific > CME > VOIP > Cisco 228 Netcool/Proviso Cisco IP Telephony Technology Pack User’s Guide, Version 4.
Chapter 7: Collection Formulas Cluster Number of Direct VoiceMail Calls (Nb) Type CME Description The total number of voicemail calls that are direct calls to voicemail (that is, users calling voicemail directly rather than being forwarded). This metric is the opposite of ClusterForwardToVoiceMail.
Chapter 7: Collection Formulas Cluster Percentage of Company Calls (percent) Type CME Description The ratio between company calls and the total number of calls. For information on company calls, see Cluster Total Number of Company Calls (Nb).
Chapter 7: Collection Formulas Cluster Percentage of Drop Calls (percent) Type CME Description The ratio between dropped calls and the total number of calls. Syntax (100*(ClusterDropCalls/ClusterTotalCalls)) > 100 ifTrue: [^nil]. ^(100*(ClusterDropCalls/ClusterTotalCalls)) Formula Input Input: ClusterDropCalls Source: ClusterDropCall (Formula) Input: ClusterTotalCalls Source: ClusterTotalCall (Formula) Generic Database Alias None.
Chapter 7: Collection Formulas Cluster Percentage of Normal Call Clearing (percent) Type CME Description The ratio between calls that have a normal termination code and the total number of calls. This metric is the opposite of the Percentage of Drop Calls. Syntax ^(100*((ClusterTotalCalls - ClusterDropCalls)/ClusterTotalCalls)) Formula Input Input: ClusterDropCalls Source: ClusterDropCall (Formula) Input: ClusterTotalCalls Source: ClusterTotalCall (Formula) Generic Database Alias None.
Chapter 7: Collection Formulas Cluster Percentage of Packet Lost (percent) Type CME Description The ratio between packets lost and the total number of packets sent and received.
Chapter 7: Collection Formulas Cluster Percentage of Successful Calls (percent) Type CME Description The ratio between successful calls and the total number of calls. Syntax ^(100*(ClusterSuccessfulCall/(ClusterSuccessfulCall + ClusterUnsuccessfulCall))) Formula Input Input: ClusterSuccessfulCall Source: ClusterSuccessfulCall (Formula) Input: ClusterUnsuccessfulCall Source: ClusterUnsuccessfulCall (Formula) Generic Database Alias None.
Chapter 7: Collection Formulas Cluster Percentage of TollBypass Calls (percent) Type CME Description The ratio between toll bypass calls and the total number of calls. Syntax ^(100*(ClusterTollBypassCall/(ClusterTotalCall))) Formula Input Input: ClusterTollBypassCall Source: ClusterTollBypassCall (Formula) Input: ClusterTotalCall Source: ClusterTotalCall (Formula) Generic Database Alias None.
Chapter 7: Collection Formulas Cluster Total Hours of Traffic Type CME Description The total call duration in hours. This formula will be useful for future Erlang calculation. Syntax ^(duration/3600) Formula Input Input: duration Source: ClusterCallDuration (Formula) Generic Database Alias None. Formula Editor Path AP > Specific > CME > VOIP > Cisco 236 Netcool/Proviso Cisco IP Telephony Technology Pack User’s Guide, Version 4.
Chapter 7: Collection Formulas Cluster Total Number of Company Calls (Nb) Type CME Description The total number of company calls. This is the opposite of an external call (see Cluster Total Number of External Calls (Nb)).
Chapter 7: Collection Formulas Cluster Total Number of Company IP Calls (Nb) Type CME Description The total number of intrasite and intersite IP calls. Syntax ^(ClusterIntrasiteIPCalls+ClusterIntersiteIPCalls) Formula Input Input: ClusterIntersiteIPCalls Source: ClusterIntersiteIPCall (Formula) Input: ClusterIntrasiteIPCalls Source: ClusterIntrasiteIPCall (Formula) Generic Database Alias None.
Chapter 7: Collection Formulas Cluster Total Number of Company LegacyPBX Calls (Nb) Type CME Description The total number of company legacy PBX Calls. A legacy PBX call is an intrasite or intersite legacy PBX call. Syntax ^(ClusterIntrasiteLegacyPBXCalls+ClusterIntersiteLegacyPBXCalls) Formula Input Input: ClusterIntersiteLegacyPBXCalls Source: ClusterIntersiteLegacyPBXCall (Formula) Input: ClusterIntrasiteLegacyPBXCalls Source: ClusterIntrasiteLegacyPBXCall (Formula) Generic Database Alias None.
Chapter 7: Collection Formulas Cluster Total Number of External Calls (Nb) Type CME Description Any call to or from the PSTN. This is the opposite of a company call (see Cluster Total Number of Company Calls (Nb)).
Chapter 7: Collection Formulas Cluster Total Number of Normal Call Clearing Type CME Description The total of calls with a normal termination code. Syntax ^(ClusterTotalCalls - ClusterDropCalls) Formula Input Input: ClusterDropCalls Source: ClusterDropCall (Formula) Input: ClusterTotalCalls Source: ClusterTotalCall (Formula) Generic Database Alias None. Formula Editor Path AP > Specific > CME > VOIP > Cisco Netcool/Proviso Cisco IP Telephony Technology Pack User’s Guide, Version 4.
Chapter 7: Collection Formulas Cluster Total Number of Outgoing External Calls (Nb) Type CME Description The total of outbound calls going to the PSTN. This metric is a subset of Cluster Total Number of External Calls (Nb).
Chapter 7: Collection Formulas ClusterBlocking Type Import Description Total number of times that call blocking occurred. This can be due to lack of channel availability or switch congestion. Error codes 34 and 42 are used in the calculation. Syntax #Bulk Metric Generic Database Alias None. Formula Editor Path AP > Specific > Bulk > VOIP > Cisco > CLUSTER Netcool/Proviso Cisco IP Telephony Technology Pack User’s Guide, Version 4.
Chapter 7: Collection Formulas ClusterCallDuration Type Import Description The duration of the call, in seconds. Syntax #Bulk Metric Generic Database Alias None. Formula Editor Path AP > Specific > Bulk > VOIP > Cisco > CLUSTER 244 Netcool/Proviso Cisco IP Telephony Technology Pack User’s Guide, Version 4.
Chapter 7: Collection Formulas ClusterCauseCallRejected Type Import Description Call rejected. Cause code 21. Syntax #Bulk Metric Generic Database Alias None. Formula Editor Path AP > Specific > Bulk > VOIP > Cisco > CLUSTER Netcool/Proviso Cisco IP Telephony Technology Pack User’s Guide, Version 4.
Chapter 7: Collection Formulas ClusterCauseChannelUnacceptable Type Import Description Channel unacceptable. Cause code 6. Syntax #Bulk Metric Generic Database Alias None. Formula Editor Path AP > Specific > Bulk > VOIP > Cisco > CLUSTER 246 Netcool/Proviso Cisco IP Telephony Technology Pack User’s Guide, Version 4.
Chapter 7: Collection Formulas ClusterCauseDestinationOutOfOrder Type Import Description Destination out of order. Cause code 27. Syntax #Bulk Metric Generic Database Alias None. Formula Editor Path AP > Specific > Bulk > VOIP > Cisco > CLUSTER Netcool/Proviso Cisco IP Telephony Technology Pack User’s Guide, Version 4.
Chapter 7: Collection Formulas ClusterCauseInvalidNumberFormat Type Import Description Address incomplete, invalid number format. Cause code 28. Syntax #Bulk Metric Generic Database Alias None. Formula Editor Path AP > Specific > Bulk > VOIP > Cisco > CLUSTER 248 Netcool/Proviso Cisco IP Telephony Technology Pack User’s Guide, Version 4.
Chapter 7: Collection Formulas ClusterCauseMisdialedTrunkPrefix Type Import Description Misdialed trunk prefix. Cause code 5. Syntax #Bulk Metric Generic Database Alias None. Formula Editor Path AP > Specific > Bulk > VOIP > Cisco > CLUSTER Netcool/Proviso Cisco IP Telephony Technology Pack User’s Guide, Version 4.
Chapter 7: Collection Formulas ClusterCauseNetworkOutOfOrder Type Import Description Network out of order. Cause code 38. Syntax #Bulk Metric Generic Database Alias None. Formula Editor Path AP > Specific > Bulk > VOIP > Cisco > CLUSTER 250 Netcool/Proviso Cisco IP Telephony Technology Pack User’s Guide, Version 4.
Chapter 7: Collection Formulas ClusterCauseNoAnswerFromUser Type Import Description No answer from user. Cause code 19. Syntax #Bulk Metric Generic Database Alias None. Formula Editor Path AP > Specific > Bulk > VOIP > Cisco > CLUSTER Netcool/Proviso Cisco IP Telephony Technology Pack User’s Guide, Version 4.
Chapter 7: Collection Formulas ClusterCauseNoChannelAvailable Type Import Description No channel/circuit available. Cause code 34. Syntax #Bulk Metric Generic Database Alias None. Formula Editor Path AP > Specific > Bulk > VOIP > Cisco > CLUSTER 252 Netcool/Proviso Cisco IP Telephony Technology Pack User’s Guide, Version 4.
Chapter 7: Collection Formulas ClusterCauseNoRouteToDestination Type Import Description No route to destination. Cause code 3. Syntax #Bulk Metric Generic Database Alias None. Formula Editor Path AP > Specific > Bulk > VOIP > Cisco > CLUSTER Netcool/Proviso Cisco IP Telephony Technology Pack User’s Guide, Version 4.
Chapter 7: Collection Formulas ClusterCauseNoRouteTransitNetwork Type Import Description No route to specified transit network. Cause code 2. Syntax #Bulk Metric Generic Database Alias None. Formula Editor Path AP > Specific > Bulk > VOIP > Cisco > CLUSTER 254 Netcool/Proviso Cisco IP Telephony Technology Pack User’s Guide, Version 4.
Chapter 7: Collection Formulas ClusterCauseNoUserResponding Type Import Description No user responding to the call. Cause code 18. Syntax #Bulk Metric Generic Database Alias None. Formula Editor Path AP > Specific > Bulk > VOIP > Cisco > CLUSTER Netcool/Proviso Cisco IP Telephony Technology Pack User’s Guide, Version 4.
Chapter 7: Collection Formulas ClusterCauseNumberChanged Type Import Description Number changed. Cause code 22. Syntax #Bulk Metric Generic Database Alias None. Formula Editor Path AP > Specific > Bulk > VOIP > Cisco > CLUSTER 256 Netcool/Proviso Cisco IP Telephony Technology Pack User’s Guide, Version 4.
Chapter 7: Collection Formulas ClusterCauseOther Type Import Description Unspecified error. Syntax #Bulk Metric Generic Database Alias None. Formula Editor Path AP > Specific > Bulk > VOIP > Cisco > CLUSTER Netcool/Proviso Cisco IP Telephony Technology Pack User’s Guide, Version 4.
Chapter 7: Collection Formulas ClusterCauseResourceUnavailable Type Import Description Resource unavailable or unspecified. Cause code 47. Syntax #Bulk Metric Generic Database Alias None. Formula Editor Path AP > Specific > Bulk > VOIP > Cisco > CLUSTER 258 Netcool/Proviso Cisco IP Telephony Technology Pack User’s Guide, Version 4.
Chapter 7: Collection Formulas ClusterCauseSubscriberAbsent Type Import Description Subscriber absent. Cause code 20. Syntax #Bulk Metric Generic Database Alias None. Formula Editor Path AP > Specific > Bulk > VOIP > Cisco > CLUSTER Netcool/Proviso Cisco IP Telephony Technology Pack User’s Guide, Version 4.
Chapter 7: Collection Formulas ClusterCauseSwitchCongestion Type Import Description witching equipment congestion. Cause code 42. Syntax #Bulk Metric Generic Database Alias None. Formula Editor Path AP > Specific > Bulk > VOIP > Cisco > CLUSTER 260 Netcool/Proviso Cisco IP Telephony Technology Pack User’s Guide, Version 4.
Chapter 7: Collection Formulas ClusterCauseTemporaryFailure Type Import Description Temporary failure. Cause code 41. Syntax #Bulk Metric Generic Database Alias None. Formula Editor Path AP > Specific > Bulk > VOIP > Cisco > CLUSTER Netcool/Proviso Cisco IP Telephony Technology Pack User’s Guide, Version 4.
Chapter 7: Collection Formulas ClusterCauseUnassignedNumber Type Import Description Unassigned or unallocated number. Cause code 1. Syntax #Bulk Metric Generic Database Alias None. Formula Editor Path AP > Specific > Bulk > VOIP > Cisco > CLUSTER 262 Netcool/Proviso Cisco IP Telephony Technology Pack User’s Guide, Version 4.
Chapter 7: Collection Formulas ClusterCauseUserBusy Type Import Description User busy. Cause code 17. Syntax #Bulk Metric Generic Database Alias None. Formula Editor Path AP > Specific > Bulk > VOIP > Cisco > CLUSTER Netcool/Proviso Cisco IP Telephony Technology Pack User’s Guide, Version 4.
Chapter 7: Collection Formulas ClusterDropCall Type Import Description Identifies a call successfully established, but that has been dropped accidentally during the communication between the two parties. Syntax #Bulk Metric Generic Database Alias None. Formula Editor Path AP > Specific > Bulk > VOIP > Cisco > CLUSTER 264 Netcool/Proviso Cisco IP Telephony Technology Pack User’s Guide, Version 4.
Chapter 7: Collection Formulas ClusterErlangB Type Import Description Probability that a new arriving call will be rejected because circuits are busy. Syntax #Bulk Metric Generic Database Alias None. Formula Editor Path AP > Specific > Bulk > VOIP > Cisco > CLUSTER Netcool/Proviso Cisco IP Telephony Technology Pack User’s Guide, Version 4.
Chapter 7: Collection Formulas ClusterErlang Type Import Description Distribution of voice traffic tha traverses the PSTN, divided by time. Syntax #Bulk Metric Generic Database Alias None. Formula Editor Path AP > Specific > Bulk > VOIP > Cisco > CLUSTER 266 Netcool/Proviso Cisco IP Telephony Technology Pack User’s Guide, Version 4.
Chapter 7: Collection Formulas ClusterForwardToVoiceMail Type Import Description Identifies a call forwarded to another destination by the original callee. In this case, the destination is the voicemail extension number, defined through an addVoiceMailRange() method in the CCMConfig.js file. This metric is the opposite of Cluster Number of Direct VoiceMail Calls (Nb). Syntax #Bulk Metric Generic Database Alias None.
Chapter 7: Collection Formulas ClusterIncomingCall Type Import Description Identifies a call where the caller is not an internal extension. An incoming call can also be an inbound call or an off-net call that comes from the PSTN. Syntax #Bulk Metric Generic Database Alias None. Formula Editor Path AP > Specific > Bulk > VOIP > Cisco > CLUSTER 268 Netcool/Proviso Cisco IP Telephony Technology Pack User’s Guide, Version 4.
Chapter 7: Collection Formulas ClusterInternalCall Type Import Description An internal call is a call between two internal extensions, managed by one or more CallManager clusters, where the caller and callee extensions are short, internal numbers.
Chapter 7: Collection Formulas ClusterInternationalCall Type Import Description Identifies a call where the caller is an internal extension and where the callee is an international external PSTN number, according to the numbering plan (NANP or other prefixes). An international call can be any of the following call types: • Outbound • Off-net, routed towards the PSTN • Toll bypass, if a remote PSTN Gateway is involved in the Voice path Syntax #Bulk Metric Generic Database Alias None.
Chapter 7: Collection Formulas ClusterIntersiteIPCall Type Import Description Identifies a specific internal call where the caller and callee are from different sites and are using a pure IP network transit path (that is, no PSTN Gateway is involved in the voice path). Syntax #Bulk Metric Generic Database Alias None. Formula Editor Path AP > Specific > Bulk > VOIP > Cisco > CLUSTER Netcool/Proviso Cisco IP Telephony Technology Pack User’s Guide, Version 4.
Chapter 7: Collection Formulas ClusterIntersiteLegacyPBXCall Type Import Description Identifies a specific internal call where the caller and callee are from different sites and where the voice path goes through a PSTN Gateway. This type of call occurs between between either: • One IP phone and one legacy phone from two different sites, according to their extension range number. The legacy phone is managed by a legacy PBX, which is interconnected to the CallManager through a PSTN Gateway.
Chapter 7: Collection Formulas ClusterIntrasiteIPCall Type Import Description Identifies a specific internal call where the caller and callee are both at the same site and are using a pure IP network transit path (that is, no PSTN Gateway is involved in the voice Path). Internal extensions are attached to a specific site through the CCMConfig.js file, where one or more addExtensionRange() methods are called for particular site objects. Syntax #Bulk Metric Generic Database Alias None.
Chapter 7: Collection Formulas ClusterIntrasiteLegacyPBXCall Type Import Description Identifies a specific internal Call where the caller and callee are both at the same site, but where the voice path goes through a PSTN Gateway. In this case, the call can be between one IP phone and one legacy phone from the same location, according to their extension range number. The legacy phone is managed by a legacy PBX, which is interconnected to the CallManager through a PSTN Gateway.
Chapter 7: Collection Formulas ClusterJitter Type Import Description Provides an estimate of the statistical variance of the RTP data packet interval, in milliseconds. This metric comes from the CMR table. It is set once the call is established. Also, this metric is available only for IP phones. Syntax #Bulk Metric Generic Database Alias None. Formula Editor Path AP > Specific > Bulk > VOIP > Cisco > CLUSTER Netcool/Proviso Cisco IP Telephony Technology Pack User’s Guide, Version 4.
Chapter 7: Collection Formulas ClusterLatency Type Import Description An estimate of network latency, expressed in milliseconds. This value represents the average of the difference between the NTP timestamp indicated by the RTP Control Protocol (RTCP) messages and the NTP timestamp of the receivers, measured when these messages are received. Cisco CallManager obtains the average by summing all the estimates, and then dividing by the number of RTCP messages that have been received.
Chapter 7: Collection Formulas ClusterLines Type Import Description Total number of type-18 interfaces lines. Syntax #Bulk Metric Generic Database Alias None. Formula Editor Path AP > Specific > Bulk > VOIP > Cisco > CLUSTER Netcool/Proviso Cisco IP Telephony Technology Pack User’s Guide, Version 4.
Chapter 7: Collection Formulas ClusterLocalCall Type Import Description Identifies a call where the caller is an internal extension and the callee is a local external PSTN number, according to the numbering plan (NANP or other prefixes). A local call can also be any of these call types: • Outbound • Off-net call, routed towards the PSTN • Toll bypass, if a remote PSTN Gateway is involved in the voice path The file CCMConfig.js contains methods that specify local call prefixes for a given site.
Chapter 7: Collection Formulas ClusterLongDistanceCall Type Import Description Identifies a call where the caller is an internal extension and the callee is a long distance external PSTN number, according to the numbering plan (NANP or Other prefixes). A long distance call can also be any of these call types: • Outbound • Off-net, routed towards the PSTN • Toll bypass, if a remote PSTN Gateway is involved in the voice path Syntax #Bulk Metric Generic Database Alias None.
Chapter 7: Collection Formulas ClusterMOS Type Import Description The mean opinion score (MOS). This is a high-level metric. In voice communications, particularly internet telephony, the MOS provides a numeric measure of the quality of human speech at the destination end of the circuit. There is no algorithm for MOS calculations. This is a subjective metric based on the end-user’s judgment of call quality.
Chapter 7: Collection Formulas ClusterNbPacketsLost Type Import Description Total number of packets that the sub-element loses during a call. This metric comes from the CMR table. It is set once the call is established. This metric is only available for IP phones. Syntax #Bulk Metric Generic Database Alias None. Formula Editor Path AP > Specific > Bulk > VOIP > Cisco > CLUSTER Netcool/Proviso Cisco IP Telephony Technology Pack User’s Guide, Version 4.
Chapter 7: Collection Formulas ClusterNbPacketsReceived Type Import Description Total number of packets that the sub-element receives during a call. This metric comes from the CMR table. It is set once the call is established. This metric is only available for IP phones. Syntax #Bulk Metric Generic Database Alias None. Formula Editor Path AP > Specific > Bulk > VOIP > Cisco > CLUSTER 282 Netcool/Proviso Cisco IP Telephony Technology Pack User’s Guide, Version 4.
Chapter 7: Collection Formulas ClusterNbPacketsSent Type Import Description Total number of packets that the sub-element sends during a call. This metric comes from the CMR table. It is set once the call is established. This metric is only available for IP phones. Syntax #Bulk Metric Generic Database Alias None. Formula Editor Path AP > Specific > Bulk > VOIP > Cisco > CLUSTER Netcool/Proviso Cisco IP Telephony Technology Pack User’s Guide, Version 4.
Chapter 7: Collection Formulas ClusterOffNetCall Type Import Description Identifies a call where at least one PSTN Gateway is involved in the voice path, with the following criteria: • Inbound or outbound call • Internal call, or a call to/from a PSTN number • Intersite or intrasite legacy PBX call Syntax #Bulk Metric Generic Database Alias None. Formula Editor Path AP > Specific > Bulk > VOIP > Cisco > CLUSTER 284 Netcool/Proviso Cisco IP Telephony Technology Pack User’s Guide, Version 4.
Chapter 7: Collection Formulas ClusterOnNetCall Type Import Description Identifies a call where both the caller and callee are internal extensions, from the same site or different sites, and with the following criteria: • Outbound call • Internal call • Intersite or intrasite IP call • No PSTN Gateway is involved in the voice path • A pure IP-to-IP call Syntax #Bulk Metric Generic Database Alias None.
Chapter 7: Collection Formulas ClusterShortCall Type Import Description Identifies a call successfully established, but with a call duration of less than one second. In this case, the CallManager set the CallDuration value to 0 in the CDR table. A short call is also: • A successful call • Any inbound, outbound, or other type of call described in this chapter Syntax #Bulk Metric Generic Database Alias None.
Chapter 7: Collection Formulas ClusterSuccessfulCall Type Import Description Identifies a call successfully established. Once the call is established, the communication starts between the two parties. A successful call can be inbound, outbound, or any other type of call described in this chapter. Syntax #Bulk Metric Generic Database Alias None. Formula Editor Path AP > Specific > Bulk > VOIP > Cisco > CLUSTER Netcool/Proviso Cisco IP Telephony Technology Pack User’s Guide, Version 4.
Chapter 7: Collection Formulas ClusterTollBypassCall Type Import Description Identifies a call where the caller is an internal extension managed by the CallManager, and where the callee can be an internal extension or any external PSTN number, with one or more of the following criteria: • Outbound call • Off-net call • The call is going through a PSTN Gateway, and the caller site and PSTN Gateway site are different An intersite legacy PBX call can be also a toll bypass call if the PSTN Gateway site
Chapter 7: Collection Formulas ClusterTotalCall Type Import Description Total number of calls,including call attempts, for the entire cluster. Syntax #Bulk Metric Generic Database Alias None. Formula Editor Path AP > Specific > Bulk > VOIP > Cisco > CLUSTER Netcool/Proviso Cisco IP Telephony Technology Pack User’s Guide, Version 4.
Chapter 7: Collection Formulas ClusterTotalHoursOfTraffic Type Import Description Sum of all call durations for the period, measured in hours. Syntax #Bulk Metric Generic Database Alias None. Formula Editor Path AP > Specific > Bulk > VOIP > Cisco > CLUSTER 290 Netcool/Proviso Cisco IP Telephony Technology Pack User’s Guide, Version 4.
Chapter 7: Collection Formulas ClusterUnsuccessfulCall Type Import Description Identifies a call that has not been successfully established. In this case, the call setup has been rejected, and communication between the two parties never started. An unsuccessful call can be inbound, outbound, or any other type of call described in this chapter. Syntax #Bulk Metric Generic Database Alias None.
Chapter 7: Collection Formulas ClusterVoicemailCallDuration Type Import Description Duration of a call with the voicemail application, in seconds. Syntax #Bulk Metric Generic Database Alias None. Formula Editor Path AP > Specific > Bulk > VOIP > Cisco > CLUSTER 292 Netcool/Proviso Cisco IP Telephony Technology Pack User’s Guide, Version 4.
Chapter 7: Collection Formulas ClusterVoiceMailCall Type Import Description Identifies a call where the final destination (callee) is voicemail. The voicemail application is managed through a specific range of extensions numbers, defined site by site, using the global variable VoiceMailExtensionRange. Syntax #Bulk Metric Generic Database Alias None. Formula Editor Path AP > Specific > Bulk > VOIP > Cisco > CLUSTER Netcool/Proviso Cisco IP Telephony Technology Pack User’s Guide, Version 4.
Chapter 7: Collection Formulas ClusterVoicemailPackets Type Import Description Number of packets that the sub-element sent and received during a voicemail call. This metric comes from the CMR table. It is set once the call is established with one of the voicemail extensions. Syntax #Bulk Metric Generic Database Alias None. Formula Editor Path AP > Specific > Bulk > VOIP > Cisco > CLUSTER 294 Netcool/Proviso Cisco IP Telephony Technology Pack User’s Guide, Version 4.
Chapter 7: Collection Formulas CS Type Import Description The number of seconds of concealment during a call. Syntax #Bulk Metric Generic Database Alias None. Formula Editor Path AP > Specific > Bulk > VOIP > Cisco > CMR Netcool/Proviso Cisco IP Telephony Technology Pack User’s Guide, Version 4.
Chapter 7: Collection Formulas DropCall Type Import Description Identifies a call successfully established, but that has been dropped accidentally during the communication between the two parties. Syntax #Bulk Metric Generic Database Alias None. Formula Editor Path AP > Specific > Bulk > VOIP > Cisco > CDR 296 Netcool/Proviso Cisco IP Telephony Technology Pack User’s Guide, Version 4.
Chapter 7: Collection Formulas DSP Card Availability (percent) Type SNMP (collection) Description DSP card availability percentage. Syntax Def DefaultNoRespResult 0; Dim I1 AS Integer Default * NAME Interface; 100 * abs( delta(sysUpTime.0) * (1 + distrib(cdspCardState.%I1,"==1:1,==2:1,==3:1,==4:-1,==5:-1") )/2 - delta(sysUpTime.0)/2 * abs( delta(distrib(cdspCardState.%I1,"==1:1,==2:1,==3:-1,==4:-1,==5:-1"))/2 ) ) / delta(sysUpTime.0) Generic Database Alias None.
Chapter 7: Collection Formulas DSP Card Resource Utilization (percent) Type SNMP (collection) Description Total percentage of DSPs in use for a DSP card. Syntax cdspCardResourceUtilization.%I1 Generic Database Alias None. Formula Editor Path AP > Specific > SNMP > VOIP > Cisco > PSTN Gateway > DSP Card MIB CISCO-DSP-MGMT-MIB.my 298 Netcool/Proviso Cisco IP Telephony Technology Pack User’s Guide, Version 4.
Chapter 7: Collection Formulas EncryptedCallsActive Type Import Description Total number of currently active encrypted calls. Syntax #Bulk Metric Generic Database Alias None. Formula Editor Path AP > Specific > Bulk > VOIP > Cisco > Perfmon Netcool/Proviso Cisco IP Telephony Technology Pack User’s Guide, Version 4.
Chapter 7: Collection Formulas EncryptedPartiallyRegisteredPhones Type Import Description Total number of encrypted extensions that have not completed the registration process. Syntax #Bulk Metric Generic Database Alias None. Formula Editor Path AP > Specific > Bulk > VOIP > Cisco > Perfmon 300 Netcool/Proviso Cisco IP Telephony Technology Pack User’s Guide, Version 4.
Chapter 7: Collection Formulas EncryptedRegisteredPhones Type Import Description Total number of active authenticated calls. Syntax #Bulk Metric Generic Database Alias None. Formula Editor Path AP > Specific > Bulk > VOIP > Cisco > Perfmon Netcool/Proviso Cisco IP Telephony Technology Pack User’s Guide, Version 4.
Chapter 7: Collection Formulas ForwardToVoiceMail Type Import Description Identifies a call forwarded to another destination by the original callee. In this case, the destination is one of the voicemail extension numbers. Voicemail extension numbers are defined for a site through addVoiceMailRange() methods in the CCMConfig.js file. Syntax #Bulk Metric Generic Database Alias None.
Chapter 7: Collection Formulas FXOPortsActive Type Import Description Total number of FXO ports currently in use in the target device. Syntax #Bulk Metric Generic Database Alias None. Formula Editor Path AP > Specific > Bulk > VOIP > Cisco > Perfmon Netcool/Proviso Cisco IP Telephony Technology Pack User’s Guide, Version 4.
Chapter 7: Collection Formulas FXOPortsInService Type Import Description Total number of FXO ports available in the target device. Syntax #Bulk Metric Generic Database Alias None. Formula Editor Path AP > Specific > Bulk > VOIP > Cisco > Perfmon 304 Netcool/Proviso Cisco IP Telephony Technology Pack User’s Guide, Version 4.
Chapter 7: Collection Formulas FXSPortsActive Type Import Description Total number of FXS ports currently in use in the target device. Syntax #Bulk Metric Generic Database Alias None. Formula Editor Path AP > Specific > Bulk > VOIP > Cisco > Perfmon Netcool/Proviso Cisco IP Telephony Technology Pack User’s Guide, Version 4.
Chapter 7: Collection Formulas FXSPortsInService Type Import Description Total number of FXS ports available in the target device. Syntax #Bulk Metric Generic Database Alias None. Formula Editor Path AP > Specific > Bulk > VOIP > Cisco > Perfmon 306 Netcool/Proviso Cisco IP Telephony Technology Pack User’s Guide, Version 4.
Chapter 7: Collection Formulas Gatekeeper Buffer Utilization (percent) Type SNMP (collection) Description The percentage of a gatekeeper device’s buffer space that is in use. Syntax 100*((bufferSmTotal.0+bufferMdTotal.0+bufferBgTotal.0+bufferLgTotal.0+bufferHgTo tal.0)(bufferSmFree.0+bufferMdFree.0+bufferBgFree.0+bufferLgFree.0+bufferHgFree.0))/(b ufferSmTotal.0+bufferMdTotal.0+bufferBgTotal.0+bufferLgTotal.0+bufferHgTotal.0) Generic Database Alias None.
Chapter 7: Collection Formulas Gatekeeper Call Setup Quality (percent) Type SNMP (collection) Description Percentage of calls that have been set up successfully. Syntax 100 * (delta(cgkStatsAdmissionConfirms.0) + delta(cgkStatsRcvdLocationConfirms.0) + delta(cgkStatsSentLocationConfirms.0)) / (delta(cgkStatsAdmissionConfirms.0) + delta(cgkStatsRcvdLocationConfirms.0) + delta(cgkStatsSentLocationConfirms.0) + delta(cgkStatsAdmissionRejects.0) + delta(cgkStatsRcvdLocationRejects.
Chapter 7: Collection Formulas Gatekeeper CPU Utilization (percent) (avg last 5 mn) Type SNMP (collection) Description CPU utilization percentage over the last five minutes. Syntax avgBusy5.0 Generic Database Alias None. Formula Editor Path AP > Specific > SNMP > VOIP > Cisco > Gatekeeper > Device MIB cisco-10-mib Netcool/Proviso Cisco IP Telephony Technology Pack User’s Guide, Version 4.
Chapter 7: Collection Formulas Gatekeeper ICMP Inbound Errors (percent) Type SNMP (collection) Description Percentage of inbound ICMP packets that triggered errors. Syntax (100*(delta(icmpInErrors.0)/distrib(delta(icmpInMsgs.0), "==0:1, default:*")))*distrib(delta(sysUpTime.0), "default:1"); Generic Database Alias None. Formula Editor Path AP > Specific > SNMP > VOIP > Cisco > Gatekeeper > Device MIB rfc1213-MIB-II 310 Netcool/Proviso Cisco IP Telephony Technology Pack User’s Guide, Version 4.
Chapter 7: Collection Formulas Gatekeeper ICMP Outbound Errors (percent) Type SNMP (collection) Description Percentage of outbound ICMP packets that triggered errors. Syntax (100*(delta(icmpOutErrors.0)/distrib(delta(icmpOutMsgs.0), "==0:1, default:*")))*distrib(delta(sysUpTime.0), "default:1"); Generic Database Alias None. Formula Editor Path AP > Specific > SNMP > VOIP > Cisco > Gatekeeper > Device MIB rfc1213-MIB-II Netcool/Proviso Cisco IP Telephony Technology Pack User’s Guide, Version 4.
Chapter 7: Collection Formulas Gatekeeper Packet Errors (Nb) Type SNMP (collection) Description Total number of packet errors for a gatekeeper device. Syntax V1=OIDVAL(distrib(delta(sysUpTime.0), "default:1") * sum(*, delta(ifInDiscards.%I1) + delta(ifInErrors.%I1) + delta(ifInUnknownProtos.%I1))); V2=OIDVAL(distrib(delta(sysUpTime.0), "default:1") * sum(*, delta(ifOutDiscards.%I1) + delta(ifOutErrors.%I1))); %V1 + %V2; Generic Database Alias None.
Chapter 7: Collection Formulas Gatekeeper Total Number of Admission Rejects (Nb) Type SNMP (collection) Description Total number of admission rejections. Syntax V1=OIDVAL(distrib(delta(sysUpTime.0), "default:1") * delta(cgkStatsAdmissionRejects.0)); %V1; Generic Database Alias None. Formula Editor Path AP > Specific > SNMP > VOIP > Cisco > Gatekeeper > Device MIB rfc1213-MIB-II CISCO-GATEKEEPER-MIB.my Netcool/Proviso Cisco IP Telephony Technology Pack User’s Guide, Version 4.
Chapter 7: Collection Formulas Gatekeeper Total Number of Admission Requests (Nb) Type SNMP (collection) Description Total number of gatekeeper admission requests. Syntax V1=OIDVAL(distrib(delta(sysUpTime.0), "default:1") * delta(cgkStatsAdmissionRequests.0)); %V1; Generic Database Alias None. Formula Editor Path AP > Specific > SNMP > VOIP > Cisco > Gatekeeper > Device MIB CISCO-GATEKEEPER-MIB.my rfc1213-MIB-II 314 Netcool/Proviso Cisco IP Telephony Technology Pack User’s Guide, Version 4.
Chapter 7: Collection Formulas Gatekeeper Total Number of Concurrent Calls (Nb) (Gauge) Type SNMP (collection) Description Total number of concurrent calls for a gatekeeper device. Syntax cgkStatsTotalConcurrentCalls.0 Generic Database Alias None. Formula Editor Path AP > Specific > SNMP > VOIP > Cisco > Gatekeeper > Device MIB CISCO-GATEKEEPER-MIB.my Netcool/Proviso Cisco IP Telephony Technology Pack User’s Guide, Version 4.
Chapter 7: Collection Formulas Gatekeeper Total Number of Location Rejects (Nb) Type SNMP (collection) Description Total number of location reject messages that a gatekeeper device sent and received. Syntax V1=OIDVAL(distrib(delta(sysUpTime.0), "default:1") * ( delta(cgkStatsRcvdLocationRejects.0) + delta(cgkStatsSentLocationRejects.0 ))); %V1; Generic Database Alias None. Formula Editor Path AP > Specific > SNMP > VOIP > Cisco > Gatekeeper > Device MIB rfc1213-MIB-II CISCO-GATEKEEPER-MIB.
Chapter 7: Collection Formulas Gatekeeper Total Number of Location Requests (Nb) Type SNMP (collection) Description Total number of location requests that a gatekeeper device sent and received. Syntax V1=OIDVAL(distrib(delta(sysUpTime.0), "default:1") * ( delta(cgkStatsRcvdLocationRequests.0) + delta(cgkStatsSentLocationRequests.0)) ); %V1; Generic Database Alias None. Formula Editor Path AP > Specific > SNMP > VOIP > Cisco > Gatekeeper > Device MIB rfc1213-MIB-II CISCO-GATEKEEPER-MIB.
Chapter 7: Collection Formulas Gatekeeper Total Number of Registered EndPoints (Nb) Type SNMP (collection) Description Total number of endpoints registered to a Cisco gatekeeper. Syntax cgkStatsRegisteredEndpoints.0 Generic Database Alias None. Formula Editor Path AP > Specific > SNMP > VOIP > Cisco > Gatekeeper > Device MIB CISCO-GATEKEEPER-MIB.my 318 Netcool/Proviso Cisco IP Telephony Technology Pack User’s Guide, Version 4.
Chapter 7: Collection Formulas Gatekeeper Total Packets (Nb) Type SNMP (collection) Description Total number of packets that the gatekeeper device sent and received. Syntax V1=OIDVAL(distrib(delta(sysUpTime.0), "default:1") * ( delta(ipForwDatagrams.0) + delta(ipOutRequests.0) + delta(ipInReceives.0) )); %V1; Generic Database Alias None.
Chapter 7: Collection Formulas GatewayCallsActive Type Import Description Total number of currently active calls for the gateway resource or resources specified. Syntax #Bulk Metric Generic Database Alias None. Formula Editor Path AP > Specific > Bulk > VOIP > Cisco > Perfmon 320 Netcool/Proviso Cisco IP Telephony Technology Pack User’s Guide, Version 4.
Chapter 7: Collection Formulas H323CallsActive Type Import Description Total number of currently active H.323 calls for the resource or resources specified. Syntax #Bulk Metric Generic Database Alias None. Formula Editor Path AP > Specific > Bulk > VOIP > Cisco > Perfmon Netcool/Proviso Cisco IP Telephony Technology Pack User’s Guide, Version 4.
Chapter 7: Collection Formulas H323CallsInProgress Type Import Description Total number of H.323 calls being established at the time of sampling. Syntax #Bulk Metric Generic Database Alias None. Formula Editor Path AP > Specific > Bulk > VOIP > Cisco > Perfmon 322 Netcool/Proviso Cisco IP Telephony Technology Pack User’s Guide, Version 4.
Chapter 7: Collection Formulas HuntlistCallsActive Type Import Description Total number of currently active huntlist calls. Syntax #Bulk Metric Generic Database Alias None. Formula Editor Path AP > Specific > Bulk > VOIP > Cisco > Perfmon Netcool/Proviso Cisco IP Telephony Technology Pack User’s Guide, Version 4.
Chapter 7: Collection Formulas HuntlistCallsInProgress Type Import Description Total number of currently active huntlist calls. Syntax #Bulk Metric Generic Database Alias None. Formula Editor Path AP > Specific > Bulk > VOIP > Cisco > Perfmon 324 Netcool/Proviso Cisco IP Telephony Technology Pack User’s Guide, Version 4.
Chapter 7: Collection Formulas ICR Type Import Description Interval Conceal Ratio. The average concealment rate measured during the last three seconds of speech. Syntax #Bulk Metric Generic Database Alias None. Formula Editor Path AP > Specific > Bulk > VOIP > Cisco > CMR Netcool/Proviso Cisco IP Telephony Technology Pack User’s Guide, Version 4.
Chapter 7: Collection Formulas ICRmx Type Import Description Maximum conceal ratio during a call. Syntax #Bulk Metric Generic Database Alias None. Formula Editor Path AP > Specific > Bulk > VOIP > Cisco > CMR 326 Netcool/Proviso Cisco IP Telephony Technology Pack User’s Guide, Version 4.
Chapter 7: Collection Formulas Inbound Loss (percent) Type Generic Description Of all inbound traffic received by this entity, the percentage of PDUs that either: • Contained defects (such bad checksums or bad length) that prevented them from being deliverable to a higher-layer protocol. • Were discarded even though no errors were detected (that is, due to congestion, policing, or resource limitations). • Were discarded because they were of an unknown or unsupported protocol.
Chapter 7: Collection Formulas Incoming Type Import Description Identifies a call where caller is not an internal extension. An Incoming call is also: • An Inbound call • An off-net call, coming from the PSTN Syntax #Bulk Metric Generic Database Alias None. Formula Editor Path AP > Specific > Bulk > VOIP > Cisco > CDR 328 Netcool/Proviso Cisco IP Telephony Technology Pack User’s Guide, Version 4.
Chapter 7: Collection Formulas Interface Availability (percent) Type Generic Description The percentage of time that this interface was in an operational state. Alias For Availability (percent) Formula Editor Path AP > Generic > Universal > Availability Netcool/Proviso Cisco IP Telephony Technology Pack User’s Guide, Version 4.
Chapter 7: Collection Formulas Interface Availability (percent) Type SNMP (collection) Description Percentage of availability of a PSTN gateway interface. Syntax Def DefaultNoRespResult 0; Dim I1 AS Integer Default * NAME Interface; 100 * abs( delta(sysUpTime.0) * (1 + distrib(ifOperStatus.%I1,"==1:1,==2:-1,==3:1") )/2 - delta(sysUpTime.0)/2 * abs( delta(distrib(ifOperStatus.%I1,"==1:1,==2:1,==3:-1"))/2 ) ) / delta(sysUpTime.0) Generic Database Alias None.
Chapter 7: Collection Formulas Interface Availability (percent) Type SNMP (collection) Description Interface availability percentage for a Cisco gatekeeper. Syntax Def DefaultNoRespResult 0; Dim I1 AS Integer Default * NAME Interface; 100 * abs( delta(sysUpTime.0) * (1 + distrib(ifOperStatus.%I1,"==1:1,==2:-1,==3:1") )/2 - delta(sysUpTime.0)/2 * abs( delta(distrib(ifOperStatus.%I1,"==1:1,==2:1,==3:-1"))/2 ) ) / delta(sysUpTime.0) Generic Database Alias None.
Chapter 7: Collection Formulas Interface Bandwidth Utilization In (percent) Type SNMP (collection) Description Inbound bandwidth utilization percentage for a PSTN gateway interface. Syntax Dim I1 AS Integer Default *; 100 * 8 * delta(ifInOctets.%I1) / ((delta(sysUpTime.0) / 100) * ifSpeed.%I1) * distrib(delta(ifLastChange.%I1), "==0:1") Generic Database Alias None.
Chapter 7: Collection Formulas Interface Bandwidth Utilization In (percent) Type SNMP (collection) Description Inbound bandwidth utilization measured on a Gatekeeper interface. Syntax Dim I1 AS Integer Default *; 100 * 8 * delta(ifInOctets.%I1) / ((delta(sysUpTime.0) / 100) * ifSpeed.%I1) * distrib(delta(ifLastChange.%I1), "==0:1") Generic Database Alias None.
Chapter 7: Collection Formulas Interface Bandwidth Utilization Out (percent) Type SNMP (collection) Description Outbound bandwidth utilization percentage for a PSTN gateway interface. Syntax Dim I1 AS Integer Default *; 100 * 8 * delta(ifOutOctets.%I1) / ((delta(sysUpTime.0) / 100) * ifSpeed.%I1) * distrib(delta(ifLastChange.%I1), "==0:1") Generic Database Alias None.
Chapter 7: Collection Formulas Interface Bandwidth Utilization Out (percent) Type SNMP (collection) Description Outbound bandwidth utilization measured on a Gatekeeper interface. Syntax Dim I1 AS Integer Default *; 100 * 8 * delta(ifOutOctets.%I1) / ((delta(sysUpTime.0) / 100) * ifSpeed.%I1) * distrib(delta(ifLastChange.%I1), "==0:1") Generic Database Alias None.
Chapter 7: Collection Formulas Interface Packet Loss (percent) Type SNMP (collection) Description Percentage of interface packet loss. Syntax Dim I1 AS Integer Default * NAME Interface; 100 * (delta(ifInErrors.%I1) + delta(ifInUnknownProtos.%I1) + delta(ifInDiscards.%I1) + delta(ifOutErrors.%I1) + delta(ifOutDiscards.%I1)) / distrib(delta(ifInUcastPkts.%I1) + delta(ifInNUcastPkts.%I1) + delta(ifInDiscards.%I1) + delta(ifInErrors.%I1) + delta(ifInUnknownProtos.%I1) + delta(ifOutUcastPkts.
Chapter 7: Collection Formulas Interface Packet Loss (percent) Type SNMP (collection) Description Total percentage of packets lost for a gatekeeper interface. Syntax Dim I1 AS Integer Default * NAME Interface; 100 * (delta(ifInErrors.%I1) + delta(ifInUnknownProtos.%I1) + delta(ifInDiscards.%I1) + delta(ifOutErrors.%I1) + delta(ifOutDiscards.%I1)) / distrib(delta(ifInUcastPkts.%I1) + delta(ifInNUcastPkts.%I1) + delta(ifInDiscards.%I1) + delta(ifInErrors.%I1) + delta(ifInUnknownProtos.
Chapter 7: Collection Formulas Interface Throughput In (kbps) Type SNMP (collection) Description Inbound interface throughput measured in kilobits per second. Syntax Dim I1 AS Integer Default * NAME Interface; (8 * delta(ifInOctets.%I1) / (delta(sysUpTime.0)/100))/1000 * distrib(delta(ifLastChange.%I1), "==0:1") Generic Database Alias None.
Chapter 7: Collection Formulas Interface Throughput In (kbps) Type SNMP (collection) Description Total inbound throughput for a Gatekeeper interface, measured in kilobits per second. Syntax Dim I1 AS Integer Default * NAME Interface; (8 * delta(ifInOctets.%I1) / (delta(sysUpTime.0)/100))/1000 * distrib(delta(ifLastChange.%I1), "==0:1") Generic Database Alias None.
Chapter 7: Collection Formulas Interface Throughput Out (kbps) Type SNMP (collection) Description Outbound interface throughput measured in kilobits per second. Syntax Dim I1 AS Integer Default * NAME Interface; (8 * delta(ifOutOctets.%I1) / (delta(sysUpTime.0)/100))/1000 * distrib(delta(ifLastChange.%I1), "==0:1") Generic Database Alias None.
Chapter 7: Collection Formulas Interface Throughput Out (kbps) Type SNMP (collection) Description Total outbound throughput for a Gatekeeper interface, measured in kilobits per second. Syntax Dim I1 AS Integer Default * NAME Interface; (8 * delta(ifOutOctets.%I1) / (delta(sysUpTime.0)/100))/1000 * distrib(delta(ifLastChange.%I1), "==0:1") Generic Database Alias None.
Chapter 7: Collection Formulas Internal Type Import Description A call between two internal extensions, managed by one or more CallManager clusters, where the caller and callee extension numbers are short, internal numbers.
Chapter 7: Collection Formulas International Type Import Description Identifies a call where the caller is an internal extension and the callee is an international external PSTN number, according to the numbering plan (NANP or other prefixes). An international call is also: • An outbound call • An off-net call, routed towards the PSTN • A toll bypassCall, if a remote PSTN Gateway is involved in the voice path Syntax #Bulk Metric Generic Database Alias None.
Chapter 7: Collection Formulas IntersiteIPCall Type Import Description Identifies a specific internal Call where caller and callee are from different sites and are using a pure IP network transit path (that is, no PSTN Gateway is involved in the voice Path). Syntax #Bulk Metric Generic Database Alias None. Formula Editor Path AP > Specific > Bulk > VOIP > Cisco > CDR 344 Netcool/Proviso Cisco IP Telephony Technology Pack User’s Guide, Version 4.
Chapter 7: Collection Formulas IntersiteLegacyPBXCall Type Import Description Identifies a specific internal call where the caller and callee are from different sites and where the voice path goes through a PSTN Gateway. The call can be between any of the following: • One IP phone and one legacy phone from two different siteas, according to their extension range number. The legacy phone is managed by a legacy PBX, which is interconnected to the CallManager through a PSTN Gateway.
Chapter 7: Collection Formulas IntrasiteIPCall Type Import Description Identifies a specific internal Call where the caller and callee are both at the same site and are using a pure IP Network transit path (that is, no PSTN Gateway is involved in the voice path). Ranges of internal extensions are defined for a specific site through addExtensionRange() methods called for the site object in the CCMConfig.js file. Syntax #Bulk Metric Generic Database Alias None.
Chapter 7: Collection Formulas IntrasiteLegacyPBXCall Type Import Description Identifies a specific internal Call where the caller and callee are both at the same site, but where the voice path goes through a PSTN Gateway. The call can be between one IP phone and one legacy phone from the same location, according to their extension range number. The legacy phone is managed by a legacy PBX, which is interconnected to the CallManager through a PSTN Gateway.
Chapter 7: Collection Formulas isCallee Type Import Description Identifies the callee portion of the call. Syntax #Bulk Metric Generic Database Alias None. Formula Editor Path AP > Specific > Bulk > VOIP > Cisco > CDR 348 Netcool/Proviso Cisco IP Telephony Technology Pack User’s Guide, Version 4.
Chapter 7: Collection Formulas isCaller Type Import Description Identifies the caller portion of the call. Syntax #Bulk Metric Generic Database Alias None. Formula Editor Path AP > Specific > Bulk > VOIP > Cisco > CDR Netcool/Proviso Cisco IP Telephony Technology Pack User’s Guide, Version 4.
Chapter 7: Collection Formulas Jitter Type Import Description Provides an estimate of the statistical variance of the RTP data packet interval, in milliseconds. This metric comes from the CMR table. It is set once the call is established. This metric is only available for IP phones. Syntax #Bulk Metric Generic Database Alias None. Formula Editor Path AP > Specific > Bulk > VOIP > Cisco > CMR 350 Netcool/Proviso Cisco IP Telephony Technology Pack User’s Guide, Version 4.
Chapter 7: Collection Formulas Latency Type Import Description An estimate of network latency, expressed in milliseconds. This value represents the average of the difference between the NTP timestamp indicated by the RTP Control Protocol (RTCP) messages and the NTP timestamp of the receivers, measured when these messages are received. Cisco CallManager obtains the average by summing all the estimates, and then dividing by the number of RTCP messages that have been received.
Chapter 7: Collection Formulas Local Type Import Description Identifies a call where the caller is an internal extension and the callee is a local external PSTN number, according to the numbering plan (NANP or other prefixes). A local call is also any of these call types: • Outbound • Off-net, routed towards the PSTN • Toll bypass, if a remote PSTN Gateway is involved in the voice path The file CCMConfig.js contains methods that specify local call prefixes for a given site.
Chapter 7: Collection Formulas LongDistance Type Import Description Identifies a call where the caller is an internal extension and where the callee is a long distance external PSTN number, according to the numbering plan (NANP or other prefixes). A long distance call is also any of these call types: • Outbound • Off-net, routed towards the PSTN • Toll bypass, if a remote PSTN Gateway is involved in the voice path Syntax #Bulk Metric Generic Database Alias None.
Chapter 7: Collection Formulas MLQKav Type Import Description Average MOS Listening Quality K-factor for a call Syntax #Bulk Metric Generic Database Alias None. Formula Editor Path AP > Specific > Bulk > VOIP > Cisco > CMR 354 Netcool/Proviso Cisco IP Telephony Technology Pack User’s Guide, Version 4.
Chapter 7: Collection Formulas MLQK Type Import Description MOS Listening Quality K-factor. This is an estimate of the MOS score of the last eight seconds of speech measured on the receiving end. Syntax #Bulk Metric Generic Database Alias None. Formula Editor Path AP > Specific > Bulk > VOIP > Cisco > CMR Netcool/Proviso Cisco IP Telephony Technology Pack User’s Guide, Version 4.
Chapter 7: Collection Formulas MLQKmn Type Import Description Minimum MOS Listening Quality K-factor for the worst-sounding eight seconds. Syntax #Bulk Metric Generic Database Alias None. Formula Editor Path AP > Specific > Bulk > VOIP > Cisco > CMR 356 Netcool/Proviso Cisco IP Telephony Technology Pack User’s Guide, Version 4.
Chapter 7: Collection Formulas MOHMulticastResourceActive Type Import Description Total number of currently active message-on-hold multicast resources. Syntax #Bulk Metric Generic Database Alias None. Formula Editor Path AP > Specific > Bulk > VOIP > Cisco > Perfmon Netcool/Proviso Cisco IP Telephony Technology Pack User’s Guide, Version 4.
Chapter 7: Collection Formulas MOHMulticastResourceAvailable Type Import Description Total number of available message-on-hold multicast resources. Syntax #Bulk Metric Generic Database Alias None. Formula Editor Path AP > Specific > Bulk > VOIP > Cisco > Perfmon 358 Netcool/Proviso Cisco IP Telephony Technology Pack User’s Guide, Version 4.
Chapter 7: Collection Formulas MOHTotalMulticastResources Type Import Description Total number of active and inactive message-on-hold multicast resources. Syntax #Bulk Metric Generic Database Alias None. Formula Editor Path AP > Specific > Bulk > VOIP > Cisco > Perfmon Netcool/Proviso Cisco IP Telephony Technology Pack User’s Guide, Version 4.
Chapter 7: Collection Formulas MOHTotalUnicastResources Type Import Description Total number of active and inactive message-on-hold unicast resources. Syntax #Bulk Metric Generic Database Alias None. Formula Editor Path AP > Specific > Bulk > VOIP > Cisco > Perfmon 360 Netcool/Proviso Cisco IP Telephony Technology Pack User’s Guide, Version 4.
Chapter 7: Collection Formulas MOHUnicastResourceActive Type Import Description Total number of currently active message-on-hold unicast resources. Syntax #Bulk Metric Generic Database Alias None. Formula Editor Path AP > Specific > Bulk > VOIP > Cisco > Perfmon Netcool/Proviso Cisco IP Telephony Technology Pack User’s Guide, Version 4.
Chapter 7: Collection Formulas MOHUnicastResourceAvailable Type Import Description Total number of available message-on-hold unicast resources. Syntax #Bulk Metric Generic Database Alias None. Formula Editor Path AP > Specific > Bulk > VOIP > Cisco > Perfmon 362 Netcool/Proviso Cisco IP Telephony Technology Pack User’s Guide, Version 4.
Chapter 7: Collection Formulas MOS Type Import Description The mean opinion score (MOS). This is a high-level metric. In voice communications, particularly internet telephony, the MOS provides a numeric measure of the quality of human speech at the destination end of the circuit. There is no algorithm for MOS calculations. This is a subjective metric based on the end-user’s judgment of call quality.
Chapter 7: Collection Formulas NbPacketsLost Type Import Description Number of packets the sub-element lost during a call. This metric comes from the CMR table. It is set once the call is established. This metric is only available for IP phones. Syntax #Bulk Metric Generic Database Alias None. Formula Editor Path AP > Specific > Bulk > VOIP > Cisco > CMR 364 Netcool/Proviso Cisco IP Telephony Technology Pack User’s Guide, Version 4.
Chapter 7: Collection Formulas NbPacketsReceived Type Import Description Number of packets that the sub-element received during a call. This metric comes from the CMR table. It is set once the call is established. This metric is only available for IP phones. Syntax #Bulk Metric Generic Database Alias None. Formula Editor Path AP > Specific > Bulk > VOIP > Cisco > CMR Netcool/Proviso Cisco IP Telephony Technology Pack User’s Guide, Version 4.
Chapter 7: Collection Formulas NbPacketsSent Type Import Description Number of packets that the sub-element sent during a call. This metric comes from the CMR table. It is set once the call is established. This metric is only available for IP phones. Syntax #Bulk Metric Generic Database Alias None. Formula Editor Path AP > Specific > Bulk > VOIP > Cisco > CMR 366 Netcool/Proviso Cisco IP Telephony Technology Pack User’s Guide, Version 4.
Chapter 7: Collection Formulas OffNet Type Import Description Identifies a call where at least one PSTN Gateway is involved in the voice path, with the following criteria: • Inbound or outbound call • Internal call or call to/from a PSTN number • Intersite or intrasite legacy PBX call Syntax #Bulk Metric Generic Database Alias None. Formula Editor Path AP > Specific > Bulk > VOIP > Cisco > CDR Netcool/Proviso Cisco IP Telephony Technology Pack User’s Guide, Version 4.
Chapter 7: Collection Formulas OnNet Type Import Description Identifies a call where both the caller and callee are internal extensions, from the same site or different sites, with the following criteria: • Outbound call • Internal call • Intersite or intrasite IP call • No PSTN Gateway is involved in the voice path • The call is a pure IP to IP call Syntax #Bulk Metric Generic Database Alias None.
Chapter 7: Collection Formulas Outbound Loss (percent) Type Generic Description Out of all outbound traffic to be sent by this entity, the percentage of PDUs that either: • Contained defects that prevented them from being transferable • Were discarded even though no errors were detected (that is, due to congestion or resource limitations) Alias For No formulas are mapped to this alias.
Chapter 7: Collection Formulas Percentage of Company Calls (percent) CME(Bulk) VOIP Cisco Type CME Description Ratio between company calls and the total number of calls. For a definition of company calls, see Cluster Total Number of Company Calls (Nb). Syntax (isCaller + isCallee) = 0 ifTrue: [^nil].
Chapter 7: Collection Formulas Percentage of Drop Calls (percent) CME(Bulk) VOIP Cisco Type CME Description Ratio between dropped calls and the total number of calls. Syntax (isCaller + isCallee) = 0 ifTrue: [^nil]. ^(100*(DropCalls/(isCaller + isCallee))) Formula Input Input: DropCalls Source: DropCall (Formula) Input: isCallee Source: isCallee (Formula) Input: isCaller Source: isCaller (Formula) Generic Database Alias None.
Chapter 7: Collection Formulas Percentage of Packet Lost (percent) CME(Bulk) VOIP Cisco Type CME Description Ratio between packets lost and the total number of packets sent and received. Syntax ^(100*(NbPacketsLost/(NbPacketsReceived+NbPacketsSent))) Formula Input Input: NbPacketsLost Source: NbPacketsLost (Formula) Input: NbPacketsReceived Source: NbPacketsReceived (Formula) Input: NbPacketsSent Source: NbPacketsSent (Formula) Generic Database Alias None.
Chapter 7: Collection Formulas Percentage of Successful Calls (Nb) CME(Bulk) VOIP Cisco Type CME Description Ratio between the number of successful calls and the total number of calls. Syntax (successful+unsuccessful) = 0 ifTrue: [^nil]. ^(100*(successful/(successful+unsuccessful))) Formula Input Input: successful Source: SuccessfulCall (Formula) Input: unsuccessful Source: UnsuccessfulCall (Formula) Generic Database Alias None.
Chapter 7: Collection Formulas Percentage of TollBypass Calls (percent) CME(Bulk) VOIP Cisco Type CME Description Ratio between toll bypass calls and the total number of calls. Syntax (isCaller + isCallee) = 0 ifTrue: [^nil]. ^(100*(TollBypassCall/(isCaller + isCallee))) Formula Input Input: isCallee Source: isCallee (Formula) Input: isCaller Source: isCaller (Formula) Input: TollBypassCall Source: TollBypassCall (Formula) Generic Database Alias None.
Chapter 7: Collection Formulas PSTN Gateway Active DS0 Channels (Nb) (Gauge) Type SNMP (collection) Description The total number of currently active DS0 channels for a PSTN gateway PRI. Syntax DEF SaveAlias 10703; cpmActiveDS0s.0 Generic Database Alias PSTN Gateway Active DS0 Channels (Nb) Formula Editor Path AP > Specific > SNMP > VOIP > Cisco > PSTN Gateway > POP DS0 Channel Usage MIB CISCO-POP-MGMT-MIB.my Netcool/Proviso Cisco IP Telephony Technology Pack User’s Guide, Version 4.
Chapter 7: Collection Formulas PSTN Gateway Active DS0 Channels (Nb) (Gauge) Type SNMP (collection) Description The total number of currently active DS0 channels for a PSTN gateway. Syntax DEF SaveAlias 10703; Dim I0 AS Integer Default * NAME If; V1=OIDVAL( 8 * delta(ifOutOctets.%I0) ); V2=OIDVAL(delta(sysUpTime.0)/100) ; V3=OIDVAL((%V1/%V2)/64000); V4=OIDVAL(int(%V3)); V5=OIDVAL(distrib(ifType.
Chapter 7: Collection Formulas PSTN Gateway Active DS0 Channels (Nb) Type Generic Description The total number of active DS0 channels for all of the enabled PRIs in a PSTN device. Alias For PSTN Gateway Active DS0 Channels (Nb) (Gauge) PSTN Gateway Active DS0 Channels (Nb) (Gauge) PSTN Gateway Total Active DS0 Channels (Nb) (Gauge) Formula Editor Path AP > Generic > VOIP > Cisco > PSTN Gateway Netcool/Proviso Cisco IP Telephony Technology Pack User’s Guide, Version 4.
Chapter 7: Collection Formulas PSTN Gateway Call Setup Quality (percent) (Successful / Total) Type Generic Description Percentage of successful call setups for a PSTN gateway device. Alias For PSTN Gateway Call Setup Quality (percent) (successful / Total) PSTN Gateway Call Setup Quality (percent) (successful / unsuccessful) Formula Editor Path AP > Generic > VOIP > Cisco > PSTN Gateway 378 Netcool/Proviso Cisco IP Telephony Technology Pack User’s Guide, Version 4.
Chapter 7: Collection Formulas PSTN Gateway Call Setup Quality (percent) (successful / Total) Type SNMP (collection) Description The percentage of successful call setups for a PSTN gateway device. Syntax DEF SaveAlias 10708; V1= OIDVAL(sum(*, delta(isdnSigStatsInCalls.*))); V2= OIDVAL(sum(*, delta(isdnSigStatsOutCalls.*))); V3= OIDVAL(sum(*, delta(isdnSigStatsInConnected.*))); V4= OIDVAL(sum(*, delta(isdnSigStatsOutConnected.
Chapter 7: Collection Formulas PSTN Gateway Call Setup Quality (percent) (successful / unsuccessful) Type SNMP (collection) Description Total call setup quality for a PSTN device (successful/unsuccessful). Syntax DEF SaveAlias 10708; 100*(delta(cpmCallVolSuccISDNDigital.0) / delta(cpmCallVolSuccISDNDigital.0) + delta(cpmISDNCallsRejected.0) + delta(cpmISDNCallsClearedAbnormally.0) + delta(cpmISDNNoResource.
Chapter 7: Collection Formulas PSTN Gateway DS1 Active DS0 Channels (Nb) Type SNMP (collection) Description Number of active DS0 channels that are active for a specific serial E1/T1 interface. Because there is no specific OID for this measurement in the MIB, this metric assumes the following: • 1 Call = 1 DS0 Channel = 64 kbps • Throughput (in or out) / 64000 = Active Channels Syntax Dim I1 AS Integer Default * NAME If; V1=OIDVAL( 8 * delta(ifOutOctets.%I1) ); V2=OIDVAL(delta(sysUpTime.
Chapter 7: Collection Formulas PSTN Gateway ICMP Inbound Errors (percent) Type SNMP (collection) Description Percentage of inbound ICMP errors. Syntax (100*(delta(icmpInErrors.0)/distrib(delta(icmpInMsgs.0), "==0:1, default:*")))*distrib(delta(sysUpTime.0), "default:1"); Generic Database Alias None. Formula Editor Path AP > Specific > SNMP > VOIP > Cisco > PSTN Gateway > Device MIB rfc1213-MIB-II 382 Netcool/Proviso Cisco IP Telephony Technology Pack User’s Guide, Version 4.
Chapter 7: Collection Formulas PSTN Gateway ICMP Outbound Errors (percent) Type SNMP (collection) Description Percentage of outbound SNMP errors. Syntax (100*(delta(icmpOutErrors.0)/distrib(delta(icmpOutMsgs.0), "==0:1, default:*")))*distrib(delta(sysUpTime.0), "default:1"); Generic Database Alias None. Formula Editor Path AP > Specific > SNMP > VOIP > Cisco > PSTN Gateway > Device MIB rfc1213-MIB-II Netcool/Proviso Cisco IP Telephony Technology Pack User’s Guide, Version 4.
Chapter 7: Collection Formulas PSTN Gateway Network Errors (percent) Type SNMP (collection) Description Percentage of network errors observed by a PSTN gateway. Syntax distrib(delta(sysUpTime.0), "default:1") * ((delta(ipOutDiscards.0)+delta(ipInDiscards.0)+delta(ipOutNoRoutes.0)+delta(icmp InErrors.0)+delta(icmpOutErrors.0))/(delta(ipForwDatagrams.0) + delta(ipOutRequests.0) + delta(ipInReceives.0)))*100 Generic Database Alias None.
Chapter 7: Collection Formulas PSTN Gateway Packet Discards Type SNMP (collection) Description The total number of PSTN Gateway packets discarded. Syntax distrib(delta(sysUpTime.0), "default:1") * ((delta(ipOutDiscards.0)+delta(ipInDiscards.0))/(delta(ipForwDatagrams.0) + delta(ipOutRequests.0) + delta(ipInReceives.0)))*100 Generic Database Alias None.
Chapter 7: Collection Formulas PSTN Gateway Total Active DS0 Channels (Nb) (Gauge) Type SNMP (collection) Description The total number of currently active DS0 channels for a PSTN Gateway. Syntax DEF SaveAlias 10703; V1= OIDVAL(sum(*, distrib(isdnBearerOperStatus.
Chapter 7: Collection Formulas PSTN Gateway Total Call Signaling Errors (Nb) Type SNMP (collection) Description The total number of signaling errors observed for a PSTN Gateway. Syntax DEF SaveAlias 10707; delta(cpmISDNCallsRejected.0) + delta(cpmISDNCallsClearedAbnormally.0) + delta(cpmISDNNoResource.0) Generic Database Alias PSTN Gateway Total Number of Unsuccessful Calls (Nb) Formula Editor Path AP > Specific > SNMP > VOIP > Cisco > PSTN Gateway > POP DS0 Channel Usage MIB CISCO-POP-MGMT-MIB.
Chapter 7: Collection Formulas PSTN Gateway Total Calls per minute (calls/mn) (sum of all DS0s) Type SNMP (collection) Description The total calls per minute summed for all configured PRIs on a PSTN Gateway. Syntax DEF SaveAlias 10705; V1= OIDVAL(sum(*, (delta(cpmCallCount.%I1.%I2.%I3)/(delta(sysUpTime.
Chapter 7: Collection Formulas PSTN Gateway Total Number Calls Rejected (Nb) Type SNMP (collection) Description The total number of rejected calls for a PSTN Gateway. Syntax DEF SaveAlias 10707; V1= OIDVAL(distrib(delta(sysUpTime.0), "default:1") * sum(*, delta(isdnSigStatsOutConnected.*))); V2= OIDVAL(distrib(delta(sysUpTime.0), "default:1") * sum(*, delta(isdnSigStatsOutCalls.*))); V3= OIDVAL(distrib(delta(sysUpTime.0), "default:1") * sum(*, delta(isdnSigStatsInConnected.
Chapter 7: Collection Formulas PSTN Gateway Total Number of Calls (Nb) Type Generic Description The total number of calls for a PSTN device. Alias For PSTN Gateway Total Number of Calls PSTN Gateway Total Number of Calls (sum of all DS0s) Formula Editor Path AP > Generic > VOIP > Cisco > PSTN Gateway 390 Netcool/Proviso Cisco IP Telephony Technology Pack User’s Guide, Version 4.
Chapter 7: Collection Formulas PSTN Gateway Total Number of Calls (sum of all DS0s) Type SNMP (collection) Description The total number of currently active calls for all DS0s configured in a PSTN Gateway. Syntax DEF SaveAlias 10704; V1= OIDVAL(sum(*, delta(cpmCallCount.%I1.%I2.%I3))); %V1 Generic Database Alias PSTN Gateway Total Number of Calls (Nb) Formula Editor Path AP > Specific > SNMP > VOIP > Cisco > PSTN Gateway > POP DS0 Channel Usage MIB CISCO-POP-MGMT-MIB.
Chapter 7: Collection Formulas PSTN Gateway Total Number of Calls per mn (Calls/mn) Type Generic Description The total number of calls per minute for a PSTN device. Alias For PSTN Gateway Total Calls per minute (calls/mn) (sum of all DS0s) PSTN Gateway Total Number of Calls per mn (Calls/mn) Formula Editor Path AP > Generic > VOIP > Cisco > PSTN Gateway 392 Netcool/Proviso Cisco IP Telephony Technology Pack User’s Guide, Version 4.
Chapter 7: Collection Formulas PSTN Gateway Total Number of Calls per mn (Calls/mn) Type SNMP (collection) Description The total number of calls per minute for a PSTN Gateway. Syntax DEF SaveAlias 10705; V1 = OIDVAL(sum(*, delta(isdnSigStatsInCalls.*))); V2 = OIDVAL(sum(*, delta(isdnSigStatsOutCalls.*))); V3 = (%V1+%V2)/(delta(sysUpTime.
Chapter 7: Collection Formulas PSTN Gateway Total Number of Calls Type SNMP (collection) Description The total number of calls observed by a PSTN Gateway. Syntax DEF SaveAlias 10704; V1= OIDVAL(distrib(delta(sysUpTime.0), "default:1") * sum(*, delta(isdnSigStatsInCalls.*))); V2= OIDVAL(distrib(delta(sysUpTime.0), "default:1") * sum(*, delta(isdnSigStatsOutCalls.
Chapter 7: Collection Formulas PSTN Gateway Total Number of Successful Calls (Nb) Type Generic Description The total number of successful calls for a PSTN gateway device. Alias For PSTN Gateway Total Number of Successful Calls (Nb) PSTN Gateway Total Number of Successful Calls (Nb) Formula Editor Path AP > Generic > VOIP > Cisco > PSTN Gateway Netcool/Proviso Cisco IP Telephony Technology Pack User’s Guide, Version 4.
Chapter 7: Collection Formulas PSTN Gateway Total Number of Successful Calls (Nb) Type SNMP (collection) Description The total number of successful calls for a PSTN Gateway. Syntax DEF SaveAlias 10706; delta(cpmCallVolSuccISDNDigital.0) Generic Database Alias PSTN Gateway Total Number of Successful Calls (Nb) Formula Editor Path AP > Specific > SNMP > VOIP > Cisco > PSTN Gateway > POP DS0 Channel Usage MIB CISCO-POP-MGMT-MIB.
Chapter 7: Collection Formulas PSTN Gateway Total Number of Successful Calls (Nb) Type SNMP (collection) Description The total number of successful calls made through a PSTN Gateway. Syntax DEF SaveAlias 10706; V1= OIDVAL(distrib(delta(sysUpTime.0), "default:1") * sum(*, delta(isdnSigStatsInConnected.*))); V2= OIDVAL(distrib(delta(sysUpTime.0), "default:1") * sum(*, delta(isdnSigStatsOutConnected.
Chapter 7: Collection Formulas PSTN Gateway Total Number of Unsuccessful Calls (Nb) Type Generic Description The total number of unsuccessful calls for a PSTN gateway device. Alias For PSTN Gateway Total Call Signaling Errors (Nb) PSTN Gateway Total Number Calls Rejected (Nb) Formula Editor Path AP > Generic > VOIP > Cisco > PSTN Gateway 398 Netcool/Proviso Cisco IP Telephony Technology Pack User’s Guide, Version 4.
Chapter 7: Collection Formulas PSTN Gateway Total Packets per Second Type SNMP (collection) Description The total number of packets per second for a PSTN Gateway. Syntax (delta(ipForwDatagrams.0) + delta(ipOutRequests.0) + delta(ipInReceives.0))/(delta(sysUpTime.0)/100) Generic Database Alias None. Formula Editor Path AP > Specific > SNMP > VOIP > Cisco > PSTN Gateway > Device MIB rfc1213-MIB-II Netcool/Proviso Cisco IP Telephony Technology Pack User’s Guide, Version 4.
Chapter 7: Collection Formulas SCS Type Import Description Severely concealed seconds. Concealment lasting longer than fifty milliseconds or five percent of the voice traffic. Syntax #Bulk Metric Generic Database Alias None. Formula Editor Path AP > Specific > Bulk > VOIP > Cisco > CMR 400 Netcool/Proviso Cisco IP Telephony Technology Pack User’s Guide, Version 4.
Chapter 7: Collection Formulas ShortCall Type Import Description Identifies a call successfully established, but with a call duration of less than one second. In this case, the CallManager set the CallDuration value to 0 in the CDR table. A short call is also: • A successful call • Any inbound, outbound, or other type of call described in this chapter Syntax #Bulk Metric Generic Database Alias None.
Chapter 7: Collection Formulas SIPCallsActive Type Import Description Total number of currently active SIP calls for the resource or resources specified. Syntax #Bulk Metric Generic Database Alias None. Formula Editor Path AP > Specific > Bulk > VOIP > Cisco > Perfmon 402 Netcool/Proviso Cisco IP Telephony Technology Pack User’s Guide, Version 4.
Chapter 7: Collection Formulas SIPCallsInProgress Type Import Description Total number of SIP calls being established at the time of sampling. Syntax #Bulk Metric Generic Database Alias None. Formula Editor Path AP > Specific > Bulk > VOIP > Cisco > Perfmon Netcool/Proviso Cisco IP Telephony Technology Pack User’s Guide, Version 4.
Chapter 7: Collection Formulas SNMP Availability (percent) (avg last hour) Type SNMP (collection) Description The average of SNMP availability percentages over the last hour, for CallManager devices. Syntax Stat( "Targets" , %H1 , "SNMP Availability (%) [last hour]" ) Generic Database Alias None. Formula Editor Path AP > Specific > SNMP > VOIP > Cisco > CCM Server > Device 404 Netcool/Proviso Cisco IP Telephony Technology Pack User’s Guide, Version 4.
Chapter 7: Collection Formulas SNMP Availability (percent) (avg last hour) Type SNMP (collection) Description The average of SNMP availability percentages over the last hour, for PSTN Gateway devices. Syntax Stat( "Targets" , %H1 , "SNMP Availability (%) [last hour]" ) Generic Database Alias None. Formula Editor Path AP > Specific > SNMP > VOIP > Cisco > PSTN Gateway > Device Netcool/Proviso Cisco IP Telephony Technology Pack User’s Guide, Version 4.
Chapter 7: Collection Formulas SNMP Availability (percent) (avg last hour) Type SNMP (collection) Description The average of SNMP availability percentages over the last hour, for Cisco Gatekeeper devices. Syntax Stat( "Targets" , %H1 , "SNMP Availability (%) [last hour]" ) Generic Database Alias None. Formula Editor Path AP > Specific > SNMP > VOIP > Cisco > Gatekeeper > Device 406 Netcool/Proviso Cisco IP Telephony Technology Pack User’s Guide, Version 4.
Chapter 7: Collection Formulas SNMP Availability (percent) (avg last hour) Type SNMP (collection) Description Netcool/Proviso performance Metric. Works with PVL 1.2 or better. Syntax Stat( "Targets" , %H1 , "SNMP Availability (%) [last hour]" ) Generic Database Alias None. Formula Editor Path AP > PROVISO > Targets Netcool/Proviso Cisco IP Telephony Technology Pack User’s Guide, Version 4.
Chapter 7: Collection Formulas SNMP Response Time (ms) (avg last hour) Type SNMP (collection) Description The average of SNMP packet response times, in milliseconds, over the last hour, for CallManager Server devices. Syntax Stat( "Targets" , %H1 , "Average SNMP Response Time (ms) [last hour]" ) Generic Database Alias None. Formula Editor Path AP > Specific > SNMP > VOIP > Cisco > CCM Server > Device 408 Netcool/Proviso Cisco IP Telephony Technology Pack User’s Guide, Version 4.
Chapter 7: Collection Formulas SNMP Response Time (ms) (avg last hour) Type SNMP (collection) Description The average of SNMP packet response times, in milliseconds, over the last hour, for PSTN Gateway devices. Syntax Stat( "Targets" , %H1 , "Average SNMP Response Time (ms) [last hour]" ) Generic Database Alias None. Formula Editor Path AP > Specific > SNMP > VOIP > Cisco > PSTN Gateway > Device Netcool/Proviso Cisco IP Telephony Technology Pack User’s Guide, Version 4.
Chapter 7: Collection Formulas SNMP Response Time (ms) (avg last hour) Type SNMP (collection) Description Netcool/Proviso performance metric. Works with PVL 1.2 or better. Syntax Stat( "Targets" , %H1 , "Average SNMP Response Time (ms) [last hour]" ) Generic Database Alias None. Formula Editor Path AP > PROVISO > Targets 410 Netcool/Proviso Cisco IP Telephony Technology Pack User’s Guide, Version 4.
Chapter 7: Collection Formulas SNMP Unavailable (percent) (avg last hour) Type CME Description The average of SNMP unavailability percentages over the last hour. Syntax ^(100 - avail) Formula Input Input: avail Source: SNMP Availability (percent) (avg last hour) (Formula) Generic Database Alias None. Formula Editor Path AP > PROVISO > Targets Netcool/Proviso Cisco IP Telephony Technology Pack User’s Guide, Version 4.
Chapter 7: Collection Formulas SuccessfulCall Type Import Description Identifies a call successfully established. Once the call is established, the communication starts between the two parties. A successful call can be inbound, outbound, or any other type of call described in this chapter. Syntax #Bulk Metric Generic Database Alias None. Formula Editor Path AP > Specific > Bulk > VOIP > Cisco > CDR 412 Netcool/Proviso Cisco IP Telephony Technology Pack User’s Guide, Version 4.
Chapter 7: Collection Formulas T1ChannelsActive Type Import Description Total number of T1 channels currently in use in the target device. Syntax #Bulk Metric Generic Database Alias None. Formula Editor Path AP > Specific > Bulk > VOIP > Cisco > Perfmon Netcool/Proviso Cisco IP Telephony Technology Pack User’s Guide, Version 4.
Chapter 7: Collection Formulas T1SpansInService Type Import Description Total number of T1 spans available in the target device. Syntax #Bulk Metric Generic Database Alias None. Formula Editor Path AP > Specific > Bulk > VOIP > Cisco > Perfmon 414 Netcool/Proviso Cisco IP Telephony Technology Pack User’s Guide, Version 4.
Chapter 7: Collection Formulas TollbypassCallDuration Type Import Description The duration of a toll bypass call, in seconds. Syntax #Bulk Metric Generic Database Alias None. Formula Editor Path AP > Specific > Bulk > VOIP > Cisco > CDR Netcool/Proviso Cisco IP Telephony Technology Pack User’s Guide, Version 4.
Chapter 7: Collection Formulas TollBypassCall Type Import Description Identifies a call where the caller is an internal extension managed by the CallManager, and where the callee can be an internal extension or any external PSTN number, with one or more of the following criteria: • Outbound call • Off-net call • The call is going through a PSTN Gateway, and the caller site and PSTN Gateway site are different An intersite legacy PBX call can be also a toll bypass call if the PSTN Gateway site is diff
Chapter 7: Collection Formulas Total Number of Calls (Nb) CME(Bulk) VOIP Cisco Type CME Description The total number of calls for all callers and callees. Syntax ^(isCaller + isCallee) Formula Input Input: isCallee Source: isCallee (Formula) Input: isCaller Source: isCaller (Formula) Generic Database Alias None. Formula Editor Path AP > Specific > CME > VOIP > Cisco Netcool/Proviso Cisco IP Telephony Technology Pack User’s Guide, Version 4.
Chapter 7: Collection Formulas Total Number of Outgoing External Calls (Nb) Type CME Description The total number of outbound calls going to the PSTN. An outgoing external call can be any of these call types: • Local • Long distance • International This metric is a subset of the Cluster Total Number of External Calls (Nb).
Chapter 7: Collection Formulas Total Number of VoiceMail Direct Calls (Nb) CME(Bulk) VOIP Cisco Type CME Description The total number of voicemail calls that are direct calls to voicemail (that is, users calling voicemail directly rather than being forwarded). This metric is the opposite of ForwardToVoiceMai.
Chapter 7: Collection Formulas UnsuccessfulCall Type Import Description Identifies a call that has not been successfully established. In this case, the call setup has been rejected, and the communication between the two parties never started. An unsuccessful call can be inbound, outbound, or any other type of call described in this chapter. Syntax #Bulk Metric Generic Database Alias None.
Chapter 7: Collection Formulas VoicemailCallDuration Type Import Description Duration of a call with the voicemail application, in seconds. Syntax #Bulk Metric Generic Database Alias None. Formula Editor Path AP > Specific > Bulk > VOIP > Cisco > CDR Netcool/Proviso Cisco IP Telephony Technology Pack User’s Guide, Version 4.
Chapter 7: Collection Formulas VoiceMailCall Type Import Description Identifies a call where the final destination (callee) is voicemail. The voicemail application is managed through a specific range of extensions numbers, defined site by site, using the global variable VoiceMailExtensionRange. Syntax #Bulk Metric Generic Database Alias None. Formula Editor Path AP > Specific > Bulk > VOIP > Cisco > CDR 422 Netcool/Proviso Cisco IP Telephony Technology Pack User’s Guide, Version 4.
Chapter 7: Collection Formulas VoicemailPackets Type Import Description Number of packets that the sub-element sent and received during a voicemail call. This metric comes from the CMR table. It is set once the call is established with one of the voicemail extensions. Syntax #Bulk Metric Generic Database Alias None. Formula Editor Path AP > Specific > Bulk > VOIP > Cisco > CDR Netcool/Proviso Cisco IP Telephony Technology Pack User’s Guide, Version 4.
Chapter 7: Collection Formulas NOTES 424 Netcool/Proviso Cisco IP Telephony Technology Pack User’s Guide, Version 4.
Chapter 8: Discovery Formulas This chapter discusses the following topics: Topic Page Overview 425 Netcool/Proviso Discovery Formula Tree 425 Discovery Formula Structure 426 Overview A discovery formula (also called an inventory formula) allows Netcool/Proviso to recognize resources specific to the target devices and technologies supported in the Cisco IP Telephony environment so that information can then be collected on those resources.
Chapter 8: Discovery Formulas Discovery Formula Structure A discovery formula typically has three sections: • Instance variable declaration. Instance variables represent the input values for a formula. The following line is an example of an instance variable declaration: Dim I1 AS Integer Default * NAME RTTMonIndex; • Temporary variable definition. Temporary variables hold the result of an SNMP query. These variables can then be used as parameters in subsequent queries.
Chapter 8: Discovery Formulas CCM_Gateway_Device Type SNMP (discovery) Description Sub-element discovery for CallManager gateways through the CCM MIB. This allows the retrieval of gateway registration status with the CallManager during collection. Syntax Dim I1 AS Integer Default * NAME Gateway; V1 = OIDVAL(ccmGatewayInetAddress.%I1 format clean, once); V2=OIDVAL(ccmClusterId.1); V3=OIDVAL(ccmGatewayType.%I1); V4 = OIDINST( not (ccmGatewayDescription.%I1 like "")); V5 = OIDVAL(ccmGatewayDescription.
Chapter 8: Discovery Formulas CCM_Media_Device Type SNMP (discovery) Description CallManager media device discovery. Syntax Dim I1 AS Integer Default * NAME Media; V1 = OIDVAL(ccmMediaDeviceName.%I1); V2=OIDVAL(ccmClusterId.1); V3=OIDVAL(ccmMediaDeviceType.%I1); V4=OIDVAL(ccmMediaDeviceDescription.%I1); V5=OIDVAL(ccmMediaDeviceInetAddress.
Chapter 8: Discovery Formulas CCM_Server_Device Type SNMP (discovery) Description CallManager Server device discovery. Syntax V1 = OIDVAL(ccmClusterId.1); V2 = OIDVAL(cdpGlobalDeviceId.0); V3 = OIDVAL(ccmDescription.1); V4 = OIDVAL(ccmVersion.
Chapter 8: Discovery Formulas CCM_Server_FileSystem Type SNMP (discovery) Description CallManager Server file system discovery. Syntax Dim I1 AS Integer Default * NAME FileSys; V1 = OIDINST((hrStorageIndex.%I1) != 1, once); V2 = OIDVAL(hrStorageDescr.%V1); V3=OIDVAL(ccmClusterId.1); V4=OIDVAL(sysName.
Chapter 8: Discovery Formulas CCM_Server_Interface Type SNMP (discovery) Description CallManager Server interface discovery. Syntax Dim I1 AS Integer Default * NAME If; V009 = OIDINST(ifAdminStatus.%I1 == 1); V002=OIDVAL(ccmClusterId.1); V001 = OIDVAL(ifType.%V009 format clean, once); %V001 index "If<%V009>||UNSPECIFIED||VoIPCallMgrClusterId<%V002>VoIPCallMgrCustomerId<%V002>||"; Formula Editor Path Alias Instance and Label Inventory > AP > VOIP > Cisco MIB rfc1213-MIB-II CISCO-CCM-MIB.
Chapter 8: Discovery Formulas CCM_Server_Process Type SNMP (discovery) Description CallManager Server process discovery. Syntax Dim I1 AS Integer Default * NAME Process; V1 = OIDINST( not (hrSWRunName.%I1 like "java.exe") && not(hrSWRunName.%I1 like "services.exe") && not(hrSWRunName.%I1 like "csrss.exe") && not(hrSWRunName.%I1 like "WINLOGON.EXE") && not(hrSWRunName.%I1 like "svchost.exe") && not(hrSWRunName.%I1 like "dllhost.exe")); V2 = OIDVAL(hrSWRunName.%V1, once); V3=OIDVAL(ccmClusterId.
Chapter 8: Discovery Formulas CCM_Server_SqlDatabase Type SNMP (discovery) Description CallManager Server SQL database discovery. Syntax Dim I1 AS Integer Default * NAME SqlDb; V1 = OIDVAL(mssqlDbInfoDbName.%I1 format clean, once); V2=OIDVAL(ccmClusterId.1); V3=OIDVAL(sysName.0); %V1 index "SqlDb<%I1>||SqlDatabase: %V1||VoIPCallMgrSqlDbName<%V1>VoIPCallMgrClusterId<%V2>||%V3_%V1||"; Formula Editor Path Alias Instance and Label Inventory > AP > VOIP > Cisco MIB rfc1213-MIB-II CISCO-CCM-MIB.my MSSQL-MIB.
Chapter 8: Discovery Formulas Gatekeeper_Device Type SNMP (discovery) Description Gatekeeper device discovery. Syntax V1=OIDVAL(cgkStatsAdmissionRequests.0); %V1 index "||-UNSPECIFIED||VoIPDeviceType||"; Formula Editor Path Alias Instance and Label Inventory > AP > VOIP > Cisco MIB rfc1213-MIB-II CISCO-GATEKEEPER-MIB.my 434 Netcool/Proviso Cisco IP Telephony Technology Pack User’s Guide, Version 4.
Chapter 8: Discovery Formulas PSTN_Gateway_Device Type SNMP (discovery) Description PSTN Gateway device discovery. Syntax Dim I1 AS Integer Default * NAME If; Dim I2 AS Integer Default * NAME Dev; V002 = OIDVAL(sysLocation.0,once); V003 = OIDINST((cdpCachePlatform.%I1.%I2)== "cisco Cat6k-MSFC", once); V004 = OIDVAL(cdpCacheDeviceId.%V003); #Catalyst 6500 with MSFC WAN module; V011 = OIDVAL(sysObjectID.0); V012 = OIDVAL(filter(%V011 like "1.3.6.1.4.1.9.1.
Chapter 8: Discovery Formulas rfc1213-MIB-II CISCO-CDP-MIB.my 436 Netcool/Proviso Cisco IP Telephony Technology Pack User’s Guide, Version 4.
Chapter 8: Discovery Formulas PSTN_Gateway_DSP_Card Type SNMP (discovery) Description PSTN Gateway DSP card discovery. Syntax Dim I1 AS Integer Default * NAME DSPCard; V1 = OIDVAL(cdspCardIndex.%I1); V2 = OIDVAL(cdspCardMaxChanPerDSP.%I1); V3 = OIDVAL(sysLocation.0, once); V4 = OIDVAL(sysName.
Chapter 8: Discovery Formulas NOTES 438 Netcool/Proviso Cisco IP Telephony Technology Pack User’s Guide, Version 4.
Appendix A: Configuration This appendix explains how to configure the Cisco IP Telephony Technology Pack and consists of the following topics: Topic Page Overview 439 Before You Begin 439 Configure the Technology Pack 440 Other Tasks and Considerations 455 Overview Netcool/Proviso supports the following two types of technology packs, based on the type of data that they collect: • SNMP These packs are MIB-based, and their configuration is relatively straightforward.
Appendix A: Configuration Important: You will need to refer to this guide in order to run a Bulk inventory profile. — Access to the Netcool/Proviso DataMart server. — An X Window server on the DataMart server. Note: (Pre-443 Netcool/Proviso) If there is no graphics card on the DataMart server, you can install the Xvfb virtual frame buffer package to provide X Window services, as described in the Netcool/Proviso Installation Guide. — Access to the SilverStream server. — Access to the DataChannel server.
Appendix A: Configuration 2. Copy technology-specific files from the DataMart server to the DataChannel server. Technology-specific files are used to associate a UBA technology pack with a specific instance of the UBA. Note: While it is possible to install DataMart and DataChannel on the same server, in a typical installation these modules are installed on separate servers. If this is the case, use ftp to copy the technology-specific files.
Appendix A: Configuration 3-c. Click the Configuration tab, then click Request Editor to open the Request Editor. 3-d. Click the Collection tab. 3-e. Click Refresh. The predefined data collection requests are loaded into the Request Editor from the database. 3-f. Click the Inactive button in the Filter group box to display only idle requests. 3-g. In the Sub-Element Groups pane, select all idle data collection requests in the following group or groups: Root->Sub-Element Collect->Cisco 3-h.
Appendix A: Configuration The technology pack’s UBA is responsible for retrieving CCM data, using the Data Direct SQL server bridge to do so. This bridge is part of the UBA installation. No additional software is required. You need to set up the Data Direct SQL server bridge to get Call Detail Records from each CallManager Publisher. The complete configuration is done by editing the $DC_HOME/conf/odbc.ini file as user pvuser. [ODBC Data Sources] Your_Data_Source1=DataDirect 4.
Appendix A: Configuration Field Description [Data Source Name] The configuration of the specified data source. [ODBC] • [Data Source Name]: for example, [SANFRANCISCO] • Address: the remote IP address and TCP port of the CallManager Publisher Database (for example, 192.168.1.1,1433). To verify the remote connection configuration, establish the connection manually from a shell window: telnet xx.xx.xx.xx 1433 or telnet xx.xx.xx.xx 1370.
Appendix A: Configuration Field Description cucm.user User ID required for login to the CUCM. Example: cucm.user=cucmuser cucm.pass User password required for login to the CUCM. Example: cucm.pass=cucmpwd ftp.user User ID required for login to the DataChannel host that issued the SOAP request. Example: ftp.user=provisouser ftp.pass User password required for login to the DataChannel host that issued the SOAP request. Example: ftp.pass=provisopwd ftp.
Appendix A: Configuration Field Description resend_sent_files If true, the CUCM server will re-send files that it has already successfully sent. Since the CUCM can be configured to send data files to any host specified by CUCM Web administration configuration settings, this field must be set to true to ensure that data files are also sent to the DataChannel host that requested them.
Appendix A: Configuration Field Description debug If true, enables debug mode for ProvisoCUCM operations. Error information pertaining to the SOAP interaction with the CUCM server is written to a log file. The log file resides in the same directory as the ProvisoCUCM.jar and cucm.properties files. If false, debug mode is not enabled. Example: debug=true Note: Before proceeding to the next step, be sure you have configured each cucm.properties file in the directories you created in Step 6. 9.
Appendix A: Configuration Variable Description site A variable assigned to the JavaScript object Site. A Site object defines a set of properties specific for a site, business department, location, remote office, or group of people. You can define multiple Site objects. Objects are distinguished through the site name you pass to the object. Create a Site object as follows: site = new Site("MySite"); In the example, MySite is the site name.
Appendix A: Configuration An inventory collects data about the network resources that the technology pack monitors. After you install an SNMP technology pack, you must create an inventory profile using the Inventory Tool Wizard and then initiate a discovery by executing the inventory profile using the Inventory Tool. Running the initial inventory against SNMP objects is an intricate task and unfortunately beyond the scope of this configuration appendix.
Appendix A: Configuration To manually add the pack-specific UBA parameters to the dc.cfg file, follow these steps: 12-f. Open a second terminal emulator. 12-g. On the DataChannel server, change your working directory to the DATA_CHANNEL_HOME/conf directory (/opt/datachannel/conf, by default), by entering the following command: cd DATA_CHANNEL_HOME/conf 12-h. Make a backup copy of the dc.cfg file, by entering the following command: cp dc.cfg dc.cfg.ORIG 12-i. In a text editor, open the dc.
Appendix A: Configuration kill -9 kill -9 14-f. Use the following commands to restart each DataChannel visual process: cnsw logw amgrw cmgrw 14-g. Use the dccmd command to start all DataChannel applications: dccmd -action start all 14-h.
Appendix A: Configuration Event Meaning The UBA application connects to the database. This event causes a message similar to the following to display: DB_CONNECT Connecting to as If you see this database connection message without prior errors, the UBA application has passed the syntax check. 15. Ensure that the Bulk input files can be read. To verify that the UBA application can read the Bulk input files, follow these steps: 15-a. Place a Bulk input file at the source input location.
Appendix A: Configuration tail -f DATA_CHANNEL_HOME/log/proviso.log | grep UBA..- | more The following table identifies the success messages you should look for. Line breaks appear in the messages to make them more readable. Success Message Meaning PERF_INPUT_PROCESSING Processed records in seconds ( records/minute): records Specifies a Bulk Adaptor Design File completion message.
Appendix A: Configuration where: Syntax Item Meaning bulk_ Identifies this as a Bulk inventory profile for a UBA technology pack. N Specifies the collector number (for example, 100) the user specified when configuring this UBA Bulk Collector. You must use the Inventory Tool to run a Bulk inventory profile. To run this technology pack’s Bulk inventory profile, perform the following steps: 16-a.
Appendix A: Configuration 17-g. (Optional) You can also deploy reports on a regular basis by creating a cron entry that makes use of the inventory CLI command and the -reportGrouping option. This option instructs the inventory command to run the report grouping rules and update the deployed reports stored in the database. Report grouping rules must first have been created before this option can be used. For information on creating report grouping rules, see the Netcool/Proviso DataMart Configuration Guide.
Appendix A: Configuration 456 Netcool/Proviso Cisco IP Telephony Technology Pack User’s Guide, Version 4.
Appendix B: UBA Parameters Reference (443, Topology Editor) This appendix provides Unix reference pages for each of the pack-specific UBA parameters supplied with the XSD file for the Cisco IP Telephony Technology Pack. The descriptions are the same as those that display in the Topology Editor Help. These reference pages are provided as a convenience. UBA Parameters Reference The following pages provide a reference of the UBA parameters that this technology pack provides.
Appendix B: UBA Parameters Reference (443, Topology Editor) • 458 Detail. Provides details about the parameter, including possible values. Netcool/Proviso Cisco IP Telephony Technology Pack User’s Guide, Version 4.
Appendix B: UBA Parameters Reference (443, Topology Editor) INSTANCES Description Group alias. Component UBA Value Default: VOIP_CISCO_IPT_PERFMON Attribute: Read-only Location: Advanced Properties tab Detail The DataChannel supports multiple instances of technology packs running in a single channel component. Therefore, there must be a way to guarantee that the DataChannel applications that handle inventory and metrics parse the correct design files and read the appropriate Bulk input files.
Appendix B: UBA Parameters Reference (443, Topology Editor) INSTANCES Description Group alias. Component UBA Value Default: VOIP_CISCO_IPT Attribute: Read-only Location: Advanced Properties tab Detail The DataChannel supports multiple instances of technology packs running in a single channel component. Therefore, there must be a way to guarantee that the DataChannel applications that handle inventory and metrics parse the correct design files and read the appropriate Bulk input files.
Appendix B: UBA Parameters Reference (443, Topology Editor) INSTANCES Description Group alias. Component UBA Value Default: VOIP_CISCO_IPT Attribute: Read-only Location: Advanced Properties tab Detail The DataChannel supports multiple instances of technology packs running in a single channel component. Therefore, there must be a way to guarantee that the DataChannel applications that handle inventory and metrics parse the correct design files and read the appropriate Bulk input files.
Appendix B: UBA Parameters Reference (443, Topology Editor) VOIP_CISCO_IPT.CCMINPUT.DELETEONACQUIRE Description Deletes CCM Bulk input files after acquisition. Component UBA Value Default: false Attribute: Writable Location: Advanced Properties tab Detail The CCMINPUT.DELETEONACQUIRE parameter specifies whether the Bulk input files should be preserved after the UBA acquires them. A related parameter - CCMINPUT.URI - specifies the location of the Bulk input files.
Appendix B: UBA Parameters Reference (443, Topology Editor) VOIP_CISCO_IPT.CCMINPUT.URI Description CCM Bulk input files location. Component UBA Value Default: No default value Attribute: Read-only Location: Properties tab Detail The DataChannel applications that handle inventory and metrics must be directed to the location of the Bulk input files generated by the devices associated with the technology on which the application operates. The CCMINPUT.
Appendix B: UBA Parameters Reference (443, Topology Editor) VOIP_CISCO_IPT.CDRINPUT.DELETEONACQUIRE Description Deletes CUCM Bulk input files after acquisition. Component UBA Value Default: false Attribute: Writable Location: Advanced Properties tab Detail The CDRINPUT.DELETEONACQUIRE parameter specifies whether the Bulk input files should be preserved after the UBA acquires them. A related parameter - CDRINPUT.URI - specifies the location of these Bulk input files.
Appendix B: UBA Parameters Reference (443, Topology Editor) VOIP_CISCO_IPT.CDRINPUT.URI Description CUCM Bulk input files location. Component UBA Value Default: No default value Attribute: Read-only Location: Properties tab Detail The DataChannel applications that handle inventory and metrics must be directed to the location of the Bulk input files generated by the devices associated with the technology on which the application operates. The CDRINPUT.
Appendix B: UBA Parameters Reference (443, Topology Editor) VOIP_CISCO_IPT.DESIGNFILE Description JavaScript file that controls UBA for CCM or CUCM metrics. Component UBA Value Default: CUCMAdaptor.js Attribute: Read-only Location: Properties tab Detail Netcool/Proviso technology packs control the behavior of the DataChannel UBA application through instructions contained in Bulk Adaptor design (JavaScript) files. The DESIGNFILE parameter identifies the name of a technology pack’s design file.
Appendix B: UBA Parameters Reference (443, Topology Editor) VOIP_CISCO_IPT.DESIGNFILE Description JavaScript file that controls UBA for CCM or CUCM metrics. Component UBA Value Default: CCMAdaptor.js Attribute: Read-only Location: Properties tab Detail Netcool/Proviso technology packs control the behavior of the DataChannel UBA application through instructions contained in Bulk Adaptor design (JavaScript) files. The DESIGNFILE parameter identifies the name of a technology pack’s design file.
Appendix B: UBA Parameters Reference (443, Topology Editor) VOIP_CISCO_IPT.INPUT_DIRECTORY Description Path to Bulk input files directory for CCM or CUCM metrics. Component UBA Value Default: sqldb:odbc*threaded/username=user&password=passwd&environment=EXAMPLE Attribute: Writable Location: Properties tab Detail The INPUT_DIRECTORY parameter specifies the path to the directory where the generated Bulk input files should be stored.
Appendix B: UBA Parameters Reference (443, Topology Editor) VOIP_CISCO_IPT.INPUT_DIRECTORY Description Path to Bulk input files directory for CCM or CUCM metrics. Component UBA Value Default: No default value Attribute: Writable Location: Properties tab Detail The INPUT_DIRECTORY parameter specifies the path to the directory where the generated Bulk input files should be stored. Do not enter any subdirectories and the actual wildcards used to specify the Bulk input files to be acquired.
Appendix B: UBA Parameters Reference (443, Topology Editor) VOIP_CISCO_IPT.INPUT_FTP_PASSWORD Description FTP or SFTP password for Bulk input files used in CCM or CUCM environments. Component UBA Value Default: No default value Attribute: Writable Location: Properties tab Detail The INPUT_FTP_PASSWORD parameter specifies the password that the server administrator assigned (using the ftp or sftp utility) to the FTP or SFTP user.
Appendix B: UBA Parameters Reference (443, Topology Editor) VOIP_CISCO_IPT.INPUT_FTP_USERNAME Description FTP or SFTP username for Bulk input files used in CCM or CUCM environments. Component UBA Value Default: No default value Attribute: Writable Location: Properties tab Detail The INPUT_FTP_USERNAME parameter specifies the username that the server administrator assigned (using the ftp or sftp utility) to the FTP or SFTP user.
Appendix B: UBA Parameters Reference (443, Topology Editor) VOIP_CISCO_IPT.INPUT_HOST Description Hostname for Bulk input files in CCM or CUCM environments. Component UBA Value Default: No default value Attribute: Writable Location: Properties tab Detail The INPUT_HOST parameter specifies the hostname of the server on which the Bulk input files reside. These are the files that the UBA parses. 472 Netcool/Proviso Cisco IP Telephony Technology Pack User’s Guide, Version 4.
Appendix B: UBA Parameters Reference (443, Topology Editor) VOIP_CISCO_IPT.INPUT_HOST Description Hostname for Bulk input files in CCM or CUCM environments. Component UBA Value Default: No default value Attribute: Writable Location: Properties tab Detail The INPUT_HOST parameter specifies the hostname of the server on which the Bulk input files reside. These are the files that the UBA parses. Netcool/Proviso Cisco IP Telephony Technology Pack User’s Guide, Version 4.
Appendix B: UBA Parameters Reference (443, Topology Editor) VOIP_CISCO_IPT.INPUT_USE_SECURE_FTP Description Acquire CCM or CUCM Bulk input files using secure FTP. Component UBA Value Default: false Attribute: Writable Location: Properties tab Detail The INPUT_USE_SECURE_FTP parameter specifies whether FTP (File Transfer Protocol) or SFTP (secure FTP) is used. To use FTP, specify the value false. Otherwise, to use SFTP, specify the value true. The default value is false.
Appendix B: UBA Parameters Reference (443, Topology Editor) VOIP_CISCO_IPT.INPUT_USE_SECURE_FTP Description Acquire CCM or CUCM Bulk input files using secure FTP. Component UBA Value Default: false Attribute: Writable Location: Properties tab Detail The INPUT_USE_SECURE_FTP parameter specifies whether FTP (File Transfer Protocol) or SFTP (secure FTP) is used. To use FTP, specify the value false. Otherwise, to use SFTP, specify the value true. The default value is false.
Appendix B: UBA Parameters Reference (443, Topology Editor) VOIP_CISCO_IPT_PERFMON.DESIGNFILE Description JavaScript file that controls UBA for CUCM Perfmon metrics. Component UBA Value Default: CUCMPerfmonAdaptor.js Attribute: Read-only Location: Properties tab Detail Netcool/Proviso technology packs control the behavior of the DataChannel UBA application through instructions contained in Bulk Adaptor design (JavaScript) files.
Appendix B: UBA Parameters Reference (443, Topology Editor) VOIP_CISCO_IPT_PERFMON.INPUT_DIRECTORY Description Path to Bulk input files directory for CUCM Perfmon metrics. Component UBA Value Default: No default value Attribute: Writable Location: Properties tab Detail The INPUT_DIRECTORY parameter specifies the path to the directory where the generated Bulk input files should be stored. Do not enter any subdirectories and the actual wildcards used to specify the Bulk input files to be acquired.
Appendix B: UBA Parameters Reference (443, Topology Editor) VOIP_CISCO_IPT_PERFMON.INPUT_FTP_PASSWORD Description FTP or SFTP password for Bulk input files used for collecting Perfmon metrics in CUCM environments. Component UBA Value Default: No default value Attribute: Writable Location: Properties tab Detail The INPUT_FTP_PASSWORD parameter specifies the password that the server administrator assigned (using the ftp or sftp utility) to the FTP or SFTP user.
Appendix B: UBA Parameters Reference (443, Topology Editor) VOIP_CISCO_IPT_PERFMON.INPUT_FTP_USERNAME Description FTP or SFTP username for Bulk input files used for collecting Perfmon metrics in CUCM environments. Component UBA Value Default: No default value Attribute: Writable Location: Properties tab Detail The INPUT_FTP_USERNAME parameter specifies the username that the server administrator assigned (using the ftp or sftp utility) to the FTP or SFTP user.
Appendix B: UBA Parameters Reference (443, Topology Editor) VOIP_CISCO_IPT_PERFMON.INPUT_HOST Description Hostname for Bulk input files containing Perfmon metrics in CUCM environments. Component UBA Value Default: No default value Attribute: Writable Location: Properties tab Detail The INPUT_HOST parameter specifies the hostname of the server on which the Bulk input files reside. These are the files that the UBA parses.
Appendix B: UBA Parameters Reference (443, Topology Editor) VOIP_CISCO_IPT_PERFMON.INPUT_USE_SECURE_FTP Description Acquire CUCM Perfmon Bulk input files using secure FTP. Component UBA Value Default: false Attribute: Writable Location: Properties tab Detail The INPUT_USE_SECURE_FTP parameter specifies whether FTP (File Transfer Protocol) or SFTP (secure FTP) is used. To use FTP, specify the value false. Otherwise, to use SFTP, specify the value true. The default value is false.
Appendix B: UBA Parameters Reference (443, Topology Editor) VOIP_CISCO_IPT_PERFMON.PERFMON.DELETEONACQUIRE Description Deletes CUCM Perfmon Bulk input files after acquisition. Component UBA Value Default: false Attribute: Writable Location: Advanced Properties tab Detail The PERFMON.DELETEONACQUIRE parameter specifies whether the Bulk input files should be preserved after the UBA acquires them. A related parameter - PERFMON.URI - specifies the location of these Bulk input files.
Appendix B: UBA Parameters Reference (443, Topology Editor) VOIP_CISCO_IPT_PERFMON.PERFMON.URI Description CUCM Perfmon Bulk input files location. Component UBA Value Default: No default value Attribute: Read-only Location: Properties tab Detail The DataChannel applications that handle inventory and metrics must be directed to the location of the Bulk input files generated by the devices associated with the technology on which the application operates. The PERFMON.
Appendix B: UBA Parameters Reference (443, Topology Editor) 484 Netcool/Proviso Cisco IP Telephony Technology Pack User’s Guide, Version 4.
Appendix C: Template File Reference You should be reading this appendix after you have opened the voip_cisco_ipt_sample_dc.cfg template file for editing, as instructed to do so in Appendix A, Configuration. Note: The cross reference link to Appendix A, Configuration does not work due to a formatting limitation. This appendix provides a Unix reference page that identifies the pack-specific UBA parameters you need to add to the dc.cfg file and explains how to tailor the values to your specific deployment.
Appendix C: Template File Reference Pack-Specific UBA Parameter Values UBA Parameter Value Meaning Replace with the channel number that was configured for this technology pack. This channel number appears in the dc.cfg file. Replace with the UBA Bulk Collector number that was configured for this technology pack. This collector number appears in the dc.cfg file.
Appendix C: Template File Reference Notes Use the following guidelines to determine if you have the correct value for the UBA...DB_USERNAME parameter in the dc.cfg file: • The UBA technology pack requires the DataChannel UBA application to process metrics only. In this scenario, the UBA technology pack provides a metrics schema in its design file. In this case, DB_USERNAME must be set to PV_COLL.
Appendix C: Template File Reference 488 Netcool/Proviso Cisco IP Telephony Technology Pack User’s Guide, Version 4.
Additional Copyright Information The following copyright information is for software used by Netcool/Proviso. Tcl 8.3.3, Combat/TCL 0.7.3, Combat/TCL 0.7.5, TclX 8.3, TK 8.3.3 This software is copyrighted by the Regents of the University of California, Sun Microsystems, Inc., Scriptics Corporation, and other parties. The following terms apply to all files associated with the software unless explicitly disclaimed in individual files.
Additional Copyright information AND NON-INFRINGEMENT. THIS SOFTWARE IS PROVIDED ON AN “AS IS” BASIS, AND THE AUTHORS AND DISTRIBUTORS HAVE NO OBLIGATION TO PROVIDE MAINTENANCE, SUPPORT, UPDATES, ENHANCEMENTS, OR MODIFICATIONS. Various copyrights apply to this package, listed in 3 separate parts below. Please make sure that you include all the parts. Up until 2001, the project was based at UC Davis, and the first part covers all code written during this time.
Additional Copyright information • Redistributions in binary form must reproduce the above copyright notice, this list of conditions and the following disclaimer in the documentation and/or other materials provided with the distribution. • The name of Cambridge Broadband Ltd. may not be used to endorse or promote products derived from this software without specific prior written permission.
Additional Copyright information This software is copyrighted by the Regents of the University of California, Sun Microsystems, Inc., and other parties. The following terms apply to all files associated with the software unless explicitly disclaimed in individual files.
Additional Copyright information 3. Neither the names of Networks Associates Technology, Inc, Cambridge Broadband Ltd., Sparta, Inc., Cisco, Inc, Beijing University of Posts and Telecommunications, Fabasoft R&D Software GmbH & Co KG or any of its subsidiaries, brand or product names, nor the names of their contributors may be used to endorse or promote products derived from this software without specific prior written permission.
Additional Copyright information for loss of data, loss of profit, or any other damage resulting directly or indirectly from the use of the software, even if the damage is caused by defects in the software. 3. You may use this software in any applications you build. 4. You may distribute this software provided that the software documentation and copyright notices are included and intact. 5.