« Back to myAirWatch

Create the Common Name from the AirWatch Database

You must run an SQL script against the AirWatch Database to create the Common Name. Use the generated CN to create the root and intermediate certificates for Remote Management.

Prerequisites

Download the Remote Management Certificate Generator.

Procedure

To create the Common Name.

  1. Open the Remote Management Certificate Generator.
  2. Select the Question Mark button.
  3. Copy the displayed text. This text is the SQL script to run against the AirWatch Database.
  4. On the AirWatch Database server, open SQL Server Management Studio.
  5. Create a query with the copied text.
  6. On the fist line of the query, replace the NULL value with the GroupID for the customer type OG that you want to use. The OG you choose must be a customer type, it cannot be of any other type including global, partner, container, and so on.

    For example,

    DECLARE @GroupID NVARCHAR(20) = NULL;

    becomes

    DECLARE @GroupID NVARCHAR(20) = 'RemoteManagement';
  7. In the Results, copy the created Common Name.

The Common Name is used to generate the root and intermediate certificates for Remote Management. For more information, see Generate the Remote Management Certificates.