select node_name, hl_name, ll_name, class_name from backups where
node_name in('NODE1','NODE2')  and ll_name like '%.MDB'


Note:
The backups table is the largest table you have; you will get much
better performance for this query if you do it for 1 nodename at a time,
because the table is indexed by node name:
   e.g.:  where node_name='NODE1'


The "%" is a wildcard for any number of characters.

The nodenames must be specified in upper case.
File ane path names must also be specified in upper case, for Windows
clients.

If you want to restrict the query further to just one directory, the
path is in hl_name, so you could add:
   and hl_name like '%JDOE%'

Wanda Prather
"I/O, I/O, It's all about I/O"  -(me)




-----Original Message-----
From: ADSM: Dist Stor Manager [mailto:ADSM-L AT VM.MARIST DOT EDU] On Behalf Of
JR Trimark
Sent: Friday, November 10, 2006 10:56 AM
To: ADSM-L AT VM.MARIST DOT EDU
Subject: JR- listof files/mgmt class used for a node from TSM admin
console

I can run the following command to list out what mgmt class was used for
files ending in mbd, how do I do this from the TSM admin console for
more
than 1 client?
q backup -detail -subdir=yes userdata:\home\jdoe\*.mdb
I am trying to confirm what mgmt class was used to backup the mdb files
since my clients use at least 2 mgmt class for files.
Thanks