Skip to page contentSkip to chat
ServiceNow support
    • Community
      Ask questions, give advice, and connect with fellow ServiceNow professionals.
      Developer
      Build, test, and deploy applications
      Documentation
      Find detailed information about ServiceNow products, apps, features, and releases.
      Impact
      Accelerate ROI and amplify your expertise.
      Learning
      Build skills with instructor-led and online training.
      Partner
      Grow your business with promotions, news, and marketing tools
      ServiceNow
      Learn about ServiceNow products & solutions.
      Store
      Download certified apps and integrations that complement ServiceNow.
      Support
      Manage your instances, access self-help, and get technical support.
Empty "User" records in the "Software Subscriptions" table "samp_sw_subscription" - Support and Troubleshooting
  • >
  • Knowledge Base
  • >
  • Support and Troubleshooting (Knowledge Base)
  • >
  • Empty "User" records in the "Software Subscriptions" table "samp_sw_subscription"
KB0855779

Empty "User" records in the "Software Subscriptions" table "samp_sw_subscription"


1834 Views Last updated : Apr 8, 2024 public Copy Permalink
KB Summary by Now Assist

Issue

  • 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

  • All

Resolution

  • 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.


The world works with ServiceNow.

Sign in for more! There's more content available only to authenticated users Sign in for more!
Did this KB article help you?
Did this KB article help you?

Attachments

Attachments

  • Screen Shot 2020-09-03 at 10.35.02 AM.png
  • Screen Shot 2020-09-03 at 10.36.52 AM.png
  • Screen Shot 2020-09-03 at 10.38.48 AM.png

How would you rate your Now Support digital experience?

*

Very unsatisfied

Unsatisfied

Neutral

Satisfied

Very satisfied

Very unsatisfied

Unsatisfied

Neutral

Satisfied

Very satisfied

What can we improve? Please select all that apply.

What are we doing well? Please select all that apply.

Tell us more

*

Do you expect a response from this feedback?

  • Terms and conditions
  • Privacy statement
  • GDPR
  • Cookie policy
  • © 2025 ServiceNow. All rights reserved.