On 12/01, Larry Clark wrote: > Wanda, > Do you have a query for displaying which volumes contain which filesystems > by node?
SELECT - node_name AS "Node", - filespace_name AS "FS", - stgpool_name AS "Pool", - volume_name AS "Volume" - FROM - volumeusage - GROUP BY - node_name, - filespace_name, - stgpool_name, - volume_name - ORDER BY - 1 ASC, 3, 2, 4