need to modify the sql in a way that the timestamp comes only in 1 row
Hello ,
Below is the query:
select first_metadata_load_time,target_name, property_name, property_value from MGMT_TARGETS T, MGMT_TARGET_PROPERTIES TP ,sysman.MGMT_TARGETS_LOAD_TIMES LT where T.target_guid=TP.target_guid and target_type='oracle_database' and property_name IN ('MachineName', 'DBVersion', 'OracleHome','host','Boottime') and T.target_guid=LT.target_guid and FIRST_METADATA_LOAD_TIME>=sysdate-60 order by 1,2
Now, the metadata_load_time is coming corresponding to when Machine name,dbversion,oraclehome and host comes.I want to let this metadata_load_time and target_name come only once and then the other rows which have machinename ,host succeed by this.