I want to retrive robot and probe details which is not updated for past 48 hrs with QoS data. Pls help me with query.
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
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" <
That query touches the S_QOS_SNAPSHOT table, which is the last poll of each S_QOS entry.
Thank you very much for clarifying!!
On 16-Jun-2017 1:31 AM, "BryanKMorrow" <
Retrieving data ...