This discussion has been locked. The information referenced herein may be inaccurate due to age, software updates, or external references.
You can no longer post new replies to this discussion. If you have a similar question you can start a new discussion in this forum.

Viewing NodeNotes within Nodes with Problems Report

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