select node_name, count(*) as "#of files", class_name from backups where 
node_name='x' group by node_name, class_name

should give you a list like:

NODE_NAME                #of files     CLASS_NAME        
------------------     -----------     ------------------
x                             31479     DEFAULT           
x                              3009     DIRECTORIES       
x                              2233     SYSTEM  

HTH
Thomas Rupp

-----Ursprüngliche Nachricht-----
Von: ADSM: Dist Stor Manager [mailto:ADSM-L AT VM.MARIST DOT EDU] Im Auftrag 
von Whitlock, Brett
Gesendet: Dienstag, 26. September 2006 15:29
An: ADSM-L AT VM.MARIST DOT EDU
Betreff: [ADSM-L] help with a select statement


Has someone got a handy dandy select statement that will give me client
names and the number of backup and archive files by management class?
 
Thanks 
 
Brett