Skip to main content
Solved

Commvault Database to see schedule policy assigned to a VM

  • Feb 14, 2024 5:50 PM UTC
  • 6 replies
  • 102 views

Forum|alt.badge.img+5

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.

Best answer by HolowEd

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

View original

6 replies

Onno van den Berg
Community All Star
Forum|alt.badge.img+24

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


Forum|alt.badge.img+5
  • Author
  • Apprentice
  • Feb 14, 2024 9:37 PM UTC

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+5
  • Author
  • Apprentice
  • Feb 19, 2024 2:57 PM UTC

Could someone please help me with above query


Forum|alt.badge.img+15
  • Vaulter
  • Feb 19, 2024 4:07 PM UTC

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+5
  • Author
  • Apprentice
  • Feb 19, 2024 4:24 PM UTC

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+15
  • Vaulter
  • Answer
  • Feb 19, 2024 6:05 PM UTC

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