You can do it this way from the server end - Select node_name,filespace_name, hl_name,ll_name,state, date(backup_date) from backups where node_name='XXXXXXXX' and state='ACTIVE_VERSION'
I prefer running it in comma-delimited mode: Dsmadmc -id=xxxxx -password=yyyyyy -commadelimited "selectstatementfrom above" That makes it easy to grep the output, or suck it into EXCEL (if there aren't too many files for excel).... (I don't recommend running that query without specifying the node name in the WHERE clause; the table can be quite large, but it's indexed on node_name.) -----Original Message----- From: Ted Byrne [mailto:[EMAIL PROTECTED]] Sent: Tuesday, February 18, 2003 5:10 PM To: [EMAIL PROTECTED] Subject: Q BA syntax on *nix Please feel free to point me to the documentation if I've overlooked something here, but I'm running into a brick wall... Client version 5.1.5.5 Client OS - AIX 5.1 ML 02 Server version 5.1.5.4 Server OS - AIX 5.1 ML 02 I've been asked to produce a list of all current files that are backed up on two particular AIX nodes. Based on the syntax described in the manual, when logged in as root, I enter the command q ba -subdir=y "/*" expecting to get a list of all files from the "/" directory on down. However, what I get appears to be all of the file in the "/" filespace. When I enter another FS name in place of the "/*" filespec, "/u06/*" for example, the files in that filesystem are displayed. Is there a way to display all files backed up using "q ba" without explicitly listing each FS by name in a separate command (for example with a macro)? Thanks, Ted
