User Tools
MonthlyNetIdentifierCountIsZero
Level: Major 
Purpose: This alert tells us that the network identifier count query returned 0 results. This is used for billing purposes
Scenario: This watchdog runs this query and alerts us if the result is 0
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(*)';
Resolution: Check the cronjob to see if this executed at the right time
0 0 1 * * /home/scotty/script/network_element_count_stats/populate_ne_count_stats.sh > /home/scotty/script/network_element_count_stats/ne_populate_stats.out 2>&1
This is supposed to run at 00:00 on the first of the month but sometimes it may run an hour before.
Manual Action Steps: If this happens check the crontab, there may not be a CRON_TZ variable set and cron may be using a different timezone than the server. If this is the case set this to be the same timezone and restart the cron service.
Auto Clear: This will auto clear once the result is not 0
