Hello everyone,

I am trying to create a select statement that will list all backups for clients 
in the domain: windows & hmig that started after yesterday at 6PM until today 
at the current date/time that had a status of: Missed, In Progress, Fail%, 
Started.

I tried the below select statement but it is not giving me everything that I am 
looking for and it's also reporting future events which I don't want.  Can 
anyone tell me what I'm doing wrong?

Thanks in advance!

select event as "Event",date(actual_start) as "Date",time(actual_start) as 
"Start",time(Completed) as "End", node_name, domain_name,Status from events 
where domain_name='WINDOWS' or domain_name='HMIG' and status like 'Fail%' or 
status='Missed' or status='In Progres' or status='Started' and 
actual_time>=current_timestamp-1 day


________________________________
This e-mail and any attachments to it are confidential and are intended solely 
for use of the individual or entity to whom they are addressed. If you have 
received this e-mail in error, please notify the sender immediately and then 
delete it. If you are not the intended recipient, you must not keep, use, 
disclose, copy or distribute this e-mail without the author's prior permission. 
The views expressed in this e-mail message do not necessarily represent the 
views of Highmark Inc., its subsidiaries, or affiliates.