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
guillaume_gilbert AT storagetek DOT com
StorageTek Canada Inc.
INFORMATION made POWERFUL 



-----Original Message-----
From: ADSM: Dist Stor Manager [mailto:ADSM-L AT VM.MARIST DOT EDU] On Behalf Of
Stapleton, Mark
Sent: May 23, 2005 15:45 PM
To: ADSM-L AT VM.MARIST DOT EDU
Subject: Re: query for mangement class


From: ADSM: Dist Stor Manager [mailto:ADSM-L AT VM.MARIST DOT EDU] 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 (stapleton AT berbee DOT com)
IBM Certified Advanced Deployment Professional
  Tivoli Storage Management Solutions 2005
IBM Certified Advanced Technical Expert (CATE) AIX
Office 262.521.5627