Dong Shin 11.13.2012

  • continue working on Alerts
    • alerts that are not closed and older than 7 days query
      • SELECT *, DATEDIFF(NOW(), timestamp) AS days
        FROM ppm_alerts.alerts
        WHERE status <> ‘CLOSED’
        AND DATEDIFF(NOW(), timestamp) > 7
    • Alert_8_notResolvedIn7Days.py – not saving into alerts table, report only
    • saved table_queries – visibility_scripting.table_queries.sql