Can anyone point me in the right direction why this boiled down bit of SWQL code would work fine from one of the Orion instances, but fail when trying to run from EOC against all those same Orion instances?
select rt.Node.Caption, Min(DateTime) as First, Max(DateTime) as Last from Orion.ResponseTime rt
and DateTime>ADDDATE('HOUR', -1, GETDATE())
Group By rt.Node.Caption
The error indicates "Subquery column with 'PropertyRef/T2.C4' not found".
mwb the federated SWIS can be a bit different in some cases. Try this query - see if that helps.
SELECT Caption, MIN(ResponseDateTime) AS First, MAX(ResponseDateTime) AS Last
SELECT rt.Node.Caption as Caption, rt.DateTime as ResponseDateTime
FROM Orion.ResponseTime rt
AND DateTime >ADDDATE('HOUR', -1, GETDATE())
GROUP BY Caption
SolarWinds solutions are rooted in our deep connection to our user base in the THWACK® online community. More than 150,000 members are here to solve problems, share technology and best practices, and directly contribute to our product development process. Learn more today by joining now.