Delete Users from XenMobile Database

Delete Users from XenMobile Database

book

Article ID: CTX206832

calendar_today

Updated On:

Description

For XenMobile environment 10.4 and below, we do not have the option to delete the user from the console. You will have to delete the user from the database manually.

Use the following SQL query to delete all rows associated to a single user within XenMobile Server.
Important! Ensure to back up the database PRIOR to making any changes.

DECLARE @name VARCHAR(50);

SET @name = 'username';

delete a from dbname.dbo.user_key a inner join dbname.dbo.users b on a.userid = b.id where b.addlattr2 like @name;

DELETE FROM dbname.dbo.users WHERE dbname.dbo.users.addlattr2 like  @name ;

DELETE FROM [dbname].[dbo].[SECURITY_PRINCIPAL] WHERE [FULL_PATH] like '%' + @name + '%';

DELETE FROM [dbname].[dbo].[useraccnts] WHERE [name] like '%' + @name + '%';

// For deleting the user certificate from the database in case of certificate based authentication use the below command.

Delete from [dbaname].[dbo].[KEYSTORE] where name like '%AgUserAuthCredential=UPN%'; // Give UPN of the user in place of "UPN" .



For XenMobile 10.5 onwards, the AD users can be removed from the console itself.

-Navigate to the Manage> Users tab>
-Select the user to be deleted
-Click on the user and you would get the option to Delete the user as shown below.

User-added image

Environment

The above mentioned sample code is provided to you as is with no representations, warranties or conditions of any kind. You may use, modify and distribute it at your own risk. CITRIX DISCLAIMS ALL WARRANTIES WHATSOEVER, EXPRESS, IMPLIED, WRITTEN, ORAL OR STATUTORY, INCLUDING WITHOUT LIMITATION WARRANTIES OF MERCHANTABILITY, FITNESS FOR A PARTICULAR PURPOSE, TITLE AND NONINFRINGEMENT. Without limiting the generality of the foregoing, you acknowledge and agree that (a) the sample code may exhibit errors, design flaws or other problems, possibly resulting in loss of data or damage to property; (b) it may not be possible to make the sample code fully functional; and (c) Citrix may, without notice or liability to you, cease to make available the current version and/or any future versions of the sample code. In no event should the code be used to support ultra-hazardous activities, including but not limited to life support or blasting activities. NEITHER CITRIX NOR ITS AFFILIATES OR AGENTS WILL BE LIABLE, UNDER BREACH OF CONTRACT OR ANY OTHER THEORY OF LIABILITY, FOR ANY DAMAGES WHATSOEVER ARISING FROM USE OF THE SAMPLE CODE, INCLUDING WITHOUT LIMITATION DIRECT, SPECIAL, INCIDENTAL, PUNITIVE, CONSEQUENTIAL OR OTHER DAMAGES, EVEN IF ADVISED OF THE POSSIBILITY OF SUCH DAMAGES. Although the copyright in the code belongs to Citrix, any distribution of the sample code should include only your own standard copyright attribution, and not that of Citrix. You agree to indemnify and defend Citrix against any and all claims arising from your use, modification or distribution of the sample code.

Issue/Introduction

This article describes how to delete users from XenMobile database.