Imported Users

IT Asset Management (Cloud)

The ImportedUser table is a staging table used for input of records about users. From here, de-duplicated and normalized records are merged into the ComplianceUser table.

ComplianceUser stores information about end-users in the enterprise, including contact details, login details, and inventory source details (if applicable). End-users are the people using computers within your enterprise (as distinct from operators, who are people permitted to use IT Asset Management).

There are two listings below. The first maps what is imported from Data Platform v5. The second lists values that IT Asset Management expects to load into the ImportedUser table, that are not available from Data Platform v5.

Data mapping for imported users

The following listing matches the source data from Data Platform v5 with the equivalent column in the ImportedUser table. Other columns from the ImportedUser table cannot be populated from Data Platform v5, and so are omitted here (and shown below). For more details on the database tables and columns within IT Asset Management, please see the IT Asset Management Schema Reference PDF, available through the title page of online help.

Data Platform (Table)/Column FNMS (Table)/Column Notes
(DISC_HOSTS_USERLOGON) / USERDOMAIN and USERLOGON combined (ImportedUser) / ExternalID

Mapped through the ImportedStringMapping table to convert string IDs to integer IDs.

(DISC_HOSTS_USERLOGON) / USERDOMAIN (ImportedUser) / Domain

The domain of the end-user. Data Platform exports the flat domain name.

(DISC_HOSTS_USERLOGON) / USERLOGON (ImportedUser) / SAMAccountName

The login name (SAM account name) of the end-user.

Hard-coded value Data Platform (ImportedUser) / InventoryAgent

The name of the person or tool that performed the last inventory.

Data not imported from Data Platform v5

These columns in the ImportedUser table cannot be populated by inventory imports from Data Platform v5. These missing data points do not impact license compliance calculations. For further details about these columns, please see the schema reference.
  • ComplianceConnectionID — internally generated
  • UserName
  • ComplianceDomainID
  • LocationID
  • FirstName
  • LastName
  • Email
  • EmployeeNumber
  • CostCenter (as reported in SAP)
  • ComplianceUserID — internally generated
  • ComplianceDomainID — internally generated
  • IsBlacklisted — internally generated
  • MapUsingEmailAddress.

IT Asset Management (Cloud)

Current