Bsure Documentation
back to bsure.io
  • Welcome
  • Installation
    • Overview
    • Prerequisites
    • Installation Instructions
  • Technical Description
    • Design Principles
    • Azure Managed Application
    • Permissions Required
    • Security​
      • Public IP and Storage Account Key considerations
    • Technical Architecture
    • Dataflow and visibility
  • User guides
    • Overview
    • Main Dashboard
    • Users
      • Dashboard
      • Members
      • Guests
      • Data Quality
      • Properties
      • Sign-in Map
      • Sign-in Locations
      • Drilldown
    • Microsoft Licenses
      • Cost Dashboard
      • Licenses Overview
      • Subscription Overview
      • Inactive and Disabled Users
      • Overlapping licenses
      • Cost Allocation
      • Drilldown
      • Price Settings
      • Add Your Own Prices
        • Average SKU Price Calculator
    • Applications
      • Usage
      • Cost
      • Sign-in Locations
        • Successful sign-ins from blocked countries?
    • Groups
    • Security
      • Dashboard
      • Authentiation Methods
      • Entra ID Roles
      • Service Principals
    • Devices
      • Windows Dashboard
      • Windows Inactive Devices
      • Windows OS
      • Windows Management
      • Devices per Person
      • Drilldown
    • Share the Power BI App
      • Share App only
      • Give Access to the Power BI Workspace
      • Share the Storage Account Access Key
      • Share with External Users
    • Update Power BI App
    • Glossary
  • Pricing & Billing
    • Pricing
    • Billing
  • Support
    • Support
    • Frequently Asked Questions
    • Troubleshooting
    • Release Notes
    • New features
      • User purpose property
  • Partners
    • Partner sell an offering including the app to the customers
    • Customer have a strict data protection regime
    • Partner uses the app without customer knowledge
    • General considerations
  • Policies
    • Privacy Policy
    • Terms & Conditions
  • RECOMMENDED ACTIONS
    • Recommended actions
      • Review Entra ID role assignments and create a strategy to offer such roles
      • Review and remove all inactive or unwanted accounts
        • Bulk deletion of users in Entra ID
      • Protect all users with MFA
      • Review and clean up applications with excessive permissions
Powered by GitBook
On this page
  1. User guides
  2. Microsoft Licenses

Drilldown

PreviousCost AllocationNextPrice Settings

Last updated 3 months ago

In this report we combine the information from the previous reports and give you the chance to drill down on all user- and license specific data

Filter alternatives

  • User Purpose: Filter on the type of Exchange Online mailbox connected to the user.

    • User - A user account with a mailbox.

    • Guest - The user purpose for guest users is set to Guest.

    • Shared - A shared mailbox user.

    • Room - A user with a mailbox that represents a conference room.

    • Equipment - A user with a mailbox that represents a piece of equipment.

    • Others - A mailbox was found but the user purpose is not specified.

    • Unknown - User has no Exchange Online mailbox, or we were not able to read it.

  • Created date: Helps you filter on when users were created

  • Last sign-in: Helps you filter on showing all users from when they were last created. In this overview you can i.e exclude users created last two weeks

  • User state: Choose if you want to see overview of active or inactive users or both

  • Sign-in status: Helps you filter on users who have never signed in and users that have

  • Account: Filter for showing Disabled or Enabled users - or both.

  • User Principal Name: Free text search for a user name. Report will update accordingly.

Useful words to search for on user principal name:

  • "Test"

  • "Admin"

Focus table - license types

  • This table shows you all licenses, quantity and cost.

Breakdown table - additional filter available for different user properties

  • This table shows the distribution of cost for the chosen property

  • Breakdown filter: Choose the appropriate property you want to by using the breakdown filter on the right side. We have also included Extension attributes as this is often used by companies

User details table

  • In this table you can drill down on the specific users that have licenses allocated to them and investigate whether they should be removed or not.

  • The column selector on the right hand side gives you the opportunity to choose which information is the most interesting to see. Some of the most interesting properties to see based on our experience is:

  1. Created

  2. Last sign-in

  3. Days since last sign-in

  4. Cost

  5. Licenses combined

This table can be exported with live integration to Excel and be used as a worklist across different functions to clean up. The spreadsheet will be automatically updated every night