DX Unified Infrastructure Management

Hi Everyone,

Is there any query which we can use to monitor the QOS (CPU Usage) in origin wise last 12 hours in multitenancy environment , whether QOS data are present or not.

Thanks,

Naveen

Hi,

Following is the query , which shows, how may QOS data into the monitoring. But it doesn't show the actual RAW data. If you wanted to get actual sample raw data then you have to use the RN_QOS_DATA_XXXX. Let us know if this can help you.

Just change the Origin for the customer your looking for. like 'ABC' or 'XYZ'

SELECT cs.name,
qd.target,
qd.source,
qd.table_id,
qd.origin,
qd.qos,
qd.ci_metric_id,
qd.probe,
qd.origin,
qd.r_table,
qd.h_table,
ci.ci_name,
cim.ci_metric_type,
cid.ci_type,
cid.ci_description
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_definition cid ON cid.ci_type = ci.ci_type
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 qd.origin = 'ORIGIN'
AND 1=1 AND qs.sampletime > '2017-03-12 01:28:41.6'
ORDER BY cid.ci_description,
ci.ci_name,
qd.probe,
qd.target

Thanks,

Bhupesh

Today i found one of the link into the communities which CA team has suggested . please find the link below. This will show the last 24 hours QOS data. 

I have not tested it but you can modify this query according to origin. 

https://www.ca.com/us/services-support/ca-support/ca-support-online/knowledge-base-articles.TEC1516536.html?intcmp=searc… 

Thanks,

Walde