Skip to main content

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.

 


 

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?


@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.


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 


something like this?

 

CASE
WHEN condition_1 AND condition_2 THEN result_1
ELSE result_2
END

 


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

google fails me.


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 ;

 


Reply