Try:

select * from backups where node_name='XXX' and ll_name='file.name'

>>> nlames AT GUNDLUTH DOT ORG 10/09/02 11:17AM >>>
I need to find a specific file on tape, and the user does not know
where
the file was, nor when it disappeared - so basically I have to look at
all
the backups on a specific node to find its prior location. Anyone know
how
to do this?

Thanks -