SELECT startdate
   ,clientname
   ,idataagent
   ,instance
   ,backupset
   ,subclient
   ,backuplevel
   ,jobstatus
   ,jobid
FROM CommcellBackupInfo
WHERE jobstatus = 'Failed to Start'
and backuplevel = 'Synthetic Full'
and iDataAgent = 'Virtual Server'
and startdate >= DATEADD(day, -1, GETDATE())
order by jobid desc ;

Jos, Meier you might know this. 
What’s the simplest way to achieve conditional and statements in a query.

google fails me.

something like this?

CASE
WHEN condition_1 AND condition_2 THEN result_1
ELSE result_2
END

Honestly I have to try it to be sure.

i want to use a check box to modify a where clause in a workflow.

even if it doesnt work this gives me a good idea what to try next. Thanks @Jos Meijer 

@Jos Meijer Hi is there a way to get the list of repeated failures in a report or query.

I tried to prepare a report in the report builder, but failing to achieve it :(

So i just want a list of client for which backups are failing repeatedly for more than 2 days.

Hi @alligator 

Would this report help you?
https://cloud.commvault.com/webconsole/softwarestore/store.do#!/135/660/10390

This will show you how many strikes a client/subclient has, since when this is happening and when the last strike was registered.

Or are you looking for specific information?