Re: [ADSM-L] I'm missing something somewhere -- which volumes contain wh

Subject:	Re: [ADSM-L] I'm missing something somewhere -- which volumes contain which filesystems by node
From:	km <km AT GROGG DOT ORG>
To:	ADSM-L AT VM.MARIST DOT EDU
Date:	Mon, 12 Jan 2009 17:04:26 +0100

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

<Prev in Thread]	Current Thread	[Next in Thread>
[ADSM-L] I'm missing something somewhere -- I need statistics on storage pool backup and can't seem to find them, Kauffman, Tom Re: [ADSM-L] I'm missing something somewhere -- I need statistics on storage pool backup and can't seem to find them, Lindsay Morris Re: [ADSM-L] I'm missing something somewhere -- I need statistics on storage pool backup and can't seem to find them, Kauffman, Tom Re: [ADSM-L] I'm missing something somewhere -- I need statistics on storage pool backup and can't seem to find them, Wanda Prather Re: [ADSM-L] I'm missing something somewhere -- I need statistics on storage pool backup and can't seem to find them, Lindsay Morris Re: [ADSM-L] I'm missing something somewhere -- I need statistics on storage pool backup and can't seem to find them, Kauffman, Tom Re: [ADSM-L] I'm missing something somewhere -- I need statistics on storage pool backup and can't seem to find them, km Re: [ADSM-L] I'm missing something somewhere -- I need statistics on storage pool backup and can't seem to find them, Wanda Prather Re: [ADSM-L] I'm missing something somewhere -- which volumes contain which filesystems by node, Larry Clark Re: [ADSM-L] I'm missing something somewhere -- which volumes contain which filesystems by node, km <= Re: [ADSM-L] I'm missing something somewhere -- part 2, Kauffman, Tom Re: [ADSM-L] I'm missing something somewhere -- part 2, Kelly Lipp Re: [ADSM-L] I'm missing something somewhere -- part 2, Kauffman, Tom Re: [ADSM-L] I'm missing something somewhere -- part 2, Mark Stapleton Re: [ADSM-L] I'm missing something somewhere -- part 2, Mark Stapleton Re: [ADSM-L] I'm missing something somewhere -- part 2, Kauffman, Tom Re: [ADSM-L] I'm missing something somewhere -- I need statistics on storage pool backup and can't seem to find them, Kauffman, Tom Re: [ADSM-L] I'm missing something somewhere -- I need statistics on storage pool backup and can't seem to find them, km

Re: [ADSM-L] I'm missing something somewhere -- which volumes contain which filesystems by node