I would like to know if there is any way to monitor the continuity of QOS data, say for example if the QOS is not available say for a particular period of time, is there any way for us to be notified?
Thanks in advance.
If the qos is queued up we can trigger a alert from hub
You could run a query on the relevant RN table to look for a QOS metric in the last 5 mins using sql_response probe. If no rows raise an alarm?
Obviously not good for mass rollout but OK for a specific metric that is important.
There is a TECDOC available (https://support.ca.com/us/knowledge-base-articles.TEC1516536.html) that has an SQL query you can use to determine a list of QOS tables that only have data for the last 24 hours. You could possibly modify that query to meet your needs, and perhaps use sqlserver with a custom checkpoint based on that query to alert on the results being unexpected.
Retrieving data ...