Telecom discrepancy identification and reconciliation
Summarize
Summary of Telecom discrepancy identification and reconciliation
The Telecom Discrepancy Identification & Reconciliation functionality is enabled by the TSOM Visibility plugin (sntsomcore) and supports maintaining the accuracy of telecom-related Configuration Items (CIs) in the CMDB. It provides auditing capabilities that identify inconsistencies in telecom data discovered by Nokia Altiplano or NSP, focusing on relationships and logical connections within telecom assets.
Show less
Key Features
- System Properties: These configurable properties control the behavior of the Telecom Discrepancy Identification & Reconciliation audit logs and specify which CI tables and relationship types are included in the audits. For example, you can adjust logging levels, define thresholds for discovery date differences, and specify equipment, interface, slot, and subslot tables that the audit considers.
- Telecom Discrepancy Audit: Examines relationships in the
cmdbrelcitable, validating parent and child CIs based on recent discovery dates, CI models, and their relationships (with TNI Core installed). It uses a filter targeting equipment CIs discovered through TSOM sources. - Telecom Logical Connections Discrepancy Audit: Checks logical connections recorded in the
cmdbcinilogicalpathtable, ensuring endpoints are populated and uniquely connected. - Telecom Network Topology Discrepancy Audit: Validates network topology CIs in the
cmdbcinetworktopologytable, confirming proper "Contains:Contained By" and "Members:Member Of" relationships with equipment and logical connections.
Practical Use for ServiceNow Customers
By activating and running the Telecom Discrepancy Identification & Reconciliation audits, customers can ensure telecom-related CMDB data integrity, identify mismatches or missing relationships, and maintain accurate network topology and logical connection records. Adjusting system properties allows tailoring the audit scope and sensitivity to meet specific operational requirements. This helps reduce errors in telecom asset management and supports better decision-making based on reliable CMDB data.
The system properties are part of the TSOM Visibility plugin (sn_tsom_core) and control the Telecom Discrepancy Identification & Reconciliation log (TSOM CMDB Audit). The TSOM Visibility plugin serves as an enabler for the TSOM Visibility applications, containing logic that is shared across the Telecom Discovery and Telecom Discrepancy Identification & Reconciliation solution.
| Property Name | Recommended / Default Value | Description |
|---|---|---|
| sn_tsom_core.audit.log.level | Telecom Discrepancy Audits' Logging. | debug,info,warn Default value: info |
| sn_tsom_core.audit.relationship_types | Displayed Names of Relationship Types that will be handled by Telecom Discrepancy Audit. | Comma separated list of relationship types names Default value: Contains::Contained by |
| sn_tsom_core.audit.discovered_date.diff.threshold.in.days | Most recent discovered date threshold in days. Used for Telecom Discrepancy Audit. | String Default value: 2.5 |
| sn_tsom_core.audit.suppress_CI_Model_missing_discrepancy_task_creation | Suppress creation of CI Model missing discrepancy task for the tables.Used for Telecom Discrepancy Audit. | cmdb_ci_ni_telco_equipment, cmdb_ci_ip_switch, cmdb_ci_ip_router, cmdb_ci_container_slot,cmdb_ci_container_subslot,cmdb_ci_interface_card,cmdb_ci_ni_interface |
| sn_tsom_core.audit.equipment_tables | Equipment tables that will be handled by Telecom Discrepancy Audit. | Comma separated list of equipment tables names Default value: cmdb_ci_netgear |
| sn_tsom_core.audit.interface_card_tables | Interface Cards tables that will be handled by Telecom Discrepancy Audit. | Comma separated list of card tables names. Default value: cmdb_ci_interface_card |
| sn_tsom_core.audit.interface_tables | Network Interface tables that will be handled by Telecom Discrepancy Audit. | Comma separated list of interface tables names Default value: cmdb_ci_ni_interface |
| sn_tsom_core.audit.slot_tables | Slot tables names that will be handled by Telecom Discrepancy Audit. | Comma separated list of slot tables names Default value: cmdb_ci_container_slot |
| sn_tsom_core.audit.subslot_tables | Subslot tables names that will be handled by Telecom Discrepancy Audit. | Comma separated list of subslot tables names Default value is cmdb_ci_container_subslot |
| Audit Name | Description |
|---|---|
| Telecom Discrepancy Audit | Audits records in the cmdb_rel_ci table. For each relationship record discovered by Nokia Altiplano or NSP, it validates the parent and child CIs based on: - Most recent discovery date - CI model - CI model
relationship (if TNI Core is installed). Note: All discrepancy audits use a filtering mechanism that applies to equipment CIs. By default, the filter condition is: discovery_source CONTAINS TSOM. |
| Telecom Logical Connections Discrepancy Audit | Audits records in the cmdb_ci_ni_logical_path table. For each logical connection discovered by Nokia Altiplano or NSP, it checks: - Empty endpoint (Port A or Port Z) - Each endpoint must be connected to only
one unique logical connection. |
| Telecom Network Topology Discrepancy Audit | Audits records in the cmdb_ci_network_topology table. For each network topology CI discovered by Nokia Altiplano or NSP, it verifies: - At least one Contains:Contained By relationship with equipment - At least
one Members:Member Of relationship with a logical connection. |