Quering SWQL to generate KPI metrics on EOC dashboard for two instances and I want to validate the RAW data fetched by EOC
We have two Instances and Query seems to be running fine on KPI Widget of modern dashboard of EOC for both instances , getting the data from both instances altogether or separately
Since I want to see raw data from EOC perpective , I am running same query to generate Reports from EOC console
Reports run fine and gives RAW data when ran for Instance ID 1 but same SWQL query return error saying query not valid when ran for InstanceiD 2 or both Instances Altogether ?
These run just fine when ran on Widgets to see RAW data . Any clue why this problem with EOC ? Below is query which is returning error if i replace InstanceiD with 1 , it will run just fine
SELECT A.NodeID,C.Caption,A.Availability,A.DateTime,A.ObservationTimestamp
FROM
Orion.ResponseTime A
JOIN
Orion.NodesCustomProperties B ON A.NodeID = B.NodeID
JOIN
Orion.Nodes C ON A.NodeID = C.NodeID
WHERE
A.datetime BETWEEN '2024-08-01' AND '2024-10-31'
AND B.CustomProperty LIKE '%x%'
AND A.InstanceSiteID = '2'
