DX Infrastructure Management

Expand all | Collapse all

CDM probe: Convert QoS Uptime Measurements

Jump to Best Answer
  • 1.  CDM probe: Convert QoS Uptime Measurements

    Posted 05-07-2018 06:10 AM

    Hi everyone,

     

    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?

     

    thanks

     

    Mark



  • 2.  Re: CDM probe: Convert QoS Uptime Measurements

    Posted 05-07-2018 08:31 AM

    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.



  • 3.  Re: CDM probe: Convert QoS Uptime Measurements

    Posted 05-08-2018 01:49 AM

    Hi Gene

     

    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.

     

    cheers

     

    Mark



  • 4.  Re: CDM probe: Convert QoS Uptime Measurements

    Posted 05-08-2018 03:26 AM

    i believe that dashboard designer is right approach.



  • 5.  Re: CDM probe: Convert QoS Uptime Measurements
    Best Answer

    Posted 05-08-2018 05:07 AM

    Hi guys

     

    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 System
    from

    (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

     

    Mark