Re: SQL Query Challenge

[James Lepre]

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)