UserNameBlacklist Table

UserNameBlacklist stores a list of excluded accounts that will not be imported into IT Asset Management. If an end-user with account name matching a record in UserNameBlacklist already exists in IT Asset Management, that end-user will not be included in compliance calculations and will not appear in many of the end-user lists.

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

Database Column

Details

UserNameBlacklistID

Type: integer. Key. Generated ID

A unique identifier for the blacklisted account.

UserName

Type: text (max 64 characters). Key

A blacklisted account name. May contain wildcards (%, _). End-users whose domain\SAM account name match this value will be excluded from compliance calculations.