✅ Example: “Find Databases with No Backup Run in Last 3 Days”

 SELECT

    t.target_name AS database_name,

    t.host_name,

    MAX(b.end_time) AS last_backup_time,

    CASE

        WHEN MAX(b.end_time) IS NULL THEN 'NO BACKUP RUN EVER'

        WHEN MAX(b.end_time) < SYSDATE - 3 THEN 'NO RECENT BACKUP (Older than 3 days)'

        ELSE 'RECENT BACKUP OK'

    END AS backup_activity

FROM sysman.mgmt$target t

LEFT JOIN sysman.mgmt$ha_backup b

    ON t.target_guid = b.target_guid

WHERE t.target_type IN ('oracle_database', 'rac_database')

GROUP BY t.target_name, t.host_name

ORDER BY backup_activity, last_backup_time;