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:[EMAIL PROTECTED] On Behalf Of Robert Ouzen Sent: Sunday, February 27, 2005 2:20 AM To: [email protected] 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:[EMAIL PROTECTED] On Behalf Of Cain, Jason (Corporate) Sent: Sunday, February 27, 2005 8:57 AM To: [email protected] 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
