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
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
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.
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>
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
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>
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.
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>
Query the DN_QOS_DATA_XXXX table instead of the RN_QOS_DATA_XXXX table.
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>
Yes, you will need to join it with the S_QOS_DATA table OR use the sql_views script to query by QOS name.
Bryan
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>
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?