AW: [ADSM-L] help with a select statement
2006-09-26 10:32:24
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
|
<Prev in Thread] |
Current Thread |
[Next in Thread>
|
- AW: [ADSM-L] help with a select statement,
Thomas Rupp <=
|
|
|