You can use dsmc.
dsmc q backup -nodename=clientname '{\\clientname\d$}\.mp3' -subdir=yes 
>>c:\outputfilename




-----Original Message-----
From: Mike Eggleston [mailto:mikee AT MIKEE.ATH DOT CX]
Sent: Tuesday, June 01, 2004 12: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