ServiceNow SAM Pro supports multiple integrations with various SaaS software detailed here.
However, depending on the type of SaaS product not all fields on the SaaS Subscription record on ServiceNow is populated. This blog provides explanation of all fields on the SaaS subscription record (samp_Sw_subscription) and also provide details as to which integration updates the particular atribute (field)
Explanation of the subscription table fields
| Field Name (Attribute name) | Meaning | Populated for which SaaS Integration? | Exception |
| Display name | Shows the name of the subscription downloaded from the SaaS Portal | ALL SaaS Integrations | |
| User principal name | This is the unique identifier for a user in the SaaS Portal.This is typically the email id of the user in the SaaS Portal | ALL SaaS Integration | |
| Software model | It represents a standardized version of a software product and for SaaS Integration it is "automatically created" | ALL SaaS Integrations | |
| Subscription profile | Display name of the integration profile | ALL SaaS Integrations | |
| Subscription assigned | Assigned date of the subscription on the SaaS Portal | M365 Integration, Aha, Box, Calendly, Docusign, Dropbox, Microsoft Dynamics 365 and Power Apps, Miro Enterprise, monday.com, Rally, Salesforce CRM, Salesforce Marketing Cloud, Slack, SurveyMonkey, Webex, Workfront, Workplace from Facebook, Zendesk, Zoom | |
| Last activity | Last activity of the user subscription records (usually populated from samp_Sw_usage table and M365 apps usage report fo.r M365 products). This is an important field to determine usage based optimization recommendation | ALL SaaS Integrations | DocuSign - last activity field is deprecated by DocuSign, Crowdstrike (as it is not user based) |
| Inferred suite product | Shows the inferred software subscription | M365 Integration | |
| Licensable software model | Shows the name of the software model that will be consumed from licensing view point. | ALL SaaS Integrations | |
| Inferred Suite Level | Internal field | ||
| Subscription identifier | It is a technical identifier (SKU or service plan ID) from the SaaS provider that tells you what product or plan the user is subscribed to. Based on the subscription identifier ServiceNow is able to map the correct software model.For example: These map to products like: VISIOCLIENT → Microsoft Visio Plan 2 ENTERPRISEPACK → Office 365 E3 |
ALL SaaS Integrations | |
| Inferred suite | Shows the inferred software subscription | M365 Integration | |
| Discovered user | A Discovered User is a record in the Discovered User [samp_discovered_user] table in SAM Pro, which represents a user identity discovered from an external system | ALL SaaS Integrations | |
| Windows downloads | Shows the install of the SaaS software on the Windows OS System | M365 Integration | |
| Windows mobile downloads | Shows the install of the SaaS software on the Windows mobile System | M365 Integration | |
| iOS downloads | Shows the install of the SaaS software on the iOS OS System | M365 Integration | |
| Android downloads | Shows the install of the SaaS software on the Android OS System | M365 Integration | |
| User | Points to the ServiceNow user record in sys_user table representing a real person within your organization. Usually user table in ServiceNow are populated through Active directory integration in your organization | ALL SaaS Integrations | |
| Assigned software identifier | Internal field | Adobe | |
| Assigned software | Internal field | Adobe | |
| Allocation needed | Internal field | ||
| Active | Determines if the subscription record is active | ALL SaaS Integrations | |
| Created | Created date and time | ALL SaaS Integrations | |
| Created by | usually the administrator | ALL SaaS Integrations | |
| Custom Properties | Meta details of the subscription | ALL SaaS Integrations | |
| Domain | Domain of the subscription record | ALL SaaS Integrations | |
| Domain path | Domain Path of the subscription record (not populated in many cases) | ||
| Edition | Edition of the software | ALL SaaS Integrations | |
| External user id | User id in the saas portal | ALL SaaS Integrations | |
| Inactive days | Number of days since the subscription has been inactive | ALL SaaS Integrations (except Crowdstrike as it is not user based) | Crowdstrike |
| Instance name | Integration name | ALL SaaS Integrations | |
| Is allocated | Internal field | ||
| Is reconciled | Whether the saas subscription has been reconciled (True/false) populated after you run reconciliatiobn | ALL SaaS Integrations | |
| Licensable software model source | Internal field | ||
| License metric result | License metric result of the software populated after reconciliation. To understand product results, software model results and license metric results pls check the docs: https://www.servicenow.com/docs/bundle/xanadu-it-asset-management/page/product/software-asset-manage... | ALL SaaS Integrations | |
| Mac downloads | Shows the install of the SaaS software on the MAC OS System | M365 Integration | |
| Number of installs | Internal field | ||
| Product | Product on the SaaS Integration | ALL SaaS Integration | |
| Product result | Product result of the software populated after reconciliation. To understand product results, software model results and license metric results pls check the docs: https://www.servicenow.com/docs/bundle/xanadu-it-asset-management/page/product/software-asset-manage... | ALL SaaS Integrations | |
| Reconciliation state | Internal field | ||
| Software model result | Software Model result of the software populated after reconciliation. To understand product results, software model results and license metric results pls check the docs: https://www.servicenow.com/docs/bundle/xanadu-it-asset-management/page/product/software-asset-manage... | ALL SaaS Integrations | |
| Sourced from integration | To determine if this record has been added through integrration (Yes/No) | ALL SaaS Integrations | |
| Stale license | To determine if subscription record is stale (True/false) | ALL SaaS Integrations | |
| State | Internal field | ||
| Tags | Any tags (on servicenow) that the customer adds is populated here | ALL SaaS Integrations | |
| Subscription type | Software subscription | ALL SaaS Integrations | |
| Unlicensed subscription | Shows if the subscription is not licensed due to non availability of licenses. Shows after reconciliation with value as true or false | ALL SaaS Integrations | |
| Updated | Updated date and time | ALL SaaS Integrations | |
| Updated by | Updated by usually admin | ALL SaaS Integrations | |
| Updates | Number of updates to the recod | ALL SaaS Integrations | |
| User source | Integration | ALL SaaS Integrations |
