How to create a dashboard with TOP 10 CPU and MEMORY of servers.
Release : 20.3
Component : UIM OPERATOR CONSOLE - DASHBOARDS/DESIGNER
There is no default top-N dashborad for CPU/ memory usage..
Either you have to use the create customized dashboard from cabi following the TOP N CPU memeory report query .
OR
For dashboard designer > use the custom query use a a custom query that returns the TOP 10 CPU usage servers and build a custom SQL Table widget using that query.
Below query for getting top cpu usage machines
SELECT qd.source,
qd.qos,
qs.samplevalue
FROM cm_computer_system cs
INNER JOIN
cm_device d ON d.cs_id = cs.cs_id
INNER JOIN
cm_configuration_item ci ON ci.dev_id = d.dev_id
INNER JOIN
cm_configuration_item_metric cim ON cim.ci_id = ci.ci_id
INNER JOIN
s_qos_data qd ON qd.ci_metric_id = cim.ci_metric_id
INNER JOIN
s_qos_snapshot qs ON qd.table_id = qs.table_id
WHERE qos = 'QOS_CPU_USAGE' AND qs.sampletime > '2022-04-01 00:00:00.000'
ORDER BY samplevalue desc
Change the qos value based on your requirement.