If you run the qos_view sql script (see:
https://community.broadcom.com/enterprisesoftware/viewdocument/qos-views-ms-sql-script-feb-2016) you can create more relax sql queries like:
-----
select top 10 source, target, avg(samplevalue) as avg, max(samplevalue) as max from
v_qos_cpu_usage
where sampletime between dateadd(day, -30, getdate()) and getdate()
and target not in ('System', 'Idle', 'User', 'Wait') and probe in ('cdm', 'rsp')
group by source, target
order by avg desc
select source, target, avg(samplevalue) as avg , MIN(samplevalue) as min ,MAX(samplevalue) as max
from V_QOS_MEMORY_PHYSICAL
where sampletime >= DATEADD(day, -30, GETDATE())
group by source, target
order by source,target
Original Message:
Sent: 08-13-2019 06:22 PM
From: DAVID MICHEL
Subject: CA UIM Fetch 1 month report
207 servers times the number of disk and cpu each has and your count is already way above 207.
as for the min. max, av. just do the math with all the data points you get for each.
if using the default monitoring cycle of 5min. that's going to be a lot.
correction on this, the min & max you can probably get via query and for the average export it into a spreadsheet
------------------------------
Support Engineer
Broadcom
Original Message:
Sent: 08-13-2019 06:12 PM
From: Dharmender Singh
Subject: CA UIM Fetch 1 month report
Hello Daniel,
Thank you very much for your suggestions and really appreciate for your efforts.
We checked we have 207 Servers which are in production Environment.
CDM 5.80 is running on all of the 207 servers, We need to fetch sql data for last one month, data which contain Minimum, Average, Maximum Utilization values of CPU, Disk and Memory.
As we checked in data_engine probe we need data for below qos.
How will get these values, which contain Minimum, Average, Maximum Utilization values of CPU, Disk and Memory.
Kindly suggest.
Regards
Dharmender
Original Message:
Sent: 08-13-2019 04:51 PM
From: Daniel Blanco
Subject: CA UIM Fetch 1 month report
You can do this:
First find all the QoS you want to pull from the S_QOS_Data table.
--Find the QoS your looking for
Query 1:
select origin,robot,probe,qos,target,r_table,h_table,v_table,table_id
FROM S_QOS_DATA
where robot like ('%loc5-lap136%') and probe = 'cdm'
ORDER BY origin,robot,probe,qos,target
Result:
select top 1000 * from RN_QOS_DATA_0003
where table_id = '4709239' and sampletime >= '2019-07-01 00:00:00' and sampletime <= '2019-08-01 00:00:00'
order by sampletime
------------------------------
Daniel Blanco
Enterprise Tools Architect
Alphaserve Technologies
Original Message:
Sent: 08-13-2019 04:30 PM
From: Daniel Blanco
Subject: CA UIM Fetch 1 month report
Why is there no UMP?
------------------------------
Daniel Blanco
Enterprise Tools Architect
Alphaserve Technologies
Original Message:
Sent: 08-13-2019 12:53 PM
From: Dharmender Singh
Subject: CA UIM Fetch 1 month report
Hi Team,
We are using UIM 8.5.1
CDM version 5.80
No UMP
Only IM or AC we are using for server administration, there is a requirement to fetch the data for earlier 1 month of CPU / Memory / Disk utilization of PROD servers.
So is there is any way to achieve the requirement.
Thank you in advance.
Regards
Dharmender