The issue is a node connects to a policy domain that connects to a
management class and in the management class is the copy group, but the
decision as to what management class is used in the policy domain is a
client include/exclude or a clientopt decision unless the default management
class is used.

You can get a list of storage pools that each client could be using by doing
the following:

select distinct node_name, destination from nodes n, bu_copygroups b where
n.domain_name=b.domain_name and set_name='ACTIVE'

To get what is being used by what you would have to go against the contents
table and determine the volume storage pool from the volumes table.  The
time to run that select will take forever on a system like mine.

Paul D. Seay, Jr.
Technical Specialist
Naptheon Inc.
757-688-8180


-----Original Message-----
From: Baldenegro, Raymond - Perot [mailto:rbalden AT CHW DOT EDU]
Sent: Wednesday, November 06, 2002 6:45 PM
To: ADSM-L AT VM.MARIST DOT EDU
Subject: SQL Statement


I have an immediate need to create a list of all my registered nodes and the
storage pool(s) each node backs up to. I know almost nothing about creating
an SQL statement so if anyone can assist, I would appreciate it very much.


Raymond Baldenegro
Analyst
CHW Enterprise Storage Management
perotsystems