Re: How to list files backed up

>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:Curtis.Stewart AT GOODRICH DOT COM]
Sent: Friday, August 30, 2002 9:51 AM
To: ADSM-L AT VM.MARIST DOT EDU
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:Ricky.Cahill AT EQUITAS.CO DOT UK]
Sent: Friday, August 30, 2002 2:53 AM
To: ADSM-L AT VM.MARIST DOT EDU
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
postmaster AT equitas.co DOT uk 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
****************************************************************************
************************