ADSM-L

Re: SQL Query Challenge

2004-03-18 15:43:47
Subject: Re: SQL Query Challenge
From: James Lepre <jlepre AT NECA DOT ORG>
To: ADSM-L AT VM.MARIST DOT EDU
Date: Thu, 18 Mar 2004 15:42:23 -0500
Jack, 

 You can try this 

Last nights Backup

select Entity,Successful,Bytes,Examined,Affected,Failed
  from summary
  where activity='BACKUP'
   and cast((current_timestamp-start_time)hours
   as decimal(8,0)) < 24
  order by Entity'

then after you run the backups again try this

what happened in the last hour

select servername,nodename,date_time
  from actlog
  where (cast((current_timestamp-date_time)hours as integer)>1)

<Prev in Thread] Current Thread [Next in Thread>