- Advertisement -
HomeVirtualizationVMwareConnecting to the View ADAM Database + Deleting a stuck VM

Connecting to the View ADAM Database + Deleting a stuck VM

In This Article:

What:

When you deploy linked clone desktops pools with VMware Horizon, the information for these machines are stored in the ADAM database and not with the vCenter database. The ADAM database is described in the following VMware KB:
“The Active Directory Application Mode (ADAM) database is used as a replicated storage facility for vCenter Servers running in Linked mode.

ADAM is used to store:
• The list of vCenter instances participating in the group. For a standalone instance, this still exists, but there is only one entry in the list.
• The definitions of authorization Roles. These are common in the group and are no longer stored in the vCenter SQL database.
• The definitions of available licenses and license assignments for the Linked Mode group. One-stop shopping for checking on and updating license usage across all vCenters in the group.

ADAM is required to run vCenter Server in Linked Mode. If you do not want to run vCenter Server in Linked Mode, close ADAM ports, RPC ports and port 389 and port 636 in the firewall. These ports are only used by the local VMware VirtualCenter Management Webservices and VMware VirtualCenter Server services.
Note: ADAM is also utilized by standalone vCenter Servers for storing licensing information.”

Sometimes will be necessary to connect to the ADAM database for troubleshooting, when a pool or VM is stuck in View Administrator inventory and cannot be deleted, this pool or VM need to be deleted from the ADAM database.

How:

In my case, I have VMware Horizon connection server running on a Windows 2012 R2, the one I am using for the creation of the virtual machines in my VDI tested environment.

  1. Go to StartAdministrativeTools > ADSI Edit
p6 image1
  1. From the console window, right-click ADSI Edit and click Connect to…
p6 image2
  1. In the new window, type any name in Name field: ADAM Database, for example.
  2. In Connection Point, Select Select or type a Distinguished Name or Naming Context
  3. In the field below, type: dc=vdi,dc=vmware,dc=int
  4. In computer, select Select or type a domain or server: (Server | Domain [:port])
  5. In the field below, type [localhost] or the server name (with domain), in my case is VDIConnection.vdi.local
  6. Click OK to connect, if the connection cannot be established, verify the user credentials. If the connection is OK, skip to number 11.
p6 image3
  1. Specify credentials. Here I am using the domain controller credentials I created for the VDI environment.
p6 image4
  1. Enter again credential in the new window.
p6 image5
  1. Right-click ADAM Database [Server name] >New Query…
p6 image6
  1. In the new window, type any name in Name field (Ex. Test), in Root of Search click Browse… 
p6 image7
  1. Select Server Organizational Unit and click OK
p6 image8
  1. In Query Stringfield, type (&(objectClass=pae-VM)(pae-displayname=VM)), where VM is the name of the virtual machine you want to find and delete. You can use * to match multiple virtual machines. In my case is VM074, click OK to create the query.
p6 image9
  1. Click in the new query created on the left panel and delete the record.
p6 image10
  1. If multiples virtual machines are in the query (wildcard *), get the IDs in CN=<ID>, then locate the OU=SERVERS and match the records you want to delete in the right panel.
p6 image11
- Advertisement -

By connecting to the ADAM database on the View Connection Server, we were able to delete the VM(s) stuck in the View Administrator inventory.

Juan Mulford
Juan Mulford
I have been active in IT for over fourteen years now. I am a solutions architect, working with storage, virtualization, and VDI solutions. For the past ten years, I have been living and working in Taiwan.

6 COMMENTS

  1. Hi Juhan,

    Recomposer task got stuck in Horizon Administrator, If i try to delete task still task appears in the task list.
    The machines which have problem i already deleted from database as mentioned above.
    Do you know how to delete task which got stuck ?

    • Hi Sha, if you already delete the machines from the ADAM database and the issue persists, you need to do some extra workaround in the main database, the one from the Composer, since it might be corrupted. I had to do this once but I don't remember how at this moment, it is not a pleasant process.

  2. Hi Juan,
    Thanks for your prompt reply!

    I logged in to database but didn't find database for task.
    Do you have any idea, if i can create new Desktop Pool and disabled existing desktop pool, because Vms status are good available and connected without any problem but the thing is that i can't recompose image because following message appears while refresh deskstop pool or recompose:

    ""One or more of the selected virtual machines already has a pending View Composer operation. This new operation cannot be submitted until the pending operation is completed or canceled.""

    https://communities.vmware.com/message/2897339#2897339

    Regards
    Sha

Leave a Reply

- Advertisement -

Popular Articles

mulcas.com-Raspberry-Pi

Raspberry Pi OS in a Virtual Machine with VMware

4
Although the Raspberry Pi OS is designed and optimized for the Raspberry Pi module, it is possible to test and use it without its hardware, with VMware. This solution can be useful if you are a developer (or just a curious guy) and don't have a Raspberry Pi module with you
Unable to delete inaccessible datastore

Unable to delete an "inaccessible" datastore

4
I was switching my storage array, so I migrated the VMs from that old datastore/storage to a new datastore/storage. The old datastore was shared by 3 ESXi hosts, no cluster. After migrating the VMs and unmount/delete the datastore, it was still presented in two of the ESXi hosts and was marked as inaccessible.
mulcas.com-VMware-OVF-Tool

How to export a Virtual Machine using the VMware OVF Tool

8
The VMware OVF Tool is implemented by VMware for easily importing and exporting virtual machines in Open Virtualization Format (OVF) standard format. Here, I want to show you how to download and install it, and then how to use it from a Windows machine.
This is not a valid source path / URL

This is not a valid source path / URL - SourceTree and Gitlab

0
I have been working on a project with a friend who set up a repository in Gitlab but even though I was able to view all projects on it, I couldn’t really join the repository. I was using SourceTree and Gitlab.
WinSCP VCSA

Unable to Access the VCSA 6.7 via WinSCP

9
One of the many and easiest ways to get the logs from the ESXi hosts and vCenter Server Appliance (VCSA), is accessing directly to the files directory using tools such as WinSCP, which helps to transfer the files between a local and a remote computer ( Ex. VCSA). I never have had issues with the ESXi hosts and WinSCP, however, trying to access the VCSA is a different story.
- Advertisement -

Recent Comments