Jason

Here maco to view the active and inactive files for a specific Client and 
filespace in a directory with a certain syntax .....

select * from backups where node_name='$1' and FILESPACE_NAME='$2' and 
HL_NAME='$3' and ll_name like '%%$4%%'

/*  Nodename   $1  DRM_HAIFA-MINHAL */
/*  Filespace  $2  NWMINHAL\DATA:   */
/*  Directory  $3  /HUMANRES/RLUBI/ */
/*  Files      $4  .ADSM            */   

Regards Robert Ouzen
Haifa University
Israel

-----Original Message-----
From: ADSM: Dist Stor Manager [mailto:ADSM-L AT VM.MARIST DOT EDU] On Behalf Of 
Cain, Jason (Corporate)
Sent: Sunday, February 27, 2005 8:57 AM
To: ADSM-L AT VM.MARIST DOT EDU
Subject: How to display all versions of a file

Does anyone know how to display the current active, and inactive versions of a 
file via command line(SQL)?

Our auditors want to see all versions that we specify in our management class, 
on a per file basis.

Thanks
Jason