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@;CHW.EDU] Sent: Wednesday, November 06, 2002 6:45 PM To: [EMAIL PROTECTED] 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
