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:[EMAIL PROTECTED] Im Auftrag von Whitlock, Brett Gesendet: Dienstag, 26. September 2006 15:29 An: ADSM-L@VM.MARIST.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