Can't you just see this information from the job history based on job id lookup? 

Hi Onno,

We have a workflow to fetch job history based on the start date and end date selected by user for n number of servers at once and we are using sql query to get the details in tabular format by querying into ComcellBackupInfo DB where job id is list of jobids.

Could someone please help me with above query

Rahul,

The information you are looking for can be found in either of the following views CommCellBkSchedule or CommCellBkScheduleForSubclients. You can find by the schedule used querying the clientname.

Reqards,

Edward J Holowienka

Hi Edward,

I am looking to identify the schedule policy of a VM client which is a VSA client. is there any option wherein i can just give VM Name and it shows the subclient name of that VM and then the schedule policy.

You would need to know which subclient from the vcenter that the VM is backed up under. Then query the table CommCellBkScheduleForSubclients  for the vcenter client and then look for the subclient in order to find the schedule.

Regards,

Edward J Holowienka