User Table

The User table contains all of the users that have ever reported information in a FlexNet Manager Suite environment. A row has been added to cater for installations that occur from computer policy. This row has a UserID set to 1 and a UserCN of SYSTEM, and belongs to Organization 1, which is the universal Domain.

Note: To cater for multi-tenant mode, this table may contain data for multiple tenants. Access requires that the database TenantID has been set in the SQL Server connection context information. That setting filters an underlying table to produce this view of data for the single, selected tenant.
Table 1. Database columns for User table

Database Column



Type: integer. Key. Generated ID

The ID for the user. This is automatically generated by SQL Server.


Type: integer. Key

The organizational unit of the user in Active Directory. This is a foreign key into the Organization table. In an SMS environment, this is always set to the unknown OU.


Type: text (max 64 characters). Key

The user’s common name. In an Active Directory environment this is the common name attribute of the user’s distinguished name.


Type: binary (max 16 bytes). Key. Nullable

The objectGUID of the Active Directory object that represents this user, if known.


Type: text (max 20 characters). Key. Nullable

The SAM account name used to uniquely identify this user in event logs and user inventories.