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	Details
`UserID`	Type: integer. Key. Generated ID The ID for the user. This is automatically generated by SQL Server.
`UserOUID`	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.
`UserCN`	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.
`GUID`	Type: binary (max 16 bytes). Key. Nullable The `objectGUID` of the Active Directory object that represents this user, if known.
`SAMAccountName`	Type: text (max 20 characters). Key. Nullable The SAM account name used to uniquely identify this user in event logs and user inventories.
`Email`	Type: text (max 200 characters). Nullable The user’s email address.