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 <[EMAIL PROTECTED]>
>Reply-To: "ADSM: Dist Stor Manager" <[EMAIL PROTECTED]>
>To: [EMAIL PROTECTED]
>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
>[EMAIL PROTECTED]
>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.

Reply via email to