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:[EMAIL PROTECTED]] Sent: Thursday, January 30, 2003 1:39 PM To: [EMAIL PROTECTED] 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:[EMAIL PROTECTED]] Sent: Thursday, January 30, 2003 10:04 AM To: [EMAIL PROTECTED] 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".
