How to bulk delete QOS_CPU_USAGE metrics data with User,System,Wait or Idle as target

Products

• DX Unified Infrastructure Management (Nimsoft / UIM)

Issue/Introduction

When enabling  CDM probe Total CPU User,System,Wait or Idle QoS collection additional target are created for these QoS,  these targets will we listed as available for reports as this way:

 

In some cases the collection of these metric were enable accidentally or for testing or just customer does not like to see them any more. If this is your case please apply next procedure.

Environment

UNIFIED INFRASTRUCTURE MGMT

Resolution

In order to delete all data collected from QOS_CPU_USAGE metric with User,System,Wait or Idle as target please do the following:

1- Make a database backup 

2- Run query:

   select qos , source , target , ci_metric_id from S_QOS_DATA where qos = 'QOS_CPU_USAGE' and target in ('User','System','Wait','Idle')

3- Check at query output that objects listed are the objects that you like to delete

4- If all objects listed are correct and need to be deleted run the next deletion query:

                    DELETE FROM S_QOS_DATA where qos = 'QOS_CPU_USAGE' and target in ('User','System','Wait','Idle')

Additional Information

If you like to revert this task you'll need to restore the previously backup done.