This is something I was also looking for.
Normally I go to the client machine and query the backups to see the
history of a file.
>From what I can tell and I'm not very good at the "select" SQL
statements is the following a correct interpretation of the statement if
I was looking for a single files backups.
----------------------------------------------
Select * from backups where node_name='MOLSON" and
FILESPACE_NAME='\\MOLSON\C$' and HL_NAME='C:\DATA\' and ll_name like
'status.txt'
--------------------------------------
MOLSON - client node
FILESPACE_NAME - FILESPACE where file is located
HL_NAME - Directory where file is located
ll_name - actual file you are looking for

Thanks
Eric

-----Original Message-----
From: ADSM: Dist Stor Manager [mailto:ADSM-L AT VM.MARIST DOT EDU] On Behalf Of
Robert Ouzen
Sent: Sunday, February 27, 2005 2:20 AM
To: ADSM-L AT VM.MARIST DOT EDU
Subject: Re: How to display all versions of a file

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