--- SCRIPT BEGINS HERE ---
/* This script dispplays the Webservices and Beacon type targets along with their status from an Oracle Grid Control Repository Database */
COL TARGET_GUID form a33
COL TARGET_NAME form a20
COL TARGET_TYPE form a18
COL EMD_URL form a50
COL LAST_LOAD form date
COL STATUS form a12
SELECT t.TARGET_GUID,t.TARGET_NAME, t.TARGET_TYPE,
DECODE(a.current_status,0,'Down',1,'Up',2,'Metric Error',3,'Agent Down',4,'Unreachable',5,'Blackout',6,'Unknown') Status,
to_char(t.LAST_LOAD_TIME,'YYYY-MM-DD HH24:MI:SS') LAST_LOAD, t.emd_url
FROM mgmt_targets t,
mgmt_current_availability a
WHERE t.target_guid = a.target_guid
AND (t.target_type in ('oracle_beacon','generic_service','generic_system'))
ORDER BY TARGET_TYPE;
--- SCRIPT ENDS HERE ---
