LicenseUserExcluded Table

Similarly to the LicenseUser table, LicenseUserExcluded lists account names extracted from other products (such as Oracle databases); but these accounts are to be excluded from license counts. The accounts are listed in full here since it is possible that they do not already appear in the LicenseUser table. Any that do appear in both tables, matched on the login names, are excluded from license counts.

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 LicenseUserExcluded table

Database Column

Details

LicenseUserExcludedID

Type: integer. Key. Generated ID

A unique identifier for an excluded end-user.

LicenseUserLogin

Type: text (max 400 characters). Key

The user login extracted from the original listing (for example, from an Oracle database). For the account to be excluded from license counts, this must exactly match a LicenseUserLogin from the LicenseUser table.

DefaultQuantity

Type: integer

The number of actual users of the database instance logging in through this account. For example, a “SYSTEM” account may allow for a number of administrators to log in. In this table, the default quantity is zero. If this field is non-zero and the end-user matches a LicenseUser record, then in some cases, we may exclude this number of end-users from license counting, but include any further accounts covered by the LicenseUser record.