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.
