Hi,
I am trying to create a query to show the Node to Volume to Fileshare. Can someone help share how to obtain the mapping from the Node to the Fileshares in SRM?
When I run this query I'm not getting the correct tables; am I not liking the correct 'srm.fileshares.volumeID = n.volumes.volumeID ??
SELECT top 2000 n.NodeID, n.Caption, n.Volumes.VolumeID as [Node VolumeID], n.volumes.DisplayName as [Volume], fs.ID as [FileShare ID], fs.DisplayName as [Fileshare Name], fs.Path as [FileShare Path], fs.Quota as [Fileshare Quota], fs.free as [FileShare Free], fs.Used as [FileShare Used]
FROM Orion.nodes n
left join orion.srm.FileShares FS on FS.VolumeID = n.Volumes.VolumeID
