Last Activity Field Not Populating for Microsoft Subscriptions in SAM Pro

[Tejaswini Morey]

We have Microsoft subscription software records in our instance, and data is available in the samp_sw_subscription table. However, the ‘Last Activity’ field is not getting populated and remains blank for all records.

We have integrated Microsoft 365 with ServiceNow SAM Pro, but we are unable to fetch the last activity data for users.

[pr8172510]

Hi @Tejaswini Morey,

The Last Activity field is populated only when Microsoft 365 usage/activity data is successfully imported and processed by SAM Pro. Subscription data alone does not populate this field.

verify

• The Microsoft 365 usage/activity import is configured and completes successfully.

• The Microsoft 365 integration has the required permissions to retrieve usage/activity data.

• Import logs and scheduled jobs complete without errors.

• Usage/activity records are being imported and correctly mapped to the corresponding subscription and user records.

If records exist in the samp_sw_subscription table but no Microsoft 365 usage/activity data is imported, the Last Activity field will remain blank.

[Tanushree Maiti]

Hi @Tejaswini Morey 

The last activity is gathered automatically for few individual products directly without any discovery solution. These include Exchange Online, Teams, One Drive, Power BI, Share Point Online, Viva Engage (formerly Yammer) 

Refer: 

ServiceNow SAM Pro determination of last activity date for M365 Subscriptions

Microsoft 365 License compliance and optimization support on ServiceNow SAM Pro

https://www.servicenow.com/community/sam-forum/there-are-miscrosoft-subscription-softwares-in-the-in...

[Tejaswini Morey]

Hello @Tanushree Maiti,

We are able to see Last Activity data for the following products:

• Exchange Online
• Microsoft Teams
• OneDrive
• Power BI (Power BI access has been enabled)
• SharePoint Online
• Viva Engage
• Microsoft 365 Copilot

However, we are not receiving Last Activity data for the following products:

• Fabric
• Power Automate
• Microsoft Defender
• Microsoft Purview Suite
• Power Pages
• Copilot Studio

Could you please confirm whether any additional configuration, permissions, or setup is required to fetch the Last Activity information for these products? Currently, the Last Activity field is not being populated for these subscriptions.

Thank you.

[Tejaswini Morey]

I reviewed the Software Subscription records where Last Activity is NULL under the Microsoft SaaS integration.

Observations:

• Fabric – Last Activity not available.
• Defender + Purview Suite – Last Activity not available.
• Copilot Studio – Last Activity not available.
• Planner and Project – Last Activity not available.
• Power Automate – Last Activity not available.
• Power BI – Last Activity available, after enabling Power BI access.
• Power Pages – Last Activity not available.
• Stream – Last Activity not available.
• Teams Rooms – Last Activity not available.
• Teams Phone – Last Activity not available.
• Teams Shared Devices – Last Activity not available.
• Teams International Calling – Last Activity not available.
• Domestic Calling Plan – Last Activity not available.
• Defender Vulnerability Management – Last Activity not available.

Could you please confirm whether Last Activity collection is supported for these products and whether any additional configuration or permissions are required to populate the Last Activity field?

Thank you.