Applications Puppet Agent Last Run Greater Than 1 Day
Configuration
severity
warning
Rule Query
sql SELECT * FROM devices,device_group_device,device_groups,devices_group_perms,users,notifications_attribs,notifications,applications,application_metrics WHERE (devices.device_id = ? AND devices.device_id = device_group_device.device_id AND device_group_device.device_group_id = device_groups.id AND device_groups.id = devices_group_perms.device_group_id AND devices_group_perms.user_id = users.user_id AND users.user_id = notifications_attribs.user_id AND notifications_attribs.notifications_id = notifications.notifications_id AND devices.device_id = applications.device_id AND applications.app_id = application_metrics.app_id) AND applications.app_type = puppet-agent AND application_metrics.metric = last_run_last_run AND application_metrics.value > 3000 AND (devices.status = 1 (devices.disabled = 0 devices.ignore = 0)) = 1 AND notifications.datetime > DATE_SUB(NOW(),INTERVAL 5 DAY)