I can give a couple of examples pretty quickly, but they almost certainly
will not run quickly:

   select distinct class_name
      from backups
      where node_name='YOURNODENAMEGOESHERE'

or, to get info for all nodes:

   select distinct node_name, class_name
      from backups

You can also run the same SQL statements for the ARCHIVES and SPACEMGFILES
tables if you use the archive or HSM functions of TSM.

If you have multiple policy domains, you'll need to know which domain
these are in. Alternatively, you can try something like this:

   select distinct a.node_name, domain_name, class_name
      from backups a, nodes b
      where a.node_name=b.node_name

Note that I have not tested the latter thoroughly to know for sure that it
works, but I'm pretty sure it will work. Just be prepared to wait a while
(probably hours).

Regards,

Andy

Andy Raibeck
IBM Software Group
Tivoli Storage Manager Client Development
Internal Notes e-mail: Andrew Raibeck/Tucson/IBM@IBMUS
Internet e-mail: storman AT us.ibm DOT com

The only dumb question is the one that goes unasked.
The command line is your friend.
"Good enough" is the enemy of excellence.

"ADSM: Dist Stor Manager" <ADSM-L AT VM.MARIST DOT EDU> wrote on 06/28/2004
12:58:06:

> Does anyone have a quick select statement that will give me all of the
> management clases that a particular node uses?  thx.