Volume Details - SQL query

WinterSoldier

Hi,

I am finding a query to get the volume name, volume count assigned to subjected nodes with their respective pollers.

Example : I have one APE where its showing that total volume elements are 1000(i.e). I want to know that these 1000 volume elements are belong to which nodes .

Please help me finding this.

Thank you.

bootstraps

Here is one I just came up with:

SELECT ND.NodeID, ND.Caption, ND.EngineID, EN.ServerName, VL.Caption AS [Vol Caption]
FROM Orion.Nodes AS ND
LEFT JOIN Orion.Engines AS EN ON ND.EngineID = EN.EngineID
JOIN(
    SELECT TOP 100 NodeID, Caption
    FROM Orion.Volumes
    WHERE NodeID = NodeID
) AS VL ON VL.NodeID = ND.NodeID AND VL.NodeID = ND.NodeID

Does this get you stated?