daily pastebin goal


a guest Jun 14th, 2018 42 Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  1. SELECT d.[Name] as DepName
  2.       ,[ParentEntityType]
  3.       ,[ParentNetObjectID]
  4.       ,[ChildEntityType]
  5.       ,[ChildNetObjectID]
  6.       ,coalesce(con.Name, nod.Caption, trans.name, app.name) as [ParentName]
  7.       ,coalesce(con.status, nod.status, trans.laststatus, app.Availability) as [ParentStatus]
  8. FROM dbo.Dependencies as d
  9.     LEFT JOIN (SELECT  c.ContainerID
  10.         ,c.Status
  11.         ,c.Name
  12.         FROM dbo.containers as c) as con on d.ParentNetObjectID = con.ContainerID AND d.ParentEntityType = 'Orion.Groups'
  13.    LEFT JOIN (SELECT n.NodeID... --A left Join for every flavor that looks the same as above
  14. WHERE 1=1 --Not important for this
  15. ORDER BY ParentName
RAW Paste Data
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy. OK, I Understand