Tracking License Allocations for Subscription Management V2Issue <!-- /*NS Branding Styles*/ --> .ns-kb-css-body-editor-container { p { font-size: 12pt; font-family: Lato; color: #000000; } span { font-size: 12pt; font-family: Lato; color: #000000; } h2 { font-size: 24pt; font-family: Lato; color: black; } h3 { font-size: 18pt; font-family: Lato; color: black; } h4 { font-size: 14pt; font-family: Lato; color: black; } a { font-size: 12pt; font-family: Lato; color: #00718F; } a:hover { font-size: 12pt; color: #024F69; } a:target { font-size: 12pt; color: #032D42; } a:visited { font-size: 12pt; color: #00718f; } ul { font-size: 12pt; font-family: Lato; } li { font-size: 12pt; font-family: Lato; } img { display: block; max-width: ; width: auto; height: auto; } } After upgrading to Subscription Management V2, users can no longer identify when a user was newly allocated a subscription by looking at sys_user_has_license table. Release<!-- /*NS Branding Styles*/ --> .ns-kb-css-body-editor-container { p { font-size: 12pt; font-family: Lato; color: #000000; } span { font-size: 12pt; font-family: Lato; color: #000000; } h2 { font-size: 24pt; font-family: Lato; color: black; } h3 { font-size: 18pt; font-family: Lato; color: black; } h4 { font-size: 14pt; font-family: Lato; color: black; } a { font-size: 12pt; font-family: Lato; color: #00718F; } a:hover { font-size: 12pt; color: #024F69; } a:target { font-size: 12pt; color: #032D42; } a:visited { font-size: 12pt; color: #00718f; } ul { font-size: 12pt; font-family: Lato; } li { font-size: 12pt; font-family: Lato; } img { display: block; max-width: ; width: auto; height: auto; } } Applies to Subscription Management v2 (Vancouver release and later) Resolution<!-- /*NS Branding Styles*/ --> .ns-kb-css-body-editor-container { p { font-size: 12pt; font-family: Lato; color: #000000; } span { font-size: 12pt; font-family: Lato; color: #000000; } h2 { font-size: 24pt; font-family: Lato; color: black; } h3 { font-size: 18pt; font-family: Lato; color: black; } h4 { font-size: 14pt; font-family: Lato; color: black; } a { font-size: 12pt; font-family: Lato; color: #00718F; } a:hover { font-size: 12pt; color: #024F69; } a:target { font-size: 12pt; color: #032D42; } a:visited { font-size: 12pt; color: #00718f; } ul { font-size: 12pt; font-family: Lato; } li { font-size: 12pt; font-family: Lato; } img { display: block; max-width: ; width: auto; height: auto; } } Track historical allocation dates with the license_detail_metric_history table. Use the license_detail_metric_history table to report on when subscriptions were assigned or changed. This table captures timestamped snapshots/metrics of license allocations, making it suitable for “who received a license in the last week?” style reporting. Understand supporting tables for current state vs. history: Current state (who has what right now): subscription_detail, user_has_subscription, and license_details. (current allocation status)Usage/activity (not allocation events): ua_app_usage can be used to track user activity related to subscriptions and license types—useful for differentiating insights for business stakeholders vs. fulfillers. It relates to usage history rather than strictly allocation events. Summary: For historical tracking of license assignments/allocations → use license_detail_metric_history.For the current snapshot of subscriptions/licenses → refer to subscription_detail, user_has_subscription, and license_details.For reports on user activity and application usage → use ua_app_usage. Related Links<!-- /*NS Branding Styles*/ --> .ns-kb-css-body-editor-container { p { font-size: 12pt; font-family: Lato; color: #000000; } span { font-size: 12pt; font-family: Lato; color: #000000; } h2 { font-size: 24pt; font-family: Lato; color: black; } h3 { font-size: 18pt; font-family: Lato; color: black; } h4 { font-size: 14pt; font-family: Lato; color: black; } a { font-size: 12pt; font-family: Lato; color: #00718F; } a:hover { font-size: 12pt; color: #024F69; } a:target { font-size: 12pt; color: #032D42; } a:visited { font-size: 12pt; color: #00718f; } ul { font-size: 12pt; font-family: Lato; } li { font-size: 12pt; font-family: Lato; } img { display: block; max-width: ; width: auto; height: auto; } } https://www.servicenow.com/community/servicenow-ai-platform-forum/looking-to-create-a-report-on-servicenow-license-allocation/m-p/3126597 https://docs.flexera.com/flexera/EN/SaaSManager/SNSubscriptionLicensing.htm?Highlight=servicenow https://www.servicenow.com/community/platform-analytics-forum/creating-a-subscription-table-report-with-different-last-login/m-p/2661394