Many thanks to you all.

-----Original Message-----
From: ADSM: Dist Stor Manager [mailto:ADSM-L AT VM.MARIST DOT EDU]On Behalf Of
Fred Johanson
Sent: 06 December 2007 14:39
To: ADSM-L AT VM.MARIST DOT EDU
Subject: Re: [ADSM-L] select query for nodes in no collocation group


Yet another approach is to check if the non-collocated need collocation:

select node_name, sum(physical_mb) as "STORAGE"
 from occupancy where node_name in (select
 node_name from nodes where collocgroup_name is
 null and domain_name=upper('$1')) group by
 node_name

Fred Johanson
TSM Administrator
University of Chicago

773-702-8464

-----Original Message-----
From: ADSM: Dist Stor Manager [mailto:ADSM-L AT VM.MARIST DOT EDU] On Behalf Of
Richard Sims
Sent: Thursday, December 06, 2007 7:23 AM
To: ADSM-L AT VM.MARIST DOT EDU
Subject: Re: [ADSM-L] select query for nodes in no collocation group

Another approach is:

  select node_name from volumeusage where stgpool_name='________'

to verify if the nodes you expect are actually participating in a
group-collocated storage pool.

Notes:
- Nodes may participate in a group-collocated storage pool and
   not be defined in a collocation group, such that collocation by
   node would then be in effect for such clients, and make for more
   tape use than you might expect.
- The VOLUMEUSAGE table is expensive to search, so do only when
   necessary.

      Richard Sims    at Boston University

Oxfordshire County Council - rated a four-star 'Excellent' council by the Audit 
Commission

The information in this e-mail, together with any attachments, is confidential. 
If you have received this message in error you must not print off, copy, use or 
disclose the contents. The information may be covered by legal and/or 
professional privilege. Please delete from your system and inform the sender of 
the error. As an e-mail can be an informal method of communication, the views 
expressed may be personal to the sender and should not be taken as necessarily 
representing the views of the Oxfordshire County Council. As e-mails are 
transmitted over a public network the Oxfordshire County Council cannot accept 
any responsibility for the accuracy or completeness of this message. It is your 
responsibility to carry out all necessary virus checks. You should be aware 
that all emails received and sent by this Council are subject to the Freedom of 
Information Act 2000 and therefore may be disclosed to other parties under that 
Act. www.oxfordshire.gov.uk