You can select from the BACKUPS table. One of the columns is "filespace_name", so you can restrict your queries to just the files you are interested in. E.G., select hl_name, ll_name, state, date(backup_date) from backups where node_name='XXXXXXX' and filespace_name <> 'SYSTEM OBJECT'
The BACKUPS table can be VERY LARGE and queries against it can run a VERY LONG TIME if your DB is large or your server is slow. It usually works pretty well for me when restricted to a single node name as in the example above, because the table is indexed on NODE_NAME. Wanda Prather Johns Hopkins University Applied Physics Laboratory 443-778-8769 "Intelligence has much less practical application than you'd think" - Dilbert/Scott Adams -----Original Message----- From: Greg Graves [mailto:[EMAIL PROTECTED] Sent: Tuesday, June 03, 2003 11:06 AM To: [EMAIL PROTECTED] Subject: Query contents of a filespace? Quick question: Is there a way to query the contents of a node's filespace? I want to see what data a particular node has backed up.. -- ********************************************************** Greg Graves Wesley Chapel, FL Phone: 813-973-2038 [EMAIL PROTECTED] Fax: 586-283-7144 **********************************************************
