cameljake

Thank you so much! What does the '2000' represent in the query? 

I actually just figured out how to do this. Here is the query if anyone else needs help with this SELECT top 100 N.Caption as Name, cps.Status, tolocal(DATETRUNC('hour',CPS.DateTime)) as date FROM Orion.Nodes N INNER JOIN Orion.NPM.CustomPollerAssignment CPA ON N.NodeID=CPA.NodeID FULL JOIN Orion.NPM.CustomPollerStatistics…