O365 report RRS feed

  • Question

  • Is there a way to run a report to find all my O365 users and how, Thanks.


    • Moved by Garth JonesMVP Wednesday, August 30, 2017 4:07 PM Not a CM12 Question
    Wednesday, August 30, 2017 3:10 PM

All replies

  • Sure it is is there a sccm report that you can run in sccm to see your O365 installs.


    Wednesday, August 30, 2017 4:22 PM
  • or you can connect to your tenant with powershell and pull custom reports on users.
    Wednesday, August 30, 2017 4:24 PM
  • Why can't you run a report thru SCCM?


    Wednesday, August 30, 2017 4:27 PM
  • or you can connect to your tenant with powershell and pull custom reports on users.
    base MSCA on Office365 covers remote tenant support via powershell for exchange/lync/user setup & management. you should go for that.
    Wednesday, August 30, 2017 4:32 PM
  • Why can't I go with SCCM reporting?


    Wednesday, August 30, 2017 4:33 PM
  • Why can't you run a report thru SCCM?


    because a GUI can get you only as far as the user using it?
    Wednesday, August 30, 2017 4:34 PM
  • Ok well maybe that's all I need.


    Wednesday, August 30, 2017 4:39 PM
  • you can check the link below for more information on connecting to a tenant and querying information of users.

    Wednesday, August 30, 2017 4:48 PM
  • Ok I down loaded the Azure powershell ran the Get-Msoluser command and got this output - 

    PS C:\Users\user\Desktop> Get-MsolUser
    Get-MsolUser : You must call the Connect-MsolService cmdlet before calling any other cmdlets.
    At line:1 char:1
    + Get-MsolUser
    + ~~~~~~~~~~~~
        + CategoryInfo          : OperationStopped: (:) [Get-MsolUser], MicrosoftOnlineException
        + FullyQualifiedErrorId : Microsoft.Online.Administration.Automation.MicrosoftOnlineException,Microsoft.Online.Adm


    Wednesday, August 30, 2017 5:00 PM
  • sounds like you have to connect to o365 first with the connect-msolservice command.
    Wednesday, August 30, 2017 5:38 PM
  • Why can't you run a report thru SCCM?


    If you want to run a report through SCCM, I'd recommend you post a new question to the forum dedicated to SCCM to get further assistance:

    The reason why we recommend posting appropriately is you will get the most qualified pool of respondents, and other partners who read the forums regularly can either share their knowledge or learn from your interaction with us. Thank you for your understanding.


    Steve Fan

    Please remember to mark the replies as answers if they helped.

    If you have feedback for TechNet Subscriber Support, contact

    Thursday, August 31, 2017 7:22 AM
  • You get it figured out Marc?
    Thursday, August 31, 2017 7:14 PM
  • Hi,

    First you need AAD module for powershell.

    You use Active Directory Module for Azure Powershell is a specially designed powershell use to connect to O365. Doenload it from below link and run Connect-msolservice to connect to O365.

    First install the Microsoft Online Services Sign-In Assistant for IT Professionals RTW from the Microsoft Download Center.

    Download Link

    Help link

    Then you need to connect to O365 using the Connect-msolservice

    Once connected, run the below command,

    Get-MSOLUser -All | Export-Csv C:\Temp\LicenseDetails.csv –NoTypeInformation

    Please mark as an answer if this answers your question .


    MCSE Exchange 2013, MCSA 2012 Server MCTS Exchange 2007,

    2010, MCITP Exchange 2007, 2010 MCSE 2003 Server,

    MCSA Exchange 2003 ITIL V3 Foundation

    This posting is provided AS IS with no warranties and confers no rights.

    • Edited by Prem P Rana Saturday, September 15, 2018 4:14 AM
    Saturday, September 15, 2018 4:12 AM