Joseph, Each client can back up files to multiple disk pools depending on which management classes/copygroups it's binding files to in the include/exclude list. So to do this, you would have to select against your backups and mgmtclass tables or your contents and volumes tables, both of which would be pretty painful. It also wouldn't be "hard" information because there may be clients that COULD go to a certain diskpool but haven't because the included files haven't existed yet.
It would be more correct to say all your clients in domain X can go to any of the diskpools specified by copygroups in domain X. select domain_name, class_name, destination from bu_copygroups where set_name='ACTIVE' and destination in (select stgpool_name from stgpools where devclass='DISK') select domain_name, node_name from nodes I hope this helps. Alex Paschal Storage Administrator Freightliner, LLC (503) 745-6850 phone/vmail -----Original Message----- From: Joseph Dawes [mailto:[EMAIL PROTECTED]] Sent: Wednesday, October 02, 2002 6: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
