DX Unified Infrastructure Management

  • 1.  QoS update

    Posted Jun 15, 2017 02:02 PM

    Hi,

     

    I want to retrive robot and probe details which is not updated for past 48 hrs with QoS data. Pls help me with query.



  • 2.  Re: QoS update

    Posted Jun 15, 2017 03:43 PM

    Try this.

     

    select q.source, q.target, q.robot, q.origin, q.probe, q.qos, s.sampletime from s_qos_snapshot s inner join s_Qos_data q on s.table_id=q.table_id GROUP BY s.table_id, q.source, q.target, q.robot, q.origin, q.probe, q.qos, s.sampletime having datediff(hour, max(s.sampletime), getdate()) > 48



  • 3.  Re: QoS update

    Posted Jun 15, 2017 03:59 PM

    Hi

     

    Thanks for update. I believe there will be data in QoS even if machine is

    removed from monitoring ( older data). Any way to compare these results

    with cm_computer_systems table to identify live systems.

     

    On 16-Jun-2017 1:13 AM, "BryanKMorrow" <



  • 4.  Re: QoS update

    Posted Jun 15, 2017 04:01 PM

    That query touches the S_QOS_SNAPSHOT table, which is the last poll of each S_QOS entry.



  • 5.  Re: QoS update

    Posted Jun 15, 2017 04:04 PM

    Thank you very much for clarifying!!

     

    On 16-Jun-2017 1:31 AM, "BryanKMorrow" <