Tom,

Try:

select  filespace_name,file_name  from  contents  where  node_name  =
'YOUR_NODE_NAME'

Note that the SQL literals ( the node name) must be upper case and enclosed with
 single quotes.

This query can take a while. Don't be in a hurry.  For one small server on our 2
x 332 MHz system, it took 15 minutes to return the list.

Good luck.

Tab







"Berning, Tom" <TBerning AT SENCO DOT COM> on 02/03/2000 12:20:01 PM

Please respond to "ADSM: Dist Stor Manager" <ADSM-L AT VM.MARIST DOT EDU>

To:   ADSM-L AT VM.MARIST DOT EDU
cc:    (bcc: Tab Trepagnier/Corporation/Laitram/US)
Subject:  Audit of files backed up for a particular node




Does anyone know of a way to list out all of the files that were backed up
for a particular node?

My boss would like to be able to print out all of the files and have someone
audit this list against what is actual on the system.

Thomas R. Berning
UNIX Systems Administrator III
Senco Products, Inc.
8485 Broadwell Road
Cincinnati, OH. 45244
Phone         513-388-2857
Email          tberning AT senco DOT com