OpsCenter sql don't have a successful backup in the last 24 hours

Hi all.

I'm hoping for some help with this sql query, am I missing some logic in the report I want.

What I want is a report of all servers there don't have a successful backup in the last 24 hours, if a backup job failed and then completed successful it must not occur in the report

Information i need

• Master Server
• Client Name
• Policy Name
• Status Code