DX Unified Infrastructure Management

Expand all | Collapse all

sql query

  • 1.  sql query

    Posted Jan 26, 2017 09:23 AM

    Hello Team

     

    Please do we have a query to run on sql that can generate  all the  list of servers currently being monitored on ump. I mean cpu, disk, memory details n all?

     

    Please share the query.

     

    Many thanks 



  • 2.  Re: sql query

    Broadcom Employee
    Posted Jan 26, 2017 10:34 AM

    I do not know of a single query you can run.

    You can run a select * from s_qos_data to get a start with the information.



  • 3.  Re: sql query

    Posted Jan 26, 2017 11:21 AM

    Thanks Gene .I will use this for the time being.

     

    If anyone of your team can put input would be appreciable 

    casph02 Phani.Devulapalli Marco_Ippati davidm5.5 david.brenner.1960 



  • 4.  Re: sql query

    Broadcom Employee
    Posted Jan 26, 2017 11:39 AM

    La-Qa, Maybe you should be more specific on what are you trying to achieve.  If you mean that you need a list of all the servers that appear in UMP they are in:

    select name from cm_computer_system 



  • 5.  Re: sql query

    Posted Jan 26, 2017 11:47 AM

    Hi Marco

     

    Thanks for your input 

     I need query which can pull all the machines currently being monitoring in my ump with CPU disk and memory information in it.

     

    Like how much CPU consumption available , how much memory n disk available of each system.

     

    I want this in a list from a query 

     

    Hope u got my point



  • 6.  Re: sql query

    Posted Jan 26, 2017 11:50 AM


  • 7.  Re: sql query

    Posted Jan 26, 2017 12:00 PM

    Hi assac

     

    I would prefer from the backend. Pls I know this can be acheivable as the information belongs from deffernet tables which need to pull. Pls if you share the query for this would be good ...



  • 8.  Re: sql query

    Broadcom Employee
    Posted Jan 26, 2017 12:53 PM

    Hi,

    Also, please take a look at this thread this may help you.

    https://communities.ca.com/thread/241761964

    Thanks.

    Regards

    -Sayeed



  • 9.  Re: sql query

    Posted Jan 26, 2017 01:45 PM

    Hello, take a look on BryanKMorrow answer to this thread :

    Server Availability report , it has a nice query example,

    About the tables  i think you can find your som of your server informations on cm_computer_systems like what tipe of model is, the ip address but no data about QOS, on table s_qos_data you will find where you qos data are  stored, the info are the r_table that identiy wich rn_qos_data00xx table is the raw data, the table_id that identify gives you the condition to find the data example ( where table_id =  ? ) the qos and the target identifies the data you are colecting



  • 10.  Re: sql query

    Posted Jan 26, 2017 01:57 PM

    If you are using the QOS_VIEWS script previously mentioned, you can use the following query to get a report for the windows servers, you will need to adjust the query for other operating systems.

     

    uim/server_performance.txt at master · BryanKMorrow/uim · GitHub 



  • 11.  Re: sql query

    Posted Feb 03, 2017 01:54 AM

    You can try this one if you want the see which servers that is monitored by the cdm probe:

    SELECT DISTINCT s.name, s.ip, sqd.probe

    FROM cm_computer_system s,

    cm_device d,

    cm_configuration_item ci,

    cm_configuration_item_metric cim,

    s_qos_data sqd

    WHERE s.cs_id = d.cs_id

    AND d.dev_id = ci.dev_id

    AND ci.ci_id = cim.ci_id

    AND cim.ci_metric_id = sqd.ci_metric_id

    AND sqd.probe = 'cdm'

     

    /Mats