Microsoft 365

Use the Microsoft 365 pages in SAM Core on Snow Atlas to find optimization opportunities for your subscription utilization and costs.

The pages provide information on the subscription plans, user activity, and costs for the cloud service. To populate the pages with data you need inventory sources, and to get correct statistics and insights you must add cost periods to the subscriptions and link users. For more information, see Get started with Microsoft 365.

• On the Activity, Applications, Availability, Cost, and Users pages, you can explore activity, availability and spend for all your Microsoft 365 subscriptions and users, to find optimization opportunities and potential cost savings.

• The Portals page shows all of your configured Microsoft 365 portals which you import data from.

• The Microsoft 365 overview page relates the most important messages for the following metrics:

  • Subscriptions: Shows how many of your subscriptions that have been provisioned (assigned) to a user.

  • Users: Shows how many of the users with provisioned subscriptions that have been active within the last 90 days.

  • Spend: Shows how much you spend on unprovisioned (unassigned) subscriptions and inactive users.

  • Subscription utilization: Shows how well you utilize each subscription with user-based metrics, divided into active users, inactive users, and unprovisioned (unassigned) subscriptions.

• The Insights show the potential cost savings and optimization opportunities for your Microsoft 365 subscriptions specifically, and link to the corresponding report.

Definitions

Definitions of subscription terms in the Microsoft 365 pages:

• Assigned and Provisioned means the number of subscriptions that you have assigned to users.

• Unassigned and Unprovisioned means the number of subscriptions that you have available to assign to users.

• Overassigned means the number of subscriptions that you have assigned that exceeds the number that you have bought. Often these over-allocated subscriptions are reconciled in your next invoice or renewal.

User activity

User activity means when the user last had any activity in the application. Activity data comes from one or several inventory sources. In such a case, the latest available activity is shown regardless of inventory source. For some applications, activity cannot be monitored.

The Microsoft 365 portal provides activities for some applications: Outlook, OneDrive, Sharepoint, Teams, Yammer, Skype. Activities for all other Microsoft 365 applications are collected through Snow Inventory Agents and Cloud Application Metering: Power BI, Visio, Project, Apps for Enterprise, Dynamics365, Office Online.

To always show updated user activity data in the Microsoft 365 pages, you are recommended to scan your inventory sources on a daily basis, but not more often than that. For more information, see Prerequisites.

Characteristics

The statistics are presented in charts and tables. Several filters are available.

Filters

There are several types of filters available to filter data in charts and tables.

• Portal filter

  Select a Microsoft portal to filter data from. The filter affects all pages that display data from the chosen portal: Microsoft 365, Activity, Applications, Availability, Cost, Users. The filter can be selected from all of those pages.

• Subscription filter

  Select one or multiple subscriptions to filter data on in the At a glance chart or in subscription and cost charts. The filter contains subscriptions that have user-based metrics. The filter only affects the chart.

• Annual filter

  Select a year to filter data in charts. The filter only affects the chart.

• Column filter

  Search in a column to filter data in tables. The filter only affects the table.

Charts

Charts show a brief summary of several metrics or a monthly breakdown of the item for the selected metric.

Page	Chart	Description
Microsoft 365	At a glance	Shows a graphical summary of the most important areas: Subscriptions: The rate of provisioned subscriptions to total amount paid for. Users: The rate of user activity on provisioned subscriptions. Annual/monthly spend: The rate of overspend on unprovisioned (available) subscriptions and inactive users.
Microsoft 365	Subscription availability	Shows all subscriptions with user-based metrics in a compound chart per subscription plan of assigned, unassigned, and overassigned subscriptions.
Microsoft 365	Subscription activity	Shows all subscriptions with user-based metrics in a compound chart per subscription plan of active users, inactive users, and unknown usage. Unknown usage means that activity cannot be monitored.
Activity	Subscription utilization	Shows a monthly breakdown, with historic data, of active and inactive users and unknown usage for provisioned (assigned) licenses. Active users: active less than 90 days ago (for monitored subscriptions) Inactive users: active more than 90 days ago (for monitored subscriptions) no activity recorded (for monitored subscriptions) Unknown usage: activity cannot be monitored for the subscriptions
Activity: Subscription activity details / [subscription name]	[subscription name]	Shows a monthly breakdown of user activity and amount of unlinked users for the subscription.
Availability	Subscription availability	Shows a monthly breakdown of provisioned, unprovisioned, and overassigned subscriptions.
Cost	Subscription cost	Shows a monthly breakdown of the costs for active and inactive users and unprovisioned subscriptions. Shows historical data if available.
Cost: Subscription cost details / [subscription name]	Subscription utilization	Shows a monthly breakdown of the costs for active and inactive users and unprovisioned subscriptions. Shows historical data if available. The data below the chart show: Cost for unprovisioned subscriptions and provisioned subscriptions for the current month. Cost for provisioned subscriptions divided into inactive and active users. Accumulated total cost per month, if historical data is available. Costs for inactive users and unprovisioned subscriptions highlight potential cost savings.
Users	Users	Shows a monthly breakdown of active and inactive users for all Microsoft 365 subscriptions with user-based metrics.

Tables

Tables show a detailed breakdown per item for the selected metric with additional column data.

Page	Table	Description
Activity	Subscription activity details	Shows a breakdown of user activity, with data based on the latest import from the Microsoft 365 portal. The column Inactive users indicates a potential subscription optimization opportunity. It consists of: Users for which no activity has been recorded (for subscriptions checked in the Monitored column). Users that were active more than 90 days ago.
Applications	Applications	Shows a breakdown for all Microsoft 365 applications, their user activity, and the corresponding subscriptions.
Availability	Subscription availability details	Shows a breakdown of provisioned and unprovisioned or overassigned subscriptions.
Availability: Subscription availability details / [subscription name]	[subscription name]	Shows a breakdown of all users and their activity in the selected subscription applications.
Cost	Subscription cost details	Shows a breakdown of costs for all subscriptions. The column Overspend shows a summary of the costs for inactive users and unprovisioned subscriptions, which indicates potential cost savings.
Users	User details	Shows a breakdown of all users and their latest activity in any subscription with user-based metrics. Definition of User activity: Last 7 days: The user has been active during the last 7 days. Last 30 days: The user has been active during the last 8 to 30 days. Last 90 days: The user has been active during the last 31 to 90 days. Last 180 days: The user has been active during the last 91 to 180 days. Last 365 days: The user has been active during the last 181 to 365 days.
Users: User details / [user name]	Subscriptions Products	Shows a list in respective tab of the user's subscriptions and products and their activity in them.