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:[EMAIL PROTECTED]] Sent: Wednesday, October 02, 2002 9:53 AM To: [EMAIL PROTECTED] 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