select 'THEWANTEDCLASS' from db where exists (select 1 from backups where
class_name='THEWANTEDCLASS')
or
select CLASS_NAME,count(*) from backups group by CLASS_NAME

Be careful, the former is fast and the latter is putting heavy burden on
the server. Instead of running the latter in attempt to get the picture of
all classes, just do it one-by-one.

Zlatko Krastev
IT Consultant






Matthew Large <Matthew.Large AT AVIVA DOT COM>
Sent by: "ADSM: Dist Stor Manager" <ADSM-L AT VM.MARIST DOT EDU>
27.06.2005 18:17
Please respond to "ADSM: Dist Stor Manager"

        To:     ADSM-L AT VM.MARIST DOT EDU
        cc:     (bcc: ADSM-L/ACIT)
        Subject:        [ADSM-L] Backups using copygroup?


Hi Team,

I'm looking for a select statement which asks 'have any files used <this>
copygroup to determine the retention period?'

Is this possible?

Many Thanks,
Matthew



Aviva plc
Registered Office: St. Helen's, 1 Undershaft, London EC3P 3DQ
Registered in England Number 02468686
www.aviva.com

This message and any attachments are confidential.
If you are not the intended recipient, please telephone
or e-mail the sender and delete this message and any
attachment from your system. Also, if you are not the
intended recipient you must not copy this message or
attachment or disclose the contents to any other person.