Re: [ADSM-L] Filespace query
2010-03-10 09:36:49
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
|
|
|