--> ... and know the client's password ...

This is not mandatory!
Every administrator with node owner (or system) authority can use
nodename/virtualnodename option authenticating to the server with
admin_id/admin_pwd instead of node_id/node_pwd. The wording from
Administrator's Reference, "GRAnt AUTHority" command:
"A user with client owner authority can access a web backup-archive client
through the web client interface and also access their data from another
client using the -NODENAME parameter"
This also helps avoid force-change of generated node's password. I've done
it many times myself.

Zlatko Krastev
IT Consultant






Richard Sims <rbs AT BU DOT EDU>
Sent by: "ADSM: Dist Stor Manager" <ADSM-L AT VM.MARIST DOT EDU>
03.01.2003 14:33
Please respond to "ADSM: Dist Stor Manager"


        To:     ADSM-L AT VM.MARIST DOT EDU
        cc:
        Subject:        Re: On which volumes are my files?


>Does anyone know a fast way to get a list of all volumes on which a node
>has files of a specific subdirectory? A query of the volumeusage table
>does the job on filespace level but not on file/directory level.
>The only way I know is to search in the output of query content or the
>corresponding select query which is very slow.

The Content query is the standard method - which has to wend its way
through the
whole file inventory to gather the limited information you need.
There is another, "creative" approach: Perform a client restore of that
subdirectory to a trash area, and then see what tapes were mounted.  :-)
If you have ready access to the same type of system as that client, and
know the
client's password, you can perform the restoral cross-node, and not
actually
have to use that client.  Restore doesn't have to go through the SQL
layers that
we have to when issuing server commands, and is certainly far faster.

  Richard Sims, BU

   "Think different."   - Apple