Re: Filespace query

[Richard Sims]

SELECT Left(CHAR(BACKUP_END),19) as "LAST COMPLETE BACKUP", Char(NODE_NAME,10) 
as "NODE NAME", -
 Left(FILESPACE_NAME,25) as "FILESPACE NAME                     ", 
FILESPACE_TYPE as "FILE SYSTEM TYPE" -
 From FILESPACES  Where BACKUP_END is not null -
 and FILESPACE_NAME in ('SYSTEM OBJECT', 'SYSTEM SERVICES', 'SYSTEM STATE') -
  Order by "LAST COMPLETE BACKUP" Asc