CommServe DB query
==================
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'
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.