which nodes using a copyclass

[citecedp]

Hi,

Does anyone know how I can find out which nodes are using a particular management or copy class?

I tried:
select distinct NODE_NAME from backups where CLASS_NAME = 'MSSQL'
but gave up after an hour and a half.

Thanks

 

[hucha]

I don't know the size of your TSM db but try narrowing down your selection by splitting things up maybe per Domain or date, like only in last night backups first

 

[mateinone]

The easiest way is to run a script with each node. Then you can just do a select statement on each node in a loop on the backup table.

Depending on just how big your database is, it should finish within a couple of minutes