Skip to content

vBlog.nl

All about technology

Menu
  • Home
  • VMware Cloud Director
  • vSphere
  • Automation
    • PowerCLI
    • PowerShell
    • Terraform
  • NSX
  • Horizon DaaS
  • About Us
Menu

Remove Tenant from Database

Posted on September 23, 2018

Sometimes the installation of your tenant appliance failed, and Horizon DaaS failed to cleanup the old tenant configuration in the database. So when you want to use the same network settings or other settings from the previous installation, you get an error that the network is in use, and cannot be added.

With these steps you can remove the configuration from the database.

1. SSH to primary Service Provider

2. Log in to the Fabric Database.

psql -U admin fdb

3. Find the Tenant ID:
***this will be the “org_id=xxxx” value used for the remainder of the commands 

select id, org_name from organization;

4. Disable the Tenant
 ******** need to make sure we are using the correct ID******

UPDATE organization SET is_disabled='t' where id='xxxx';

5.  SQL Querys

select * from compute_pool where org_id=xxxx; 
delete from compute_pool where org_id=xxxx;
select * from billing_summary where org_id=xxxx; 
delete from billing_summary where org_id=xxxx;
select * from organization where id=xxxx; 
delete from organization where id=xxxx;
select * from appliance where org_id=xxxx; 
delete from appliance where org_id=xxxx;

Find more Horizon DaaS related content here.

Loading

Share on Social Media
x facebook linkedin reddit emailwhatsapptelegram

Leave a Reply Cancel reply

Your email address will not be published. Required fields are marked *

Recent articles

  • Workspace ONE Access services monitoring July 11, 2023
  • vCloud Director API – Couldn’t connect to cloud server with the provided session id May 24, 2023
  • Horizon DaaS – Maximum sessions exceeded May 9, 2023
  • VMware Cloud on AWS with FSx for NetApp ONTAP December 28, 2022
  • Workspace ONE Access – Change certificate December 22, 2022
  • UI themes for VMware Cloud Director 10.4.1 and later December 16, 2022
  • VMware Tanzu Kubernetes Grid December 15, 2022
  • Workspace One Access – Not logged in to server FQDN. Please invoke Save before Sync December 12, 2022
  • NSX Edge configuration has failed. 1G hugepage support required. December 7, 2022
  • Horizon DaaS – Unable to connect to Desktop November 24, 2022

Tags

Automation bootstrapping Container Service Extension Credential Manager Desktone.log ESXi EUC EXi GPU Horizon DaaS Instant-Clone Logging NSX nsx-t PowerCLI PowerShell Putty Raspberry PI SSL Tanzu Terraform update vcd-cli vCenter vCloud vCloud Availability vCloud Director VDI vGPU VMware VMworld vSAN vSphere vVols workspace one Zerto

VMware Cloud Provider Blog

  • Ransomware Recovery for Cloud Providers Using VMware Cloud Director Availability
    by Nikolay Patrikov on September 28, 2023 at 10:30 am

    According to multiple reports, one of the biggest challenges for organizations is being targeted by Ransomware attacks. It is now happening more frequently than ever, which leads to several complications such as re-infection during recovery, prolonged recovery period, etc.  One of the most efficient ways to counteract this is to implement an effective Disaster Recovery policy. It … Continued The post Ransomware Recovery for Cloud Providers Using VMware Cloud Director Availability appeared first on VMware Cloud Provider Blog.

  • Tanzu Mission Control Self-Managed Now Available for Cloud Services Providers and Sovereign Cloud Providers
    by Christopher Wong on September 28, 2023 at 10:00 am

    Tanzu Mission Control, VMware’s centralized Kubernetes management platform, is evolving quickly from its initial release in 2020 to adapt to industry trends and changing customer needs. As observed in the VMware State of Kubernetes 2023 report, over 50% of respondents indicated they wanted to leverage multiple clouds to reduce vendor dependency, while 42% wanted to … Continued The post Tanzu Mission Control Self-Managed Now Available for Cloud Services Providers and Sovereign Cloud Providers appeared first on VMware Cloud Provider Blog.

  • End of NSX Migration for VMware Cloud Director…! What Should I Know?
    by Jaikishan Tayal on September 26, 2023 at 5:03 pm

    In May 2023, VMware unveiled the 7th major release of the VMware NSX Migration for VMware Cloud Director 1.4.2 tool, introducing an extensive array of functionalities and elevating the tool’s capabilities to encompass a comprehensive set of features, facilitating the migration of VMware Cloud Director Networking from NSX for vSphere to VMware NSX (formerly known … Continued The post End of NSX Migration for VMware Cloud Director…! What Should I Know? appeared first on VMware Cloud Provider Blog.

  • Alternative Solutions for Unsupported Features in VMware NSX Migration for VMware Cloud Director…!
    by Jaikishan Tayal on September 26, 2023 at 4:30 pm

    The VMware NSX Migration tool for VMware Cloud Director has seen multiple updates aimed at improving its capabilities and keeping pace with the evolving nature of both VMware Cloud Director and VMware NSX releases. However, it’s worth mentioning that there are certain features that remain unsupported. This could be attributed to their intricate nature or … Continued The post Alternative Solutions for Unsupported Features in VMware NSX Migration for VMware Cloud Director…! appeared first on VMware Cloud Provider Blog.

  • Understanding vGPU functionality with VMware Cloud Director
    by Jaikishan Tayal on September 26, 2023 at 2:02 pm

    VMware Cloud Director (VCD) is a cloud management platform that enables service providers to offer multi-tenant cloud services to their customers. When it comes to using Virtual Graphics Processing Units (vGPUs) with VCD, here are the key details and advantages: VMware Cloud Director (VCD) with vGPU support offers advantages not only for virtual machines (VMs) … Continued The post Understanding vGPU functionality with VMware Cloud Director appeared first on VMware Cloud Provider Blog.

©2023 vBlog.nl | Design: Newspaperly WordPress Theme