DX Infrastructure Management

Expand all | Collapse all

# OF DEVICES MONITORED

  • 1.  # OF DEVICES MONITORED

    Posted 05-19-2017 04:57 PM

    Hi guys.

     

    I´m looking for a way to graph the number of devices included on monitoring on UIM per day/month ?

     

    I´m digging something on cm_computer_system and cm_nimbus_robot tables, but no success until now.

     

    Did you guys already tried something like this ?

     

    Thank you.

     

    Clecimar



  • 2.  Re: # OF DEVICES MONITORED

    Posted 05-19-2017 05:24 PM

    Those would just show the number of robots, not the actual number of monitored devices if you are doing network monitoring, storage, rsp etc.  are you looking st making these numbers as a metric or just viewable on a dashboard?



  • 3.  Re: # OF DEVICES MONITORED

    Posted 06-14-2017 09:43 AM

    Hi Bryan, I´m back with this demand.

     

    In fact I need a number and a way put in a graph how many devices go into along the month, for example.

     

    Do you have any idea how to do this ?

     

    Thank you.

     

    Clecimar



  • 4.  Re: # OF DEVICES MONITORED

    Posted 06-14-2017 10:24 AM

    You can try my custom probe that will show the number of devices for the different probe packages for the last 30 days, if this is more in line with what you want, I can try and provide some SQL queries that will return the information.

     

    Probe of Things - A Custom Probe That Does Things 

     

    Run the "licensing_run_all" callback from the probe utility and then check the index.html in the probe_of_things/reports installation directory.



  • 5.  Re: # OF DEVICES MONITORED

    Posted 06-14-2017 11:10 AM
      |   view attached

    Hi Bryan.

     

     

     

    Let me try another way. Imagine the histogram bellow as example:

     

     

     

     

     

     

     

    I want to see on this kind of graph how many robots/devices go to into during this month for example!

     

     

     

    Thank you.

     

     

     

    Clecimar

     

     

     

    De: BryanKMorrow 

    Enviada em: quarta-feira, 14 de junho de 2017 11:25

    Para: Clecimar Fernandes

    Assunto: Re:  - Re: # OF DEVICES MONITORED

     

     

     

     

     

     

    <https://communities.ca.com/?et=watches.email.thread> CA Communities

     

     

     

     

     

     

    Re: # OF DEVICES MONITORED

     

     

    reply from Bryan Morrow <https://communities.ca.com/people/BryanKMorrow?et=watches.email.thread>  in Unified Infrastructure Management - View the full discussion <https://communities.ca.com/message/241986046-re-of-devices-monitored?commentID=241986046&et=watches.email.thread#comment-241986046>



  • 6.  Re: # OF DEVICES MONITORED

    Posted 06-14-2017 11:16 AM

    You would need to have a samplevalue and sampletime in the database to create a chart like this in the HTML 5 dashboard designer.

     

    You could use this query in sql_response to generate a robot count qos value, and then create your chart.

     

    select count(*) as robot_count from CM_NIMBUS_ROBOT



  • 7.  Re: # OF DEVICES MONITORED

    Posted 06-14-2017 12:44 PM

    Yep!!!

     

     

     

    This were I stopped! How to take this from db: samplevalue and sampletime.

     

     

     

    Anyway.

     

     

     

    Thank you.

     

     

     

    Clecimar

     

     

     

    De: BryanKMorrow 

    Enviada em: quarta-feira, 14 de junho de 2017 12:17

    Para: Clecimar Fernandes

    Assunto: Re:  - Re: # OF DEVICES MONITORED

     

     

     

     

     

     

    <https://communities.ca.com/?et=watches.email.thread> CA Communities

     

     

     

     

     

     

    Re: # OF DEVICES MONITORED

     

     

    reply from Bryan Morrow <https://communities.ca.com/people/BryanKMorrow?et=watches.email.thread>  in Unified Infrastructure Management - View the full discussion <https://communities.ca.com/message/241986155-re-of-devices-monitored?commentID=241986155&et=watches.email.thread#comment-241986155>



  • 8.  Re: # OF DEVICES MONITORED

    Posted 06-14-2017 12:48 PM

    This post will show you how to create the chart, but you will need to correct the SQL query to match the correct RN table for your metrics.

     

    UIM Dashboards - How to create a Line Series Chart from SQL 



  • 9.  Re: # OF DEVICES MONITORED

    Posted 06-15-2017 03:42 PM

    Great!

     

     

     

    Does there a table that give me the samplevalue by day ? How to consolidate it on day basis for example ?

     

     

     

    Thank you again.

     

     

     

    Clecimar

     

     

     

    De: BryanKMorrow 

    Enviada em: quarta-feira, 14 de junho de 2017 13:49

    Para: Clecimar Fernandes

    Assunto: Re:  - Re: # OF DEVICES MONITORED

     

     

     

     

     

     

    <https://communities.ca.com/?et=watches.email.thread> CA Communities

     

     

     

     

     

     

    Re: # OF DEVICES MONITORED

     

     

    reply from Bryan Morrow <https://communities.ca.com/people/BryanKMorrow?et=watches.email.thread>  in Unified Infrastructure Management - View the full discussion <https://communities.ca.com/message/241986161-re-of-devices-monitored?commentID=241986161&et=watches.email.thread#comment-241986161>



  • 10.  Re: # OF DEVICES MONITORED

    Posted 06-15-2017 03:46 PM

    Query the DN_QOS_DATA_XXXX table instead of the RN_QOS_DATA_XXXX table.



  • 11.  Re: # OF DEVICES MONITORED

    Posted 06-20-2017 12:13 PM

    Hi Bryan.

     

     

     

    The problem is, number of devices is not related to QoS measure and tables RN, DN, etc… are related to QoS metrics, right ?

     

     

     

    Clecimar

     

     

     

    De: BryanKMorrow 

    Enviada em: quinta-feira, 15 de junho de 2017 16:46

    Para: Clecimar Fernandes

    Assunto: Re:  - Re: # OF DEVICES MONITORED

     

     

     

     

     

     

    <https://communities.ca.com/?et=watches.email.thread> CA Communities

     

     

     

     

     

     

    Re: # OF DEVICES MONITORED

     

     

    reply from Bryan Morrow <https://communities.ca.com/people/BryanKMorrow?et=watches.email.thread>  in Unified Infrastructure Management - View the full discussion <https://communities.ca.com/message/241986577-re-of-devices-monitored?commentID=241986577&et=watches.email.thread#comment-241986577>



  • 12.  Re: # OF DEVICES MONITORED

    Posted 06-20-2017 12:23 PM

    Yes, you will need to join it with the S_QOS_DATA table OR use the sql_views script to query by QOS name.

     

    qos_views sql script 

     

    Bryan



  • 13.  Re: # OF DEVICES MONITORED

    Posted 06-20-2017 12:47 PM

    Back to cm_nimbus_robot table. There are two columns called “check_time” and “alive_time”. Do you know which of them is related to the creation/deployment date of the robot ?

     

     

     

    When you said to use this table, in fact I´ve already tried, the problem is where is the creation/deployment date ?

     

     

     

    As you said I need to find two columns in order to graph what I need (time x # of robots). What I´m almost realized that this is impossible for UIM, I mean, to know the # of devices created/deployed, for example, on the last week!!!

     

     

     

    Thank you again.

     

     

     

    Clecimar

     

     

     

    De: BryanKMorrow 

    Enviada em: terça-feira, 20 de junho de 2017 13:25

    Para: Clecimar Fernandes

    Assunto: Re:  - Re: # OF DEVICES MONITORED

     

     

     

     

     

     

    <https://communities.ca.com/?et=watches.email.thread> CA Communities

     

     

     

     

     

     

    Re: # OF DEVICES MONITORED

     

     

    reply from Bryan Morrow <https://communities.ca.com/people/BryanKMorrow?et=watches.email.thread>  in Unified Infrastructure Management - View the full discussion <https://communities.ca.com/message/241987601-re-of-devices-monitored?commentID=241987601&et=watches.email.thread#comment-241987601>