Mail Archive Search: <+subject:/^(?:^\s*(re|sv|fwd|fw)[\[\]\d]*[:>-]+\s*)*Help\s+with\s+query\s*$/>

Results:

References: [ +subject:/^(?:^\s*(re|sv|fwd|fw)[\[\]\d]*[:>-]+\s*)*Help\s+with\s+query\s*$/: 3 ]

Total 3 documents matching your query.

1. Help with query (score: 1): Author: Joe Howell <jhowell_tsm AT YAHOO DOT COM>; Date: Mon, 11 Aug 2003 07:21:49 -0700; I've got a collocated offsite copy storage pool and need to get a list of what nodes are represented on what volumes. The only way I know of is to issue a "select distinct node_name from volumeusage; /lists/html/ADSM-L/2003-08/msg00330.html (8,646 bytes)
2. Re: Help with query (score: 1): Author: Andrew Raibeck <storman AT US.IBM DOT COM>; Date: Mon, 11 Aug 2003 11:44:15 -0600; I think that the VOLUMEUSAGE table is probably your best bet for this info. I'd suggest a query like this: select distinct volume_name, node_name from volumeusage where stgpool_name='POOLNAME' order; /lists/html/ADSM-L/2003-08/msg00340.html (9,615 bytes)
3. Re: Help with query (score: 1): Author: Joe Howell <jhowell_tsm AT YAHOO DOT COM>; Date: Tue, 12 Aug 2003 08:36:40 -0700; Thanks Andy, that worked very well. Andrew Raibeck <storman AT US.IBM DOT COM> wrote:I think that the VOLUMEUSAGE table is probably your best bet for this info. I'd suggest a query like this: select; /lists/html/ADSM-L/2003-08/msg00370.html (9,821 bytes)

Current List: 1 - 3
Page: [1]