JAVA J2EE 4 U

SELECT 

    TRIM(SUBSTR(t.target_name, 1, INSTR(t.target_name, '.') - 1)) AS database_name,

    t.host_name,

    NVL(p.property_value, 'NOT CONFIGURED') AS backup_configured

FROM 

    sysman.mgmt$target t

    LEFT JOIN sysman.mgmt$target_properties p

        ON t.target_guid = p.target_guid

        AND p.property_name IN ('ConfiguredBackupSchedule', 'BackupConfigured')

WHERE 

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

    AND (p.property_value IS NULL OR p.property_value IN ('NO', 'NOT CONFIGURED'))

ORDER BY 

    t.host_name;