Jaffaa
Mudiripoyina Bewarse Username: Jaffaa
Post Number: 23492 Registered: 03-2008 Posted From: 204.14.239.75
Rating: N/A Votes: 0 | Posted on Monday, March 21, 2016 - 4:06 pm: | |
select target_name, value, collection_timestamp from mgmt$metric_details where collection_timestamp > sysdate -1 and metric_label='Load' and column_label like 'CPU in User Mode%' and regexp_like(target_name, '^abc|^xyz|^lmn|^opq|^viv') order by 3 desc; paina query vundhi this is returning all the results that I want collection_timestamp - date column basic gaa naaku value average kaavali every 15 minutes interval ki and also group by target_name....also eedhanna date ki value NULL iithe 0.0 kindha thesukovali output should be something like TARGET_NAME AVG(VALUE) ROUND(COLLECT_TS) abc123 1.1 2016-18-03 12:00 xyz234 1.4 2016-18-03 12:00 abc123 2.1 2016-18-03 12:15 xyz234 3.4 2016-18-03 12:15 |