ADSM-L

Re: Trying to get a list of *ALL* files in BACKUP/ARCHIVE

2003-01-30 18:34:19
Subject: Re: Trying to get a list of *ALL* files in BACKUP/ARCHIVE
From: Andrew Raibeck <storman AT US.IBM DOT COM>
To: ADSM-L AT VM.MARIST DOT EDU
Date: Thu, 30 Jan 2003 16:32:03 -0700
Get rid of the curly braces.

   q backup \\0633\c$\ -fromdate=01/27/2003

If you want to see all files, not just those in the root, you'll need the
-subdir=yes option, i.e.:

   q backup \\0633\c$\ -fromdate=01/27/2003 -subdir=yes

Note that you don't need the '*' or '*.*' at the end of the file spec.

Regards,

Andy

Andy Raibeck
IBM Software Group
Tivoli Storage Manager Client Development
Internal Notes e-mail: Andrew Raibeck/Tucson/IBM@IBMUS
Internet e-mail: storman AT us.eyebm DOT com (change eye to i to reply)

The only dumb question is the one that goes unasked.
The command line is your friend.
"Good enough" is the enemy of excellence.




Ron Lochhead <RLochhead AT CSE-INSURANCE DOT COM>
Sent by: "ADSM: Dist Stor Manager" <ADSM-L AT VM.MARIST DOT EDU>
01/30/2003 16:06
Please respond to "ADSM: Dist Stor Manager"


        To:     ADSM-L AT VM.MARIST DOT EDU
        cc:
        Subject:        Trying to get a list of *ALL* files in BACKUP/ARCHIVE



When I attempted to use the command line within TSM, I got the following
error:

\tsm> q backup {"\\0633\C$"}\*.*  -fromdate=01/27/2003
ANS1081E Invalid search file specification '{\\0633\C$' entered

I was trying to get a listing of all my files for a particular node using
the filespace which is located on an NT4 drive.  TSM server running Win2k
using TSM 5.11.
Does anyone know what I am entering in wrong?
Thanks.




                    "Prather, Wanda"
                    <Wanda.Prather@J        To:     ADSM-L AT VM.MARIST DOT EDU
                    HUAPL.EDU>              cc:
                    Sent by: "ADSM:         Subject:     Re: Complete list
of *ALL* files in BACKUP/ARCHIVE
                    Dist Stor
                    Manager"
                    <[email protected]
                    T.EDU>


                    01/30/2003 11:32
                    AM
                    Please respond
                    to "ADSM: Dist
                    Stor Manager"





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

<Prev in Thread] Current Thread [Next in Thread>
  • Re: Trying to get a list of *ALL* files in BACKUP/ARCHIVE, Andrew Raibeck <=