Level: Critical

Purpose: The stats_network_identifier_node_count table that this watchdog checks is used by the “Availability - Carrier Availability Per Network and Month” report specific to EXT. It checks if the required data has been populated.

Scenario: The last time this watchdog occurred was because the cronjob didn't run on the required time.

Resolution: This watchdog will resolve itself once this query returns a non-zero value:

SELECT IF(DAY(NOW()) = 1, 1, (SELECT  COUNT(*) FROM stats_network_identifier_node_count WHERE MONTH(date) = MONTH(NOW()) AND YEAR(date) = YEAR(NOW()))) as 'count(*)';

Manual Action Steps: Ensure crontab is working correctly and run

/home/scotty/script/network_element_count_stats/populate_ne_count_stats.sh

script that exists on extdb1

Auto Clear: No