CommServe DB query
WHERE jobstatus = 'Failed to Start'
and backuplevel = 'Synthetic Full'
and iDataAgent = 'Virtual Server'
order by jobid desc ;
I was this list to contain only the jobs from last 24 hours, how to add the time range in this sql query.
Best answer by Jos MeijerView original
Would this report help you?
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?
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.
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
something like this?
Jos, Meier you might know this.
What’s the simplest way to achieve conditional and statements in a query.
google fails me.