Known Issue: Imported users with non-NULL value in the Email column and NULL values in all other identity columns get merged to a single user record (IOK-752331)
Known Issue: Imported users with non-NULL value in the Email column and NULL values in all other identity columns get merged to a single user record (IOK-752331)
Symptoms
Source user records imported from inventory data sources that contain a value for an email address but no value for other identifying fields (including user name, domain, SAM account name, first name, last name and employee number) are merged into a single user record by the inventory import process. The single user record has an email address from one of the source user records that is effectively selected at random.
As a consequence of this issue, user records for some email addresses that exist in the inventory data sources may not exist.
Details
Source user records imported from inventory data sources are stored in the ImportedUser view in the compliance database. This issue affects records in this view that have:
A non-NULL value in the Email column; and
NULL values in the UserName, Domain, SAMAccountName, FirstName, LastName and EmployeeNumber columns.
The following SQL query can be executed against the compliance database of a FlexNet Manager Suite system to identify potentially affected records:
SELECT *
FROM dbo.ImportedUser iu
JOIN dbo.ComplianceUser cu ON cu.ComplianceUserID = iu.ComplianceUserID AND cu.Email != iu.Email
WHERE iu.Email ISNOTNULLAND iu.SAMAccountName ISNULLAND iu.UserName ISNULLAND iu.FirstName ISNULLAND iu.LastName ISNULLAND iu.EmployeeNumber ISNULL
Fix status
This issue has been fixed in the following FlexNet Manager Suite releases: 2022 R1.3 / Jul 2022 (Cloud), 2022 R2 (On Premises)
Tip: If you have been impacted by this issue, please click the KUDOS button above. This helps to track the relative significance and importance of issues. Clicking on an option against "Was this article helpful?" also helps assess and improve the usefulness of content.