We are trying to find a way to show Orion.NodeNotes within our Nodes with Problems Report which resides within Report Writer. We have a separate custom SQL qeuery as seen below which will pull all NodeNotes alone but want to try and tie this into this other report to be seen in a column on the right. Any ideas to accomplish this?
Query for Notes Only:
SELECT N.Caption, 'orion.qt.local/.../NodeDetails.aspx' + ToString(NodeID) AS [_LinkFor_Caption],
ToLocal(TimeStamp) as TimeStamp, Note, AccountID
FROM Orion.NodeNotes NN
Join Orion.Nodes N on NN.NodeID = N.NodeID
Join Orion.NodesCustomProperties P on P.NodeID = N.NodeID
order by TimeStamp desc
Report Writer SQL Query for "Nodes with Problems":
SELECT
Nodes.NodeID AS NodeID, Nodes.Store_Num AS Store_Num, Nodes.GroupStatus AS Group_Status_Icon, Nodes.Caption AS NodeName, Nodes.StatusDescription AS Status_Description, Nodes.Site_Type AS Site_Type
FROM
Nodes
WHERE
(
(Nodes.Severity <> 0) AND
(Nodes.Status <> '3')
)
ORDER BY 2 ASC, 4 ASC