Usage Data for Adobe & Microsoft Products

[NE]

Hey community, 

Our team would like to run reports for licenses that have not been used for the past 90 days. We have several different publishers that we need to get this information from. Namely, for Microsoft and Adobe. My question is: Is it possible to see the last used date/time for individual licenses under these publishers. For example: I want to see the last used date for Joe Smith for his subscription to Adobe Acrobat Pro.

To help answer any questions: 

1. We have the direct integration profiles setup for both Adobe and Microsoft. 

2. We have also imported our entitlement data and have our models working correctly. 

Any help would be greatly appreciated!

[mikew_samexpert]

Have you considered setting up reclamation rules which provides a list of users that haven't used their licenses for a pre-determined time period?

[NE]

In short, yes. The issue that I am having is validating the specific field the reclamation rules are pulling the last used date from. Ideally, I would like to run both the reclamation rules and individual reports. However, I am unsure if the last used date is populated for both Microsoft and Adobe products. 

[christianseppDL · Accepted solution]

Hi NE,

this sounds like a valid use case - and reports are awesome if you have the right data available.

The data from the various direct integration profiles is stored in the table "Software Subscriptions" (samp_sw_subscription) and there is a column "Last activity" available. However, the columns of the table are not all used by all integration profiles equally.

The Adobe integration does not include usage data OOB. As far as I know, the current Adobe API does not provide usage data (cf. the OOB reclamation rule for Adobe optimizes the assignment of Creative Cloud products but not usage data).

For the Microsoft integration, the column "Last Activity" is populated. The date is the most recent date an user has executed / run /... a Microsoft product / service (e.g. Word) associated with the subscription - the value is processed separately by the job "import m365 usage". The "raw" data for M365 usage data can be found in the table "Office 365 Usage Reports" (samp_sw_o365_usage_report) - it is basically a representation of the respective report in the M365 admin portal (filter is on 90 days).

More information about the report can be found under the following links:
https://learn.microsoft.com/en-us/microsoft-365/admin/activity-reports/activity-reports?view=o365-wo...
https://learn.microsoft.com/en-us/microsoft-365/admin/activity-reports/microsoft365-apps-usage-ww?vi...
https://learn.microsoft.com/en-us/graph/api/reportroot-getm365appuserdetail?view=graph-rest-1.0&tabs...

Adding additional "reclamation rules" does not help in your case because the reclamation rules for Adobe and M365 do not focus primarily on "last usage" but on optimizing the assigned products / plans.

If you have another data source for software usage, i.e. SCCM / ECM, ServiceNow imports automatically usage data for products / executable files which are associated with the M365 and Adobe products from the direct integration. For example, the SQL statement contains winword.exe, powerpnt.exe. The platform combines both sources (metering on the device from SCCM / ECM AND usage report from M365 portal) to create removal candidates.
In my opinion, the removal candidates help you to follow optimization processes. For reporting purposes I'd prefer the software usage raw data - which is hard to come by.