Unable to view data in Office 365 Usage Reports (samp_sw_o365_usage_report)

[PatthiBharathi]

Hello SAM Family,

I'm unable to view data under Office 365 Usage Reports (samp_sw_o365_usage_report).

We have recently integrated with Microsoft 365 (Direct integration). I'm able to view subscription data (samp_sw_subscription.list) Snip1 but in Office 365 usage reports (samp_sw_o365_usage_report. list) table data is not reflecting Snip2. Can someone please help to fix this issue. What is error or issue will be? Please see below snips for better understanding.

Please share me if you have any checklist with navigations that needs to be validated after doing Microsoft365 integration. What data and schedule jobs, reports and any other data that needs to be validated. 

Snip1:

Snip2:

Thanks& Regards,

Bharathi Patthi

[mohdarbaz]

Hi @PatthiBharathi ,

Checklist for Validating Microsoft 365 Integration

1. Verify Integration Configuration:

   • Ensure that the Microsoft 365 integration is correctly configured. Check the connection settings and credentials to make sure they are accurate and have the necessary permissions.

2. Check Data Import Jobs:

   • Verify that the data import jobs for Office 365 usage reports are running successfully. These jobs are responsible for fetching data from Microsoft 365 and populating the samp_sw_o365_usage_report table.
   • Navigate to the scheduled jobs and look for any jobs related to Office 365 usage data. Ensure they are active and running without errors.

3. Review Logs and Error Messages:

   • Check the system logs for any error messages related to the data import process. Look for any indications of failures or issues that might be preventing data from being imported.

4. Validate Data Mapping:

   • Ensure that the data mapping between Microsoft 365 and the samp_sw_o365_usage_report table is correct. Incorrect mapping can result in data not being displayed as expected.

5. Check Data Permissions:

   • Verify that the user account used for the integration has the necessary permissions to access and retrieve Office 365 usage data.

6. Refresh Data:

   • Manually trigger a data refresh to see if the data populates correctly. Sometimes, a manual refresh can resolve synchronization issues.

7. Manually Run Job:

   • Select the job and manually run it to see if it completes successfully and populates the data.

If my response helped, please mark it correct and close the thread so that it benefits future readers.

Regards,

Mohd Arbaz.

[PatthiBharathi]

Hello @mohdarbaz ,

Thank you so much for your time and response. Much Appreciated. Could you please let me know the scheduled job name to pull usage data. We are not getting last activity dates also for many of users. Please find below snip. We have to create usage report but only for few users last activity date is reflecting.

[dreinhardt · Accepted solution]

Hi @PatthiBharathi,

the mentioned tabled is no longer used in context of M365 and was last mentioned in the Vancouver release (Publisher optimizations for Microsoft) and is no longer supported.

Please check the following docs about the latest M365 usage features available for SAMP (W.DC, Xanadu, Yokohama)

• Evaluating software usage activity for Microsoft 365 subscriptions
• Microsoft 365 Apps Usage Reports

Microsoft 365 Apps Usage Reports [samp_m365_apps_usage_report]

View the last activity date for the Microsoft 365 products in the Microsoft 365 Apps Usage Reports table for each user. This table stores usage data for Microsoft 365 products in True or False retrieved from Microsoft APIs only. The last activity date helps you determine reclamation candidates more accurately for Microsoft 365 products, including Microsoft Outlook, Microsoft Word, Excel Microsoft PowerPoint, and OneNote. For more details on Microsoft 365 apps usage fields and their descriptions, see Microsoft 365 Apps Usage Reports.

These usage tables include the date when the software was last used and the type of the activities performed on the Desktop, Web, Mobile, or cumulative across platforms. The last activity data helps you select an optimized plan for individual products within your Microsoft 365 subscriptions. For related usage, the  SAM - Collect Microsoft 365 Usage  scheduled job collects the usage data daily.

Best, Dennis

[PatthiBharathi]

@mohdarbaz   

Thank you so much for your valuable response.😊