Just wondering if it's possible at all to change a measurement of a QOS Value.
Our use case is simple: we have the CDM probe calculation the uptime of machines, but the QoS values are in seconds. This leads to billions of seconds uptime and is not really readable.
We want to convert these values to hours or days and use these to populate our reports. In the dashboard designer you have a multiplier/division field where you can manipulate how the data is presented. Not so in list/performance reports, so I believe we have to write the data directly to the database in the correct format.
Or maybe we can create a new QOS based on the old one and do the conversion there.
I'm just wondering how to do this? Has anyone done something similar in the pas?
Currently this can not be done at the probe level.
You could create a custom dashboard that used a sql query to alter the value.
Thanks for the reply. Currently we're using the list report to display the uptime, together with another column to show reachability as a time slice.
Putting everything in a dashboard gives us less flexibility, put if this is the only way, so be it.
Shame that there's no way of doing simple recalculations of QoS data on the list designer.
i believe that dashboard designer is right approach.
Created a dashboard with the SQL widget on it.
For those who are interested, this is the query behind it
select round(G1.samplevalue / 86400,0) as UptimeDays, G1.target as Systemfrom
(select MAX(R1.samplevalue) as samplevalue, S1.target from RN_QOS_DATA_0016 as R1 INNER JOIN S_QOS_DATA as S1 on R1.[table_id] = S1.[table_id] GROUP BY S1.target) as G1 order by samplevalue DESC