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 (skyl...@u.washington.edu)
-- Genome Sciences Department, System Administrator
-- Foege Building S046, (206)-685-7354
-- University of Washington School of Medicine
