>From the server, this may be useful: select filespace_name, hl_name, ll_name from backups where node_name='YOUR-NODE' and type=file and state=active_version and backup_date >current_timestamp-1 day
This one actually runs pretty fast because the node_name, type, and state columns are indexed. Paul D. Seay, Jr. Technical Specialist Naptheon Inc. 757-688-8180 -----Original Message----- From: Stewart, Curtis [mailto:[EMAIL PROTECTED]] Sent: Friday, August 30, 2002 9:51 AM To: [EMAIL PROTECTED] Subject: Re: How to list files backed up Look in the log files. On my servers it's dsmsched.log. Here's a snippet of one of mine. 07/30/2002 20:09:09 Normal File--> 6,956 USERS:/USERS/username/2017A/2017a-1/5c913c10._gr [Sent] 07/30/2002 20:09:09 Normal File--> 529 USERS:/USERS/username/2017A/2017a-1/5c913c10._hl [Sent] 07/30/2002 20:09:09 Normal File--> 21,766 USERS:/USERS/username/2017A/2017a-1/5c913c10._is [Sent] 07/30/2002 20:09:09 Normal File--> 2,878 USERS:/USERS/username/2017A/2017a-1/5c913c10._pf [Sent] 07/30/2002 20:09:09 Normal File--> 4,621 USERS:/USERS/username/2017A/2017a-1/63f52efb._df [Sent] 07/30/2002 20:09:09 Normal File--> 6,226 USERS:/USERS/username/2017A/2017a-1/63f52efb._gr [Sent] Cheers curtis stewart -----Original Message----- From: Cahill, Ricky [mailto:[EMAIL PROTECTED]] Sent: Friday, August 30, 2002 2:53 AM To: [EMAIL PROTECTED] Subject: How to list files backed up I must be missed something really obvious as all I want to do is list all the files that were backed up by a node in it's last backup, but can't seem to find any simple way to do this. Heeeeeelp Thanks in advance ..........Rikk **************************************************************************** ************************ Equitas Limited, 33 St Mary Axe, London EC3A 8LL, UK NOTICE: This message is intended only for use by the named addressee and may contain privileged and/or confidential information. If you are not the named addressee you should not disseminate, copy or take any action in reliance on it. If you have received this message in error please notify [EMAIL PROTECTED] and delete the message and any attachments accompanying it immediately. Equitas reserve the right to monitor and/or record emails, (including the contents thereof) sent and received via its network for any lawful business purpose to the extent permitted by applicable law Registered in England: Registered no. 3173352 Registered address above **************************************************************************** ************************
