what am I missing with this query

trilobite_rex

SELECT
N.Caption AS [Node Name],
i.Name AS IntName,
i.StatusIcon AS IntStatusIcon,
i.Status AS IntStatus,
i.DetailsURL AS IntDetailsURL,
N.MachineType AS [Machine Type],
N.IP_Address AS [IP Address],
N.LastSystemUpTimePollUtc AS [Last Successful Poll],
N.VendorIcon AS [Vendor Icon],
N.DetailsURL AS [Details URL],
N.Location,
N.Contact,
N.Status AS NodeStatus,
N.StatusDescription AS NodeStatusDescription,
N.StatusIcon AS NodeStatusIcon
FROM Orion.Container AS c
JOIN Orion.ContainerMembers AS cm ON c.ContainerID = cm.ContainerID
JOIN Orion.Nodes AS n ON cm.MemberPrimaryID = n.NodeID
JOIN Orion.NPM.Interfaces AS i ON n.NodeID = i.NodeID
@';

I see the icon.gif or status.gif but not the green/red icon.

sum_giais

Assuming you're using a custom query widget...

SELECT
N.Caption AS [Node Name],
i.Name AS IntName,
N.MachineType AS [Machine Type],
N.IP_Address AS [IP Address],
N.LastSystemUpTimePollUtc AS [Last Successful Poll],
N.Vendor,
CONCAT('/NetPerfMon/Images/Vendors/', [N].VendorIcon) AS [_IconFor_Vendor],
N.Location,
N.Contact,
CONCAT('/Orion/StatusIcon.ashx?entity=Orion.NPM.Interfaces&id=', i.InterfaceID, '&status=', i.Status, '&size=Small') AS [_IconFor_IntName],
--CONCAT('/Orion/images/StatusIcons/Small-', CASE WHEN i.Status = 0 THEN 'Unknown' WHEN i.Status = 1 THEN 'Up' WHEN i.Status = 2 THEN 'Down' WHEN i.Status = 9 THEN 'Unmanaged' WHEN i.Status = 3 THEN 'Warning' WHEN i.Status = 14 THEN 'Critical' END, '.gif') AS [_IconFor_IntName],
CONCAT('/Orion/StatusIcon.ashx?entity=Orion.Nodes&id=', N.NodeID, '&status=', N.Status, '&size=Small') AS [_IconFor_Node Name],
--CONCAT('/Orion/images/StatusIcons/Small-', CASE WHEN N.Status = 0 THEN 'Unknown' WHEN N.Status = 1 THEN 'Up' WHEN N.Status = 2 THEN 'Down' WHEN N.Status = 9 THEN 'Unmanaged' WHEN N.Status = 3 THEN 'Warning' WHEN N.Status = 14 THEN 'Critical' END, '.gif') AS [_IconFor_Node Name],
i.DetailsURL AS [_LinkFor_IntName],
N.DetailsURL AS [_LinkFor_Node Name]
FROM Orion.Container AS c
JOIN Orion.ContainerMembers AS cm ON c.ContainerID = cm.ContainerID
JOIN Orion.Nodes AS n ON cm.MemberPrimaryID = n.NodeID
JOIN Orion.NPM.Interfaces AS i ON n.NodeID = i.NodeID
@'

To use icons and links in custom query widgets you need to prepend the fields with _IconFor_ and _LinkFor_

If the fields selected don't work, you can uncomment the other fields (there's a couple different ways to grab the status icons via a URL), both are provided.