The ARCHIVES and BACKUPS tables have a column CLASS_NAME. So you could do

"SELECT * FROM ARCHIVES WHERE CLASS_NAME='<your class>'"
"SELECT * FROM BACKUPS WHERE CLASS_NAME='<your class>'"

these queries may run for some time so it might be better to include a WHERE
clause for NODE_NAME such as WHERE NODE_NAME IN ('xxx', 'yyy', 'zzz') for
all the nodes in that domain.

From: Susan Wright <S.Wright AT LABSAFETY DOT COM>
Reply-To: "ADSM: Dist Stor Manager" <ADSM-L AT VM.MARIST DOT EDU>
To: ADSM-L AT VM.MARIST DOT EDU
Subject: Any way to see which files are associated to a certain Mgt class?
            ?
Date: Tue, 19 Sep 2000 12:55:48 -0500

I have a management class that was created a while ago and we are cleaning
up things and before we remove this class we want to make sure that there
are no files associated to this class. Is there a way in which to see what
files, if any, there are backed up to this mgt class??

AIX 4.3.3
ADSM 3.1.2.50

TIA

Susan Wright
Operations Specialist
Lab Safety Supply, Wisconsin
S.Wright AT LabSafety DOT com
12:00 pm - 8:30 pm CST.

_________________________________________________________________________
Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com.

Share information about yourself, create your own public profile at
http://profiles.msn.com.