Run
 
select * from drives
 
--
Mark Stapleton

        -----Original Message----- 
        From: David E Ehresman [mailto:deehre01 AT LOUISVILLE DOT EDU] 
        Sent: Fri 8/1/2003 8:13 AM 
        To: ADSM-L AT VM.MARIST DOT EDU 
        Cc: 
        Subject: sql for available drives?
        
        

        In tsm v5 where path and drive status are stored seperately, can anyone
        help with a sql query that would return the number of drives that are
        EMPTY and where the drive is online and the path to the drive is
        online.
        
        Thanks,
        David