Script

Hi All,

Greetings of the day. Hope everyone is doing great.   Am using the below script to get backup report

SELECT hb.host "Host Name",

hb.database_name" Database Name",

hb.target_type "Target Type",

hb.status "Status",

hb.start_time "Start Time",

hb.end_time "End Time",

hb.output_device_type "Output Device",

tp.property_value "Lifecycle Status"

FROM mgmt$ha_backup hb,

mgmt$target_properties tp

WHERE hb.target_guid = tp.target_guid

AND tp.property_name = 'orcl_gtp_lifecycle_status'

AND hb.target_guid IN

(SELECT member_target_guid

FROM mgmt$group_flat_memberships

WHERE composite_target_guid =HEXTORAW(??EMIP_BIND_TARGET_GUID??)