>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
