Identifying Virtual Machines in Multiple Subclients

To identify virtual machines that are included in multiple user-defined subclients, you must run a SQL query on the CommServe database.

Procedure

Log on to the CommServe computer. Ensure that the login user account has administrative privileges.
Open the Microsoft SQL Server Management Studio.
Run the following query on the CommServe database:
```
select * from VMsInMultipleSubclients
```
To remove virtual machines from subclients where the VMs are duplicated, edit the subclient content.

Result

When you run the query, the results contain a list of VMs that are included in multiple subclients and the associated subclients for each duplicated VM.

Example:

Name	Subclient Name
test-vm1	subclient A
test-vm1	subclient B
test-vm2	subclient P
test-vm2	subclient Q