How to identify which management class the node assigned

[frankantony]

Hi All ,

We have lots of decommissioned servers. I need to know which management class the node is associated and their retention period. We are going to delete the old data. But we need what is their retention period. Please advise.

Thanks
Frank

 

[Ches]

From the TSM server:
select distinct(class_name) from backups where node_name='<yournodenamehere>'

Depending on your TSM DB, this query could take a while, I've heard - but for me it runs pretty quick.