Hi All,
This script to list the member(s) of the child groups of a node dependency.
SELECT d.Name as [Dependency]
,case when d.ParentEntityType='Orion.Nodes'
then (select concat('<img src="/orion/images/statusicons/Small-'+n.StatusLED+'"></>',
'<a href="/Orion/View.aspx?View=NodeDetails&NetObject=N:',cast(n.NodeID as varchar),'">',
'<span style="color:', CASE status when 2 THEN 'red' WHEN 1 THEN 'green' WHEN 9 THEN 'purple' ELSE 'black' END,
'">', Caption, '</>') from nodes n where n.nodeid=d.ParentNetObjectID)
else d.name end as [Parent]
,case when d.ChildEntityType='Orion.Groups'
then (select Name from Containers where ContainerID=d.ChildNetObjectID)+' : ' + (select isnull((SELECT cast(Name + ', ' as XML), cast([Description] + CHAR(13) as XML)
FROM ContainerMemberSnapshots
where containerid=d.ChildNetObjectID FOR XML PATH('') ),'None') )
when d.ChildEntityType='Orion.Nodes'
then (select name from nodes where nodeid=d.ChildNetObjectID)
end as [Child]
FROM Dependencies d
where d.ChildEntityType in ('Orion.Nodes', 'Orion.Groups')
and d.ParentEntityType in ('Orion.Nodes')
