User Tools
Writing /app/www/public/data/meta/watchdogs/watchdog_alarm_summary_report.meta failed
watchdogs:watchdog_alarm_summary_report
Differences
This shows you the differences between two versions of the page.
| Next revision | Previous revision | ||
| watchdogs:watchdog_alarm_summary_report [2016/09/28 16:38] – created mmcc | watchdogs:watchdog_alarm_summary_report [2021/06/25 10:09] (current) – external edit 127.0.0.1 | ||
|---|---|---|---|
| Line 1: | Line 1: | ||
| + | ====== Watchdog Alarm Summary Report ====== | ||
| + | Author: Sophie Renshaw | ||
| + | |||
| + | On both Crown Castle and ExteNet we have the Watchdog Alarm Summary Report. It is hidden to the customer but lets us see what watchdogs have not cleared on the relevant servers. | ||
| + | |||
| + | As part of the support process whoever is on Level 2 (Watchdog Rota) in the morning should be running the report for both customers to check for any watchdogs that haven’t cleared. If there are any on either report they need to be investigated and reported to ensure that they don’t become service impacting. | ||
| + | |||
| + | The report is a very simple report and it uses a number of database profiles in the reporting manager along with a MySQL query to return information on the Watchdogs. | ||
| + | |||
| + | For Example: Crown Castle Production | ||
| + | |||
| + | Database connections are declared: | ||
| + | |||
| + | {{ : | ||
| + | |||
| + | * Each of these connections has their own Database Profile in the reporting Manager | ||
| + | |||
| + | {{ : | ||
| + | |||
| + | * In this profile the name, connection URL, user name, password and Driver must be specified | ||
| + | * It might be necessary to grant privileges on the server for the username/IP address combo that is being used: | ||
| + | |||
| + | GRANT SELECT ON *.* TO ' | ||
| + | |||
| + | * **Note:** Try to give as little permission as possible to the profile to still allow it to perform as expected. | ||
| + | |||
| + | * Changing the report to add another server into monitoring: | ||
| + | - Add the Database connection | ||
| + | - Create the Database Profile | ||
| + | - Ensure the profile has access | ||
| + | - Test and Monitor for Watchdog alarms. | ||
Page Tools
