I don't have one put together that does everything below but, here's one
that might help get you started and you could actually join it with the
occupancy table to get most everything else you are needing:

SELECT ENTITY AS NODE, -                         
   AVG(END_TIME-START_TIME) AS ELAPSED_TIME, -   
   CAST(SUM(BYTES/1024/1024) -                   
            AS DECIMAL(8,2)) AS "MB"  -          
FROM SUMMARY -                                   
WHERE ACTIVITY IN ('BACKUP','ARCHIVE') -         
   AND DAYS(CURRENT_TIMESTAMP)-DAYS(START_TIME)=1
   GROUP BY ENTITY -                             
   ORDER BY ELAPSED_TIME,MB       


The occupancy table will give you the nodename and filespace name as
well as the total number of files and total mb associated with the
filespace.  

If this doesn't get what you need, I can look deeper in my archives and
see what I have.

Good Luck!!
Cinda Mullen
Ascension Health ISD               

-----Original Message-----
From: Johnson, Reginald (IDS ECCS) [mailto:RegJohnson AT EXCHANGE.ML DOT COM] 
Sent: Wednesday, May 14, 2003 3:27 PM
To: ADSM-L AT VM.MARIST DOT EDU
Subject: Query select

Does anyone out there have a quick and dirty query that  will produce

Node Name  File system name  Number of Files  Date of Most Current
backup  MB of Most Current backup

I know that I can get most of this data from the filespaces table, but I
am trying to not query the backup table because it would never finish on
my server.
This info is for a Solaris client backing up to a MVS mainframe running
4.2.2.9

Reggie Johnson