On Aug 13, 2008, at 8:53 AM, Tim Brown wrote:

Is it possible to query TSM with a select statement that will detail
out
a particular
filespace. If so does any one have one.

Say a filespace \\NODE1\D$ for node NODE1. This particular drive has 5
folders
Can TSM show the percentage of storage for each or the number of files
active or inactive.

Whereas the sizes of stored files cannot generally be determined from
TSM server queries, a storage percentage report is not doable.

Active/Inactive state is recorded by object, in the Backups and
Archives tables, meaning that a costly scan would have to be run.  I
would not approach doing that unless there was a serious need for such
a report, given what it does to the server and database.

  Richard Sims