Loading...

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

  1. Log on to the CommServe computer. Ensure that the login user account has administrative privileges.
  2. Open the Microsoft SQL Server Management Studio.
  3. 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

Last modified: 1/7/2019 4:36:19 PM