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".
|