Which MCs Are in Use?

[dhudson]

Hello,

How do I determine which management classes are actually being used?

Other than going round each and every client and reading the incl/excl file.

Thanks.

 

[rchoudarapu]

tsm: TSM_SERVER1>select * from backups
ANR2963W This SQL query may produce a very large result table, or may require a significant amount of time to compute.
Do you wish to proceed? (Yes (Y)/No (N))

Use this with caution... and with appropriate filters... this lists a huge table with one entry per file backed up... the fields are:

NODE_NAME:
FILESPACE_NAME:
FILESPACE_ID:
STATE:
TYPE:
HL_NAME:
LL_NAME:
OBJECT_ID:
BACKUP_DATE:
DEACTIVATE_DATE:
OWNER:
CLASS_NAME:

where the class_name is the MC the file is bound to...

 

[GregE]

Hello,

How do I determine which management classes are actually being used?

Other than going round each and every client and reading the incl/excl file.

Thanks.

I had the same question not long ago. Here's the thread.
http://adsm.org/forum/showthread.php?t=12684

 

[dhudson]

Hmm ok, pity that.

Thanks all.

 

[syntax44]

select node_name, count(*) as "Files" from backups where class_name = 'XXXX' and node_name -
in(select node_name from nodes where domain_name = 'XXXX') group by node_name

The related article (with how to create a script of it) can be found here:

Check if a combination of Management Class and Policy Domain has backup files associated with it:
http://tsmblog.org/kb/?View=entry&EntryID=68