Skip to main content
Question

Commvault Database to see schedule policy assigned to a VM

  • 14 February 2024
  • 6 replies
  • 61 views

Forum|alt.badge.img+6

Hi Team,

 

I want to see schedule policy which is assigned or which ran for a VM backup job. From ComcellBackupInfo, i am able to get all the details related to Backup job but only schedule name is not available. Is there any other databse or table using which we can fetch this information.

6 replies

Onno van den Berg
Commvault Certified Expert
Forum|alt.badge.img+19
  • Commvault Certified Expert
  • 1192 replies
  • February 14, 2024

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


Forum|alt.badge.img+6
  • Author
  • Byte
  • 30 replies
  • February 14, 2024

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.

 

 


Forum|alt.badge.img+6
  • Author
  • Byte
  • 30 replies
  • February 19, 2024

Could someone please help me with above query


Forum|alt.badge.img+12
  • Vaulter
  • 173 replies
  • February 19, 2024

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


Forum|alt.badge.img+6
  • Author
  • Byte
  • 30 replies
  • February 19, 2024

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.


Forum|alt.badge.img+12
  • Vaulter
  • 173 replies
  • February 19, 2024

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


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings