Daily Admin Checklist

Almost all system information can be found on the Admin menu > Status Monitor page (see this doc for more information http://help.metricinsights.com/m/MI_System_Maintenance/l/783129-status-monitor-page). 

The following is a list of items you can check to get an overall pulse of the Metric Insights application.

  1. Red Tiles:
    Tiles highlighted in red represent issues that need your attention. For example, a red 'Elements with Errors' tile contains a link that will direct you to a list of elements with errors for further troubleshooting. Key tiles to look out for are:
    • Elements with Errors
    • Aborted Data Collections
    • Overdue Triggers
    • Queued Emails
    • Email Server
    • Cron
    • LDAP
    • System Load Average
    • Disk Space Free
  2. Pipeline tab:
    This page visualizes the data collection triggers that are running on MI. This is especially useful if you have a chain of dependencies for different triggers. Visualizing this chain allows you to see the relationships between data dependencies, data collection triggers, and notification schedules, i.e. "how does data come into the system and how it goes out."
  3. Application Errors tab:
    This page shows all recent application errors. This is especially useful if you or your team encounter issues with the application or the application exhibits any odd behavior. You can also download all system error logs from this page (errors you can't see in the UI) by clicking on the [Get Error Logs] button. You can choose to download the logs to your local machine or send them to the MI Support team for review.

    If sending to MI Support, be sure to submit a ticket to [email protected] and explain what issues you are encountering.


To get further insight into the system, you can also create reports to run queries against the MI application that will return useful information. Here are some sample queries you can run:

1.  How many bursts were delivered for the prior week:

SELECT COUNT(DISTINCT nsrld.ns_run_id) as Quantity_of_delivered_Bursts
FROM notification_schedule_distribution AS nsd
JOIN notification_schedule_run_log_detail AS nsrld ON (nsrld.ns_distribution_id=nsd.notification_schedule_distribution_id)
WHERE nsrld.start_time >=(NOW() - INTERVAL 1 WEEK);


2.  How many users had failed login attempts for the prior week:

SELECT u.user_id AS User_ID, u.username AS User_Name, afl.failed_login_time AS Failed_Login_Time,
afl.failed_login_attempts AS number_of_failed_attempts
FROM user AS u
JOIN auth_failed_logins AS afl ON (u.user_id=afl.id)
WHERE afl.failed_login_time>=(NOW()-INTERVAL 1 WEEK);


3.  List of Burst recipients (if notifications are enabled):

SELECT DISTINCT nsdi.notification_schedule_distribution_id AS Burst_ID, nsd.name AS Burst_Name, up.user_id AS Burst_Recipient_ID, u.display_name AS Burst_Recipient_Name, IFNULL(fdei.element_id,nsdi.element_id) AS Element_ID
FROM notification_schedule_distribution AS nsd
JOIN notification_schedule_distribution_item AS nsdi ON (nsdi.notification_schedule_distribution_id=nsd.notification_schedule_distribution_id
AND( (nsd.content_type='favorites' AND nsdi.favorite_id>0)
OR (nsd.content_type='tiles' AND nsdi.element_id IS NOT NULL)))
LEFT JOIN favorite_dashboard_element_info AS fdei ON (fdei.favorite_id=nsdi.favorite_id)
LEFT JOIN notification_schedule_distribution_group_recipient AS nsdgr ON (nsdgr.notification_schedule_distribution_id=nsdi.notification_schedule_distribution_id)
LEFT JOIN user_group_member AS ugm ON (ugm.user_group_id=nsdgr.group_id)
LEFT JOIN notification_schedule_distribution_user_recipient AS nsdur ON (nsdur.notification_schedule_distribution_id=nsdi.notification_schedule_distribution_id)
JOIN user_preference AS up ON (up.user_id=IFNULL(ugm.user_id,nsdur.user_id))
JOIN user AS u ON (u.user_id=up.user_id)
WHERE nsd.enabled_ind='Y'
AND up.email_notification_enabled_ind = 'Y'
AND IFNULL(fdei.element_id,nsdi.element_id) IS NOT NULL;


4.  List of Alert recipients (if notifications are enabled):

SELECT DISTINCT uar.alert_rule_id AS Alert_ID, arei.visualization_element_id AS Element_ID, de.name AS Element_Name, 
uar.user_id AS Alert_Recipient_ID, u.display_name AS Alert_Recipient_Name
FROM user_alert_rule AS uar
JOIN alert_rule_element_info AS arei ON (uar.alert_rule_id=arei.alert_rule_id AND uar.element_id=arei.element_id)
JOIN user_preference AS up ON (up.user_id=uar.user_id)
JOIN user AS u ON (u.user_id=uar.user_id)
JOIN dashboard_element AS de ON (de.element_id=arei.visualization_element_id)
WHERE uar.enabled_ind='Y'
AND up.email_notification_enabled_ind = 'Y';