Re: SQL statement to list fs not backed up sorted on size

2014-03-18 Thread Ronald Le Large
U] On Behalf Of Loon, EJ van (SPLXM) - KLM Sent: Monday, March 17, 2014 5:35 PM To: ADSM-L@VM.MARIST.EDU Subject: Re: [ADSM-L] SQL statement to list fs not backed up sorted on size Hi Skylar! Thank you very much for your help! The end result looks like this, just so it's available for others in

Re: SQL statement to list fs not backed up sorted on size

2014-03-17 Thread Loon, EJ van (SPLXM) - KLM
Hi Skylar! Thank you very much for your help! The end result looks like this, just so it's available for others in the ADSM-L archives: SELECT f.node_name as "Node Name",f.filespace_name as "Filespace Name",o.physical_mb as "MB Stored",date(f.backup_end) as "Last Backup Date" FROM filespaces f, oc