Hi Gerhard, I was not paying as close attention as I should to what I was typing. You are correct.
Thanks for catching this. :-) Andy Andy Raibeck IBM Software Group Tivoli Storage Manager Client Development Internal Notes e-mail: Andrew Raibeck/Tucson/[EMAIL PROTECTED] Internet e-mail: [EMAIL PROTECTED] The only dumb question is the one that goes unasked. The command line is your friend. "Good enough" is the enemy of excellence. "ADSM: Dist Stor Manager" <[email protected]> wrote on 2005-03-01 00:27:36: > Andrew Raibeck wrote: > > > Hi Eric, > > > > For your example, \\MOLSON\C$\DATA\status.txt, the correct criteria would > > be: > > > > filespace_name='\\MOLSON\C$' and > > hl_name='\DATA\' and > > ll_name='STATUS.TXT' > > > > For Windows, note that: > > > > - All components are stored in upper case, regardless of how they appear > > on the client machine. > > Hmm, my filespace_names are in lower case: > Node Name Filespace FSID Platform Filespace > Name Type > --------------- ----------- ---- -------- --------- > CC.AMSEL \\amsel\c$ 1 WinNT NTFS > > > > > - The hl_name begins and ends with a backslash (unless it is the drive > > root, in which case there is only one backslash). > > > > - When you concatenate filespace_name, hl_name, and ll_name, they should > > form a proper path. > > > > Regards, > > > > Andy > > > > P.S. Suggestion: Selecting from the BACKUPS table can take a very long > > time. If you plan to do a lot of data mining from it, consider selecting > > all output from the table and redirecting to a file (make sure you have > > tons of free disk space), then use an external tool to mine the data. > > > > Andy Raibeck > > IBM Software Group > > Tivoli Storage Manager Client Development > > Internal Notes e-mail: Andrew Raibeck/Tucson/[EMAIL PROTECTED] > > Internet e-mail: [EMAIL PROTECTED] > > > > The only dumb question is the one that goes unasked. > > The command line is your friend. > > "Good enough" is the enemy of excellence. > > > > "ADSM: Dist Stor Manager" <[email protected]> wrote on 2005-02-27 > > 17:54:07: > > > > > >>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 > > -- > _____________________________________ > eMail: [EMAIL PROTECTED] > tel: +43 1 40160-21209 > IT Systems & Communications (ITSC) > Medizinische Universitaet Wien > Spitalgasse 23, A-1090 WIEN
