How do I export data from UIM for QOS metrics for a time period?

Products

• DX Unified Infrastructure Management (Nimsoft / UIM)

Issue/Introduction

We have a requirement to export CPU, memory, and disk utilization metrics for all the servers in UIM for a duration of three months.
Please let me know how can we achieve this by any one of the options listed below:

1) UMP portal

2) CABI

3) UIM Database

 

Environment

UIM: 8.x 9.x
UMP: 8.x and 9.x
CABI 3.X and 4.x

Resolution

There is no one-step process out of the box to do this.

The method used will need to be determined on your abilities to create custom reports or use SQL queries to find the data you want and export.

From ump, you could create PRD reports to collect the information you want and then use the export function of the PRD to save this to a CSV file format.

https://techdocs.broadcom.com/content/broadcom/techdocs/us/en/ca-enterprise-software/it-operations-management/unified-infrastructure-management/9-0-2/configuring-and-viewing-monitoring-data/the-performance-reports-designer.html

With CABI this would be basically the same process of building a report and then exporting it.

http://techdocs.broadcom.com/content/broadcom/techdocs/us/en/ca-enterprise-software/it-operations-management/ca-unified-infrastructure-management-probes/GA/dashboards/ca-business-intelligence-dashboards.html#concept.dita_c74c8b2f75beafc02a5dce25f0648aa864b8cf2b_OptionalCreateaCustomDashboard

For access to the data directly with SQL you can look at the s_qos_data table to find the metrics you want.
this will tell you the table ID you need to connect to the RN tables to get the actual data you want.

Below is an example of this:

Example to fetch the CPU-Usage(Total) from a robot called asterix:

1. Find the name of the QoS data table and the table_id. Build a SELECT-statement like this:

select source, target, r_table, table_id from S_QOS_DATA where qos='QOS_CPU_USAGE' and source ='asterix' and target = 'Total'
Result: source = 'asterix' , target = 'Total', r_table ='RN_QOS_DATA_0014', table_id = '9' (source and target not used for the next statement

2. Get the QoS data serie by using r_table and table_id. Build a SELECT-statement like this:

select sampletime, samplevalue from RN_QOS_DATA_0014 where table_id = '9' order by sampletime DESC

If you need only a time period then add a sampletime check, e.g.

select sampletime, samplevalue from RN_QOS_DATA_0014 where table_id = '9' and sampletime > '11/29/2011 00:00:00' and sampletime < '11/29/2011 23:59:59' order by sampletime DESC

If you also need the units of the QoS data, you need to fetch the qos_def_id from the S_QOS_DATA, too. With the qos_def_id you fetch the QoS definitions, e.g.,

select unit from S_QOS_DEFINITION where qos_def_id = '14'