A TSM admin can look for it by doing a SELECT on the BACKUPS table. I think this will work:
>select hl_name, ll_name from backups where node_name='NODENAME' and ll_name like '%XXXX%' where XXXX are the chars in the name you are looking for. Remember that the XXXX should be mixed case for *IX clients, upper case for Windoze clients. HOWEVER, this query can take a LONG time if your DB is large. For us, it's faster and easier to use the BA client FIND capability, if we have access to the client. * Start the GUI * select RESTORE. * From the MENU bar pull down EDIT, FIND. There is a Windows-like FIND capability, you can look for all files starting or ending or containing characters you specify. You can also filter by size or date. (I think you have to be at least a 3.7 client for this to work). ************************************************************************ Wanda Prather The Johns Hopkins Applied Physics Lab 443-778-8769 [EMAIL PROTECTED] "Intelligence has much less practical application than you'd think" - Scott Adams/Dilbert ************************************************************************ -----Original Message----- From: Mark Hayden [mailto:[EMAIL PROTECTED]] Sent: Thursday, November 01, 2001 2:30 PM To: [EMAIL PROTECTED] Subject: Question I am trying to locate a file that was backed up. The file is not in the directory that was told to me....I would like to try and see if it's in the DB. IS there a way from the command line to query a file name for a node????? Thanks, Mark Hayden Network Administrator E-Mail: [EMAIL PROTECTED]
