Unmanaged Node List Using Custom Query Resource

bharris1

I'm trying to get my Unmanage Resource to sort by Unmanaged From.  I've tried different things and it keeps erroring out.  This is what I have now, without the attempt I made sorting by UnmanagedFrom. Can anyone take a look and see if they can assist?

SELECT

    NodeName AS [Node Name],

        '/Orion/images/StatusIcons/Small-' + StatusIcon AS [_IconFor_Node Name],

        DetailsUrl AS [_LinkFor_Node Name], MAX(ToLocal(Nodes.UnmanageFrom)) AS [Unmanaged From], MAX(ToLocal(Nodes.UnmanageUntil)) AS [Unmanaged Until]

FROM Orion.Nodes

WHERE UNMANAGED = 1

GROUP BY NodeName, StatusIcon, DetailsUrl, Nodes.CustomProperties.Alert_Team, Nodes.CustomProperties.Business_Function

ORDER BY NodeName

i_like_eggs

Try adding in the Join

SELECT

    NodeName AS [Node Name],

        '/Orion/images/StatusIcons/Small-' + StatusIcon AS [_IconFor_Node Name],

        DetailsUrl AS [_LinkFor_Node Name], MAX(ToLocal(Nodes.UnmanageFrom)) AS [Unmanaged From], MAX(ToLocal(Nodes.UnmanageUntil)) AS [Unmanaged Until]

FROM Orion.Nodes 

INNER JOIN orion.NodesCustomProperties cp on cp.NodeID = Nodes.NodeID

WHERE UNMANAGED = 1

GROUP BY NodeName, StatusIcon, DetailsUrl, cp.Alert_Team, cp.Business_Function

ORDER BY NodeName