Eric,

 I'm a little green at SQL myself, but this should work for you.  NOTE: The
 'ORDER BY' used with 'DESC' will sort the specified column in
descending order.

adsm> select physical_mb,filespace_name from occupancy where
node_name='FJCROGE.W95' order by physical_mb desc

 PHYSICAL_MB     FILESPACE_NAME
------------     ------------------
      465.61     \\production\c$
      465.61     \\production\c$
        4.48     \\production\c$

adsm>

Regards,
Cole Rogers




"Loon, E.J. van - SPLXM" <Eric-van.Loon AT KLM DOT NL> on 12/23/99 07:05:18 AM

Please respond to "ADSM: Dist Stor Manager" <ADSM-L AT VM.MARIST DOT EDU>



 To:      ADSM-L AT VM.MARIST DOT EDU

 cc:      (bcc: Cole C Rogers/SAC/HN/FHS)



 Subject: Looking for query for usage per filespace







Hi *SM-ers!
I'm trying to create an SQL query to see which filespace is responsible for
generating a lot of backup data for a specific node.
I have tried the following query:

SELECT OCCUPANCY.PHYSICAL_MB, OCCUPANCY.FILESPACE_NAME FROM OCCUPANCY
OCCUPANCY WHERE (OCCUPANCY.NODE_NAME='OD0')

When I execute this query it returns all filespaces at least twice, some of
them even multiple times. I'm not an SQL expert, so I don't even know if
the
query is correct for what I'm trying to accomplish.
Can somebody please help me with creating the correct query?
Thank you very much in advance!!
Kindest regards,
Eric van Loon