Re: [ADSM-L] SQL statement

You could do that but the query does not fail for filespaces with a
BACKUP_END of null it just lists a blank value for DAYS_SINCE_BACKUP

On 1/28/2016 10:46 AM, Erwann SIMON wrote:

Hi Eric,

You maybe should add a condition if backup_end is null


--
William Sefranek
University of Buffalo
Enterprise Infrastructure Services
(716)645-5116

<Prev in Thread]	Current Thread	[Next in Thread>
Re: [ADSM-L] SQL statement, (continued) Re: [ADSM-L] SQL statement, Skylar Thompson Re: [ADSM-L] SQL statement, William Sefranek Re: [ADSM-L] SQL statement, Loon, EJ van (ITOPT3) - KLM Re: [ADSM-L] SQL statement, King, Harold Clyde (Hal) Re: [ADSM-L] SQL statement, Skylar Thompson Re: [ADSM-L] SQL statement, Michael Hedden Re: [ADSM-L] SQL statement, Loon, EJ van (ITOPT3) - KLM Re: [ADSM-L] SQL statement, Erwann SIMON Re: [ADSM-L] SQL statement, Skylar Thompson Re: [ADSM-L] SQL statement, Loon, EJ van (ITOPT3) - KLM Re: [ADSM-L] SQL statement, William Sefranek <= Re: [ADSM-L] SQL statement, Loon, EJ van (ITOPT3) - KLM Re: [ADSM-L] SQL statement, Skylar Thompson Re: [ADSM-L] SQL statement, Rhodes, Richard L. Re: [ADSM-L] SQL statement, Skylar Thompson Re: [ADSM-L] SQL statement, Erwann SIMON

Previous by Date:	Re: [ADSM-L] Upgrade server from 6.3 to 7.1, Lee, Gary
Next by Date:	Re: [ADSM-L] When can too many disk volumes be detrimental, Zoltan Forray
Previous by Thread:	Re: [ADSM-L] SQL statement, Loon, EJ van (ITOPT3) - KLM
Next by Thread:	Re: [ADSM-L] SQL statement, Loon, EJ van (ITOPT3) - KLM
Indexes:	[Date] [Thread] [Top] [All Lists]