Querying the CommServe Database

You can run SQL queries on CommServe Database to verify the virtual machine protection coverage:

Backups Performed for Each Virtual Machine

You can run a SQL query on CommServe Database to verify the status of backups performed for each virtual machine in last <n> days. When you schedule backups for a subclient, it is recommended to run this query periodically to check whether all the virtual machines are getting backed up as per schedule.

Follow the steps given below to run the query:

1. Log on to the CommServe computer. Ensure that the user account used for logging in has administrative privileges.

2. Open the Microsoft SQL Server Management Studio and run the following query on the CommServe database:

   select * from VMProtectionCoverage (n, 'backup type'])

   Here <n> - The number of days

   <backup type> - The type of backup

   For example: select * from VMProtectionCoverage (30, 'Incr')
   

   This query will provide the status of incremental backups performed for each virtual machine protected in last 30 days. The query will be executed for all the virtual machines protected by any Virtual Server iDataAgent within the CommCell.

   If you want to verify the status of all types of backups performed for each virtual machine in last <n> days, you can also run the query as follows:

   select * from VMProtectionCoverage (<n>, '')

The results of the query will contain status of the backups performed for each virtual machine. The status will be one of the following:

Virtual Machines Included in Multiple Subclients

If a virtual machine is included in multiple subclients, following query will provide list of all the subclients in which it is included.

Follow the steps given below to run the query:

1. Log on to the CommServe computer. Ensure that the user account used for logging in has administrative privileges.

2. Open the Microsoft SQL Server Management Studio and run the following query on the CommServe database:

   select * from VMsInMultipleSubclients
   

The results of the query will contain list of virtual machines which are included into multiple subclients and the list of those subclients. For example:

If you do not want to include any virtual machine into multiple subclients, you can edit the subclient content.