Skip to Main Content

Enterprise Manager

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

OEM-Grafana plug:How to increase the number of time-series metrics returned by restful API query ?

Kiwi712Dec 2 2020

I love the OEM-Grafana App and the Dashboards ! I have some Custom-Repository time-series queries in panels which return datasets that are being limited to 10 metrics and they are always ordered and displayed alphabetically on metric . How can increase this array ceiling to say 20 and alter the sort order based on value rather than metric string-values A-Z order ? I have tried all sorts of things by obviously adjusting the order by in query and adjusting Application API restful property settings on OMS but nothing alters the 10 limit.
basic example:
select rollup_timestamp as time_sec, average as value , key_value as metric
from sysman.mgmt$metric_daily a, sysman.mgmt$target b
where b.target_name = $oem_gf_target_name
and b.target_guid=a.target_guid
and a.metric_column = 'spaceAllocated'
and a.metric_name='tbspAllocation'
ORDER BY 1 ASC;
If I have more than 10 tablespaces in my database then I only see the first 10 in A-Z tablespace-name order.
This the query inspector perspective :
Object
request:Object
url:"api/datasources/proxy/159/em/websvcs/restful/grafana/v1/query"
data:Object
range:Object
targets:Array[1]
isRemoteConnection:false
method:"POST"
response:Array[10] <--- How to change this and how to change order to sort on value rather than metric?
0:Object
target:"BMFDATA"
datapoints:Array[6]
1:Object
target:"EXAMPLES"
datapoints:Array[6]
2:Object
target:"IOPS"
datapoints:Array[6]
3:Object
target:"SCOTT_ARCHIVE"
datapoints:Array[2]
4:Object
target:"SDBA_DATA"
datapoints:Array[6]
5:Object
target:"SDBA_IDX"
datapoints:Array[6]
6:Object
target:"SYSAUX"
datapoints:Array[6]
7:Object
target:"SYSTEM"
datapoints:Array[6]
8:Object
target:"TEMP"
datapoints:Array[6]
9:Object
target:"TPCCTAB"
datapoints:Array[6]
( I have another few tablelspaces with tablespace-names not being included in returnset )
Many thanks for any insight/assistance you can offer. Brett

Comments
Post Details
Added on Dec 2 2020
14 comments
1,017 views