This is what I came up with:

SELECT -
   f.node_name, -
   f.filespace_name, -
   f.backup_end, -
   CAST(ROUND(o.physical_mb/1024) as int) as "GB Stored" -
FROM -
   filespaces f, -
   occupancy o -
WHERE -
   o.node_name=f.node_name -
   AND o.filespace_name=f.filespace_name -
   AND ((o.type<>'Arch' AND f.backup_end IS NULL) -
      OR days(f.backup_end)<(days(current_date)-30)) -
ORDER BY o.physical_mb DESC


On Fri, Jan 29, 2016 at 03:43:24PM +0000, Rhodes, Richard L. wrote:
> If you get to a definitive sql statement, would love to see it!
>
> Rick

--
-- Skylar Thompson (skylar2 AT u.washington DOT edu)
-- Genome Sciences Department, System Administrator
-- Foege Building S046, (206)-685-7354
-- University of Washington School of Medicine