select * from adsm.backups where
     (cast((current_timestamp-backup_date)day as decimal(18,0))<2)

     This should give you a real loooong list of everything from the last
     24-48 hrs depending on what time you run it...

     add a
        and node_name='WXYZ'
     on the end if you desire

     later,
           Dwight


______________________________ Reply Separator
_________________________________
Subject: Determining what has been backed up
Author:  anthony.doig (anthony.doig AT OPENTECH.CO DOT NZ) at unix,mime
Date:    3/16/99 9:56 PM


G'day,

[ potentially dumb question - I've poked around myself but cannot find the
answer ]

I would like to determine what files and directories were backed up for a
particular client backup session.  I can run the "query actlog
originator=client ..." command and get detailed statistics on backup
sessions, but I want to know what files were processed by each client
session.  I could run a SQL query to find what was backed up for a
particular
session/node between the start/end times for each client session, but this
would not work if a client has multiple sessions running ...

Is this possible at the server end, or would I need to go and look at log
files at the client ??  I would rather handle it all at the server.

The client session could be started either via the ADSM scheduler or
externaly/manually from the client end.

I'm using an ADSM v3.1.1.0 server on HP/UX 10.20 and an ADSM v3.1.0.3 server
on NT v4.0 (NT/UNIX clients).

Cheers and thanks in advance,

Anthony
--
Anthony Doig
Anthony Doig
Professional Services Consultant
Open Technology Ltd
Wellington, New Zealand

Phone :+64 4 385 2969
Fax   :+64 4 385 7764
Mobile:+64 21 632 062
mailto:anthony AT opentech.co DOT nz
http://www.opentech.co.nz