Community
- Command Central
- MVP Program
- Monthly Mission
- Blogs
- Groups
- Events
- Media Vault
Products
- Observability
- Network Management
- Application Management
- IT Security
- IT Service Management
- System Management
- Database Management
Content Exchange
- SolarWinds Platform
- Server & Application Monitor
- Database Performance Analyzer
- Server Configuration Monitor
- Network Performance Monitor
- Network Configuration Manager
- SQL Sentry
- Web Help Desk
Free Tools & Trials
Store

Link to node not working

In the following code, can anyone tell me why my link to nodes is not working?

SELECT '' as n, '/Orion/images/StatusIcons/Small-' + tostring(N.StatusIcon) AS [_IconFor_n], '/Orion/NetPerfMon/NodeDetails.aspx?NetObject=N%3a' + ToString(N.NodeID) AS [_LinkFor_Server],

N.Caption, N.UnManageFrom AS [From], N.UnManageUntil AS [Until], AE.AccountID AS [By], DayDiff(GetDate(), N.UnmanageUntil) AS [Days Left]

, CP.Comments

FROM Orion.Nodes N

JOIN Orion.AuditingEvents AE

ON (AE.NetObjectID = N.NodeID)

INNER JOIN Orion.NodesCustomProperties CP

ON N.NodeID = CP.NodeID

WHERE N.UnManaged = 1 AND (AE.AuditEventID = (SELECT TOP 1 AE2.AuditEventID FROM Orion.AuditingEvents AE2 WHERE AE2.NetObjectID = N.NodeID ORDER BY AE2.TimeLoggedUtc DESC))

ORDER BY N.Caption

When I hover over the device name nothing happens...

Find more posts tagged with

Accepted answers

All comments

RichardLetts

you don't have a column 'Server' in your query for the LinkFor to apply to -- I think you need it to be _LinkFor_Caption

Richard

FormerMember

So I tried a few more things and still no joy.... Current query

SELECT '' as n, '/Orion/images/StatusIcons/Small-' + tostring(N.StatusIcon) AS [_IconFor_n], N.detailsurl as [_linkfor_Caption],

N.Caption, N.UnManageFrom AS [From], N.UnManageUntil AS [Until], AE.AccountID AS [By], DayDiff(GetDate(), N.UnmanageUntil) AS [Days Left]

, CP.Comments

FROM Orion.Nodes N

JOIN Orion.AuditingEvents AE

ON (AE.NetObjectID = N.NodeID)

INNER JOIN Orion.NodesCustomProperties CP

ON N.NodeID = CP.NodeID

WHERE N.UnManaged = 1 AND (AE.AuditEventID = (SELECT TOP 1 AE2.AuditEventID FROM Orion.AuditingEvents AE2 WHERE AE2.NetObjectID = N.NodeID ORDER BY AE2.TimeLoggedUtc DESC))

ORDER BY N.Caption

RichardLetts

you have to mention the column in the query before the linkfor clause.

this works:

SELECT '' AS n,

'/Orion/images/StatusIcons/Small-'

+ Tostring(N.statusicon) AS [_IconFor_n],

N.caption,

N.detailsurl AS [_LinkFor_Caption],

N.unmanagefrom AS [From],

N.unmanageuntil AS [Until],

AE.accountid AS [By],

Daydiff(Getdate(), N.unmanageuntil) AS [Days Left],

CP.comments

FROM orion.nodes N

JOIN orion.auditingevents AE

ON ( AE.netobjectid = N.nodeid )

INNER JOIN orion.nodescustomproperties CP

ON N.nodeid = CP.nodeid

WHERE N.unmanaged = 1

AND ( AE.auditeventid = (SELECT TOP 1 AE2.auditeventid

FROM orion.auditingevents AE2

WHERE AE2.netobjectid = N.nodeid

ORDER BY AE2.timeloggedutc DESC) )

ORDER BY N.caption

[aside: if you want to figure out who unmanaged the node rather than had the last audit event on a node then you will need a condition in your subselect]

mesverrum

This is the query I use for unmanaged/muted nodes, you might find it helpful. I edited it to pull in the comment the way you have it on yours.

SELECT'Unmanaged' as [Status],n.Caption AS [Node],tostring(tolocal(n.UnManageFrom)) AS [From],case when n.UnManageUntil is null or n.UnManageUntil = '9999-01-01 00:00:00' then 'Not set'else tostring(tolocal(n.UnManageUntil)) end AS [Until],case when n.UnManageUntil is null or n.UnManageUntil = '9999-01-01 00:00:00' then '-'else tostring(daydiff(getutcdate(), n.unmanageuntil)) end as [Days Left],n.DetailsURL AS [_LinkFor_Node],'/Orion/images/StatusIcons/Small-' + n.StatusLED AS [_IconFor_Node],CASEWHEN ae.accountID IS NULL THEN 'Audit Log Not Found'ELSE ae.AccountIDEND AS [Account],n.customproperties.CommentFROMOrion.Nodes nJOIN (    SELECT rec.NetObjectID, max(rec.timeloggedutc) as recent    FROM Orion.AuditingEvents rec    WHERE rec.auditingactiontype.actiontype = 'Orion.NodeUnmanaged'    group BY rec.NetObjectID) mostrecent ON mostrecent.NetObjectID = n.NodeIDJOIN (    SELECT ae.NetObjectID, ae.AccountID, ae.timeloggedutc    FROM Orion.AuditingEvents ae    WHERE ae.auditingactiontype.actiontype = 'Orion.NodeUnmanaged') ae ON ae.NetObjectID = n.NodeID and ae.timeloggedutc=mostrecent.recentWHERE n.Status = 9union all(SELECT'Muted' as [Status],n.caption,tostring(tolocal(SuppressFrom)) as [From],case when SuppressUntil is null or SuppressUntil = '9999-01-01 00:00:00' then 'Not set'else tostring(tolocal(SuppressUntil )) end AS [Until],case when SuppressUntil is null or SuppressUntil = '9999-01-01 00:00:00' then '-'else tostring(daydiff(getutcdate(), asup.SuppressUntil)) end as [Days Left],n.DetailsURL AS [_LinkFor_Node],'/Orion/images/StatusIcons/Small-' + n.StatusLED AS [_IconFor_Node], ae.AccountID AS [Account],n.customproperties.CommentFROM Orion.AlertSuppression asupjoin orion.nodes n on asup.entityuri=n.urijoin (    SELECT ae.NetObjectID, max(ae.timeloggedutc) as recent    FROM Orion.AuditingEvents ae    WHERE ae.auditingactiontype.actiontype in ('Orion.AlertSuppressionChanged','Orion.AlertSuppressionAdded')    group BY ae.netobjectid) mostrecent ON mostrecent.NetObjectID = n.NodeIDjoin (    SELECT ae.NetObjectID, ae.AccountID, ae.timeloggedutc    FROM Orion.AuditingEvents ae    WHERE ae.auditingactiontype.actiontype in ('Orion.AlertSuppressionChanged','Orion.AlertSuppressionAdded')    Order BY ae.TimeLoggedUtc desc) ae ON ae.NetObjectID = n.NodeID and ae.timeloggedutc=mostrecent.recent)ORDER BY [node] asc, [status] desc