Clients are connected to policy domains which contain management classes
that have copygroups that specify a storage primary pool.  There is now way
to perform a select to definitively find out what you want.  The BACKUPS
table has the management classes of the backups for a node.  But, it can be
hugh and unmanageable to use as a resource to determine the management
classes used by a node.  Remember the include/exclude file specifies the
management classes for the elements and the server has no visibility to the
include/exclude file.  So, you are kind of out of luck to do it easily with
a select.

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


-----Original Message-----
From: Joseph Dawes [mailto:jdawes AT CHUBB DOT COM]
Sent: Wednesday, October 02, 2002 9:53 AM
To: ADSM-L AT VM.MARIST DOT EDU
Subject: select statement for disk pools


Does anyone have a select statement to draw a correlation between which
cleints go to which disk pools?






Joseph Dawes
I/T Infrasctructure - Unix Technical Support
Chubb & Son, a Division of Federal Insurance Company
15 MountainView Road
Warren,New Jersey 07059

Office:908.903.3890