And the same stuff with a SELECT:

Dsmadmc -id=adminid -password=adminpwd -commadelimited "select
node_name,filespace_name,state,type,hl_name,ll_name,backup_date from backups
where node_name='XXXXXX' " >output.file

Repeat with "from archives".

DON"T try this on the entire backups table if you have a large DB!  The
backups table is indexed by node_name, so it works pretty well for 1 node at
a time...

-----Original Message-----
From: Doug Thorneycroft [mailto:dthorneycroft AT LACSD DOT ORG]
Sent: Thursday, January 30, 2003 1:39 PM
To: ADSM-L AT VM.MARIST DOT EDU
Subject: Re: Complete list of *ALL* files in BACKUP/ARCHIVE


In Window, you can issue the following command from the command Prompt to
send
the list to a text file.
dsmc q backup -nodename=<NODE> '{\\Filespace_name}\*.*' -subdir=yes
-inactive
>filename.txt


-----Original Message-----
From:   Zoltan Forray/AC/VCU [SMTP:zforray AT VCU DOT EDU]
Sent:   Thursday, January 30, 2003 10:04 AM
To:     ADSM-L AT VM.MARIST DOT EDU
Subject:        Complete list of *ALL* files in BACKUP/ARCHIVE

What is the easiest/best way/command to get a complete list of *ALL* files
in BACKUP/ARCHIVEs for a NODE ?

We want to generate this list so we can store it for later browsing, if
necessary.

The reason for this is that I am about to do an import for a node that was
exported and deleted, just because the user thinks there is a file in the
archives that they need.   It would have been nice to simply browse a file
and say "nope, the file you want wasn't on that box and there isn't a
backup/archive for it".