Hi Lawrence You can use the following select query to get the management classes associated to a nodes files. Be careful, this can be a VERY long query if you have a lot of files (eg a fileserver).
Select node_name,distinct(class_name) from backups where node_name='XXXXXX' Guillaume Gilbert Systems Specialist 514.866.8876 Office 514.866.0901 Fax 514.290.6526 BlackBerry [EMAIL PROTECTED] StorageTek Canada Inc. INFORMATION made POWERFUL -----Original Message----- From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] On Behalf Of Stapleton, Mark Sent: May 23, 2005 15:45 PM To: ADSM-L@VM.MARIST.EDU Subject: Re: query for mangement class From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] On Behalf Of Lawrence Clark >Does anyone have a query that shows the mangement class for each node? There is no one-to-one correspondence between a management class and a client node. Clients belong to domains, and each domain has a default management class; if no instructions are given otherwise, a client for a given node will use the default management class. However, use of include statements allows for use of non-default management classes within the node's domain. -- Mark Stapleton ([EMAIL PROTECTED]) IBM Certified Advanced Deployment Professional Tivoli Storage Management Solutions 2005 IBM Certified Advanced Technical Expert (CATE) AIX Office 262.521.5627