DX Unified Infrastructure Management

 View Only

  • 1.  How to check cpu data in SQL (uim) database

    Posted May 30, 2017 07:59 AM

    Hi Guys,

     

    How do i can check the data in database for cpu, disk and memory?

     

    Regards,

    IK



  • 2.  Re: How to check cpu data in SQL (uim) database

    Broadcom Employee
    Posted May 30, 2017 10:19 AM

    Hello Imran, can you please explain more detailed what you are looking for ?

     

    Thanks and kind regards,

    Britta Hoffner

    CA Support



  • 3.  Re: How to check cpu data in SQL (uim) database
    Best Answer

    Broadcom Employee
    Posted May 31, 2017 08:24 PM

    You can check the s_qos_data table and from there the rn_qos_data table can be queried to see data collected. Here are some examples on what to query.

     

    select * FROM S_QOS_DATA where probe = 'cdm' and source = '10.1.1.100'

    select * FROM S_QOS_DATA where qos = 'QOS_CPU_USAGE' and source = '10.1.1.100'

     

    From that query two things are needed, the table_id & rn_data table.

     

    select * FROM [CA_UIM].[dbo].[RN_QOS_DATA_0010] where table_id = 14