select
filespaces.node_name,filespaces.filespace_name,date(filespaces.backup_end)as
"Last Backup" from -
filespaces where (($1 < -
days(current_timestamp) - days(backup_end)) or -
backup_end is null) and filespaces.node_name in (select nodes.node_name
from nodes where domain_name=upper('$2'))$1 is how many days since and $2 is the domain, but the basic select is there.
At 02:42 PM 8/27/2003 -0500, you wrote:
Still doesn't work:
tsm: XXXXXX>select node_name as "Hostname", filespace_name as "Filespace", date(backup_end) as "Last completed backup" from filespaces where backup_end<current_timestamp-1 day or backup_end is null order by backup_end
ANR2964E The reference 'BACKUP_END' is not a column of the SQL result table.
.....................................................V......... rrent_timestamp-1 day or backup_end is null order by backup_end
ANS8001I Return code 3.
If I replace ALL references of backup_end with data(backup_end) it doesn't work either and gives the following error:
ANR2904E Unexpected SQL key word token - 'DATE'.
I go through the script, no matter what backup_end's are replaced with date(backup_end), I can't get it to work.
Any other ideas?
Thanks!
Alex
On Wed, 27 Aug 2003, Fred Johanson wrote:
> Try ...date(backup_end) as ... > > > At 02:21 PM 8/27/2003 -0500, you wrote: > >I've got a tsm script which works fine, but I only want the date from > >backup_end table, not the time. Anyone know how to get the date only from > >backup_end? The time on it is not needed and adds to much clutter to the > >email. I can do it in perl, but there must be some way to do it in sql, > >which I prefer. Statement is below: > > > >select node_name as "Hostname", filespace_name as "Filespace", backup_end > >as "Last completed backup" from filespaces where > >backup_end<current_timestamp-1 day or backup_end is null order by > >backup_end > > > >Thanks in advance, > > > >Alex > >--- --- > > Alex Lazarevich | Systems Administrator | Imaging Technology Group > > Beckman Institute - University of Illinois > > [EMAIL PROTECTED] | (217)244-1565 | www.itg.uiuc.edu > >--- --- >
