User field is observed to be empty for few records in the "samp_sw_subscription" table.
When a particular user is marked under "assigned to" in the SAAS tools for a subscription, how is Servicenow mapping to that same person ?
Based on which data, the user id is identified in Servicenow ?
How the user related information gets populated on "samp_sw_subscription" table ?
Release or Environment
The "User" is identified using the "User principal name" when the subscription is created.
The "User principal name" is considered as the email and is used to query the servicenow "Users" table.
If no record is found in the "Users" table, the "User principle name" is trimmed to have only the "Username" and this "Username" is used to query the "Users" table.
The "Users" field will be empty if no record is found either with email or with the username in the "Users" table.
In short, even if the "User principal name" is not empty, the "User" field will be empty if there are no "Users" on this instance with the "User principal name" as their email id or with the same username.