Node Notes resource for Summary Views

Notes are stored in the [dbo].[NodeNotes] table.

Hi Deltona

Try this:

SELECT
CONCAT('<a href="',nd.Caption,'</a>')">thwack.solarwinds.com/.../View.aspx AS 'Caption'
,nd.Caption
,nd.UnManageFrom
,nd.UnManageUntil
,nn.Note
FROM Nodenotes nn
INNER JOIN NodesData nd ON nn.NodeID = nd.NodeID

Just make sure you tick 'Allow HTML Tags' in the table layout field.

David

Looking good! Any way I could convince you to add a filter so that it only displays NodeNotes for Unmanaged and Muted nodes?

Hi Deltona

The UnManaged part is fairly easy as that is contained in the NodesData table, however, the Muted is a little bit more tricky as that is a totally different set of statistics that are spread across different tables. I might have a stab at it when I get more time, but for now try this new and improved version:

SELECT
'<img src="/orion/images/statusicons/Small-'+nd.StatusLED+'"/>' +
'<a href="thwack.solarwinds.com/.../View.aspx as varchar)+'">'+nd.Caption+'</>' [Node]
,nd.UnManageFrom
,nd.UnManageUntil
,nn.Note
FROM Nodenotes nn
INNER JOIN NodesData nd ON nn.NodeID = nd.NodeID
WHERE nd.UnManaged = 1

I've slightly updated the Node statement so that it includes the Status Icon and a Link.