Does anyone have a select statement or know how to produce a grand total of 
data backed up on a per disk storage pool basis per day?


-----Original Message-----
From: ADSM: Dist Stor Manager [mailto:ADSM-L AT VM.MARIST DOT EDU]On Behalf Of
Mike Eggleston
Sent: Tuesday, June 01, 2004 2:37 PM
To: ADSM-L AT VM.MARIST DOT EDU
Subject: report of usage by file type?


With much patience from my TSM admin I have learned that the
dsmc command 'query backup' will generate a list of files. I
started to write the script on unix to query the database for
all nodes, but the server tells me the client is down-release
and so will not show me the node's files. I moved my scripts
to a windows node, but the dsmadmc command is not available on
the windows now.

Is there an easy way, and what is the command, to generate a
list of files stored in the tape library?

My goal is to generate justification to tighten the inclexcl.list
files to prevent things like *.mp3 files, etc.

Mike