User Tools
idmsapplications:ket_stats
Differences
This shows you the differences between two versions of the page.
| Both sides previous revisionPrevious revisionNext revision | Previous revision | ||
| idmsapplications:ket_stats [2021/12/13 17:16] – [Table Details] 10.91.120.28 | idmsapplications:ket_stats [2021/12/13 17:32] (current) – removed ywang | ||
|---|---|---|---|
| Line 1: | Line 1: | ||
| - | ====== Key Stats ====== | ||
| - | Updated by Yanjun Wang 14/12/2021 | ||
| - | |||
| - | |||
| - | ==== Overview ==== | ||
| - | |||
| - | The key_status is written with BASH& | ||
| - | |||
| - | The scripts need to be installed on each server/ | ||
| - | |||
| - | Due to each customer having a different DAS alarm workflow, form name etc. We have template all the scripts, and the script used to deploy can be generated based on configuration. | ||
| - | |||
| - | |||
| - | Generator Repo: https:// | ||
| - | |||
| - | ---- | ||
| - | |||
| - | ==== Scripts Generation and Installation ==== | ||
| - | |||
| - | The scripts for each customer(Currently, | ||
| - | * Imported the project in IntelliJ via Gradle and SpringBoot. | ||
| - | * Change **clientCode** in application.properties to either //EXT// or // | ||
| - | * Run SpringBoot application, | ||
| - | |||
| - | More details for the generator at: | ||
| - | |||
| - | Installation Playbook: | ||
| - | < | ||
| - | ansible-playbook -i ../ | ||
| - | </ | ||
| - | |||
| - | ---- | ||
| - | |||
| - | ==== Table Summary ==== | ||
| - | |||
| - | //Source: [[https:// | ||
| - | |||
| - | Database Name: **key_stats** | ||
| - | |||
| - | <WRAP group> | ||
| - | <WRAP half column> | ||
| - | ticket_summary | ||
| - | </ | ||
| - | |||
| - | <WRAP half column> | ||
| - | Every ticket created in the Ticketer will correspond to exactly one row in this table. This table contains counts of all the major forms linked to a ticket. It also contains basic details of alarms triggered by SNMP trap. | ||
| - | </ | ||
| - | </ | ||
| - | |||
| - | <WRAP group> | ||
| - | <WRAP half column> | ||
| - | daily_active_alarm_summary | ||
| - | </ | ||
| - | |||
| - | <WRAP half column> | ||
| - | This table shows on any given date what was the outage in seconds per network element. It does not consider alarms cleared within 5 minutes to avoid noise from report. | ||
| - | </ | ||
| - | </ | ||
| - | |||
| - | <WRAP group> | ||
| - | <WRAP half column> | ||
| - | device_outage_summary | ||
| - | </ | ||
| - | |||
| - | <WRAP half column> | ||
| - | This table further enriches data store in daily_active_alarm_summary. It brings service impacting alarms and aggregates outage time of all alarms generated for a NE on a given date. This table can help you find out outages between a desired date range. The important field to use ‘effective_date’ | ||
| - | </ | ||
| - | </ | ||
| - | |||
| - | <WRAP group> | ||
| - | <WRAP half column> | ||
| - | field_tech_site_visit | ||
| - | </ | ||
| - | |||
| - | <WRAP half column> | ||
| - | This table contains the Site Visit form added on tickets for Node elements. This is used for the Worst H/W by Site Visit Tableau Report. It contains data for the last 1 year only. | ||
| - | </ | ||
| - | </ | ||
| - | |||
| - | <WRAP group> | ||
| - | <WRAP half column> | ||
| - | network_element_summary | ||
| - | </ | ||
| - | |||
| - | <WRAP half column> | ||
| - | This table gives a simplified view of network element, controller and node/host information. | ||
| - | </ | ||
| - | </ | ||
| - | |||
| - | <WRAP group> | ||
| - | <WRAP half column> | ||
| - | ticket_basic_summary | ||
| - | </ | ||
| - | |||
| - | <WRAP half column> | ||
| - | This table contains basic information about tickets such as associated workflow and forms and when they were created. This table is used by State Transition diagram to provide form name-based filter. | ||
| - | </ | ||
| - | </ | ||
| - | |||
| - | <WRAP group> | ||
| - | <WRAP half column> | ||
| - | wf_extenet_das_alarm/ | ||
| - | </ | ||
| - | |||
| - | <WRAP half column> | ||
| - | This table contains information about the DAS Alarms and associated Ticket information. | ||
| - | </ | ||
| - | </ | ||
| - | |||
| - | <WRAP group> | ||
| - | <WRAP half column> | ||
| - | wf_ticket_status_change | ||
| - | </ | ||
| - | |||
| - | <WRAP half column> | ||
| - | This table contains ticket transition from one stage to another and how much time it spends at any stage. There will be one row for each transition for a ticket. | ||
| - | </ | ||
| - | </ | ||
| - | |||
| - | <WRAP group> | ||
| - | <WRAP half column> | ||
| - | v_hw_elements | ||
| - | </ | ||
| - | |||
| - | <WRAP half column> | ||
| - | This view contains total count of active on-air NE per technology. This table provides additional to reports to calculate average stats. | ||
| - | </ | ||
| - | </ | ||
| - | |||
| - | <WRAP group> | ||
| - | <WRAP half column> | ||
| - | v_network_element_latest_change_on | ||
| - | v_network_element_status | ||
| - | </ | ||
| - | |||
| - | <WRAP half column> | ||
| - | This view contains information about on-Air status of NE which is used by daily_active_alarm_summary to filter out off-air NE for report. If there is any pending request for on-air element that will also be considered in outage report. | ||
| - | </ | ||
| - | </ | ||
| - | |||
| - | <WRAP group> | ||
| - | <WRAP half column> | ||
| - | v_service_impacting | ||
| - | </ | ||
| - | |||
| - | <WRAP half column> | ||
| - | This view is used by outage summary report to filter out all non-service impacting alarm outages. It is a supplementary view. | ||
| - | </ | ||
| - | </ | ||
| - | |||
| - | <WRAP group> | ||
| - | <WRAP half column> | ||
| - | v_device_outage_summary | ||
| - | </ | ||
| - | |||
| - | <WRAP half column> | ||
| - | This view is derived from device_outage_summary table and used by Tableau Reporting. | ||
| - | </ | ||
| - | </ | ||
| - | |||
| - | <WRAP group> | ||
| - | <WRAP half column> | ||
| - | v_hw_alarms | ||
| - | </ | ||
| - | |||
| - | <WRAP half column> | ||
| - | This view contains the number of alarms received per technology. It is used by in the Worst H/W by technology Tableau Report. | ||
| - | </ | ||
| - | </ | ||
| - | |||
| - | ---- | ||
| - | |||
| - | ==== Appendix ==== | ||
| - | |||
| - | Project folder: | ||
| - | * [[https:// | ||
| - | * [[https:// | ||
| - | * [[https:// | ||
| - | |||
| - | |||
idmsapplications/ket_stats.1639415787.txt.gz · Last modified: 2021/12/13 17:16 by 10.91.120.28
Page Tools
