Comments
-
Certainly.
-
Thanks Steven, you rock!
-
Orion Core 2012.1.0, SAM 5.0.1, NPM 10.3, NTA 3.9.0, IVIM 1.3.0
-
Same error (System.Data.SqlClient.SqlException (0x80131904): ...) I saved the new report with a different name just to be sure.
-
select n.nodeid, n.caption, count(1) as qty from nodes n join events e on n.nodeid = e.netobjectid where e.netobjecttype = 'N' -- node object type and e.eventtype = '1' -- down node and e.eventtime between dateadd(hh,-24,getdate()) and getdate() -- last 24 hours group by n.nodeid, n.caption having count(1) > 3 -- there…
-
Awesome, thanks Steven, This query worked within Report Writer, when I accessed the report via Orion NPM I got the following. Being an SQL noob, I could use some help deciphering what happened between NMP and Report Writer; System.Data.SqlClient.SqlException (0x80131904): Column 'nodes.NodeID' is invalid in the select list…
