O365 admin portal reporting

%3CLINGO-SUB%20id%3D%22lingo-sub-13749%22%20slang%3D%22en-US%22%3EO365%20admin%20portal%20reporting%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-13749%22%20slang%3D%22en-US%22%3E%3CP%3EIs%20ther%20a%20way%20to%20get%20a%20report%20from%20the%20admin%20portal%20wiht%20he%20version%20of%20Micosoft%20office%20that%20is%20being%20used%20by%20the%20users%3F%3C%2FP%3E%3CP%3EIf%20not%2C%20is%20this%20on%20the%20road%20map%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-13749%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EAdmin%20center%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EReporting%20Portal%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-37656%22%20slang%3D%22en-US%22%3ERe%3A%20O365%20admin%20portal%20reporting%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-37656%22%20slang%3D%22en-US%22%3E%3CP%3ETo%20chime%20in%2C%20yes%20this%20would%20be%20good%20and%20it%20would%20be%20a%20useful%20addition%2C%20you%20shouldn't%20really%20have%20to%20spend%20extra%20for%20this.%20%26nbsp%3BEven%20more%20so%20as%20channel%20versions%20become%20unsupported%2C%20like%201602%20next%20month%20and%20making%20sure%20all%20PCs%20are%20on%20the%20right%20version.%20%26nbsp%3BThis%20info%20isn't%20available%26nbsp%3Beither%20from%20the%20Power%20BI%20Office%20365%20Adoption%20pack%20by%20the%20way.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ESaying%20that%2C%20Configuration%20Manager%20now%20comes%20with%20some%20great%20reporting%20with%20the%26nbsp%3BOffice%20365%20Client%20Management%20dashboard%20(as%20well%20as%20deployment%20and%20update%20features%20for%20O365%20ProPlus)%2C%20showing%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CUL%3E%3CLI%3ENumber%20of%20Office%20365%20clients%3C%2FLI%3E%3CLI%3EOffice%20365%20client%20versions%3C%2FLI%3E%3CLI%3EOffice%20365%20client%20channels%3C%2FLI%3E%3C%2FUL%3E%3CP%3EBy%20the%20way%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F35146%22%20target%3D%22_blank%22%3E%40Scott%20Johnson%3C%2FA%3E%26nbsp%3Bif%20you%20buy%20Intune%2C%20you%20get%20rights%20to%20use%20Config%20Mgr%2C%20though%20it's%20still%20a%20hefty%20investment%20with%20hardware%20and%20expertise%20etc.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-37649%22%20slang%3D%22en-US%22%3ERe%3A%20O365%20admin%20portal%20reporting%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-37649%22%20slang%3D%22en-US%22%3E%3CP%3EDon't%20you%20think%20that%20this%20is%20something%20that%20should%20be%20available%20to%20tenant%20admins%20without%20paying%20an%20extra%20fee%20for%20the%20info%3F%20I%20do...%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-37551%22%20slang%3D%22en-US%22%3ERe%3A%20O365%20admin%20portal%20reporting%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-37551%22%20slang%3D%22en-US%22%3EDaniel%26nbsp%3Band%20%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F64%22%20target%3D%22_blank%22%3E%40Tony%20Redmond%3C%2FA%3E%26nbsp%3BMicrosoft%20Intune%20does%20a%20pretty%20good%26nbsp%3Bof%20giving%26nbsp%3Byou%20detail%20reports%20like%20specifically%20when%20a%20user%20last%20updated%20their%20office%2C%20and%20even%20which%26nbsp%3Bversion%20their%20currently%20running.%20Yes%20it's%20an%20extra%20charge%20(around%26nbsp%3B%249%2Fuser%2Fm)%20but%20would%20give%20you%20the%20information%20and%26nbsp%3Balso%20allow%26nbsp%3Byou%20to%20push%20out%20updates%20to%20specific%20users%20with%26nbsp%3Bout%20having%20to%20make%20an%20investment%20in%20System%20Center.%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-14026%22%20slang%3D%22en-US%22%3ERe%3A%20O365%20admin%20portal%20reporting%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-14026%22%20slang%3D%22en-US%22%3Ethank%20you%20for%20the%20input%20tony%2C%20We%20manage%20the%20updates%20locally%20and%20i%20want%20to%20push%20them%20to%20gorup%20of%20users%20and%20the%20version%20will%20be%20help%20full%20to%20decide%20he%20needs%20it%20and%20weho%20doesn't%20since%20we%20dont%20upgrade%20to%20the%20later%20version.%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-14025%22%20slang%3D%22en-US%22%3ERe%3A%20O365%20admin%20portal%20reporting%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-14025%22%20slang%3D%22en-US%22%3EThanks%20Juan%20carlos%2C%20but%20as%20Tony%20Redmond%20mentioned%20it%20only%20gives%20your%20the%20activations.%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-13844%22%20slang%3D%22en-US%22%3ERe%3A%20O365%20admin%20portal%20reporting%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-13844%22%20slang%3D%22en-US%22%3E%3CP%3EWell%2C%20the%20Office%20Activations%20report%20seems%20to%20show%20whether%20a%20user%20has%20downloaded%20and%20activated%20Office%20desktop%20click-to-run%2C%20but%20it%20doesn't%20show%20the%20version%20number%20in%20use%20(could%20be%20important%20if%20you%20want%20to%20check%20lingering%20updates%20required%20for%20new%20functionality)%2C%20nor%20does%20it%20show%20anything%20about%20MSI%20versions%20of%20Office%20(as%20far%20as%20I%20can%20tell)%20or%20whether%20old%20versions%20of%20Office%20(before%202016)%20are%20used.%20I%20also%20don't%20trust%20the%20dates%20because%20I%20can%20see%20an%20entry%20(in%20my%20tenant)%20for%20a%20user%20who%20apparently%20activated%20Office%202016%20for%20Mac%20on%2010%20Nov%202014.%20It%20probably%20is%20that%20this%20is%20the%20date%20that%20Office%20for%20Mac%20was%20first%20activated%20on%20the%20machine%20and%20the%20date%20wasn't%20changed%20when%20subsequent%20updates%20were%20applied...%20I%20also%20see%20three%20activations%20for%20Office%20on%20Windows%20Phone%20for%20my%20account%20(but%20I%20have%20one%20phone)%20and%201%20for%20iOS%20(I've%20activated%20on%20at%20least%20one%20iPhone%20and%20an%20iPad).%20%26nbsp%3BIn%20short%2C%20some%20of%20the%20data%20is%20a%20mystery...%20and%20because%20you%20can't%20drill%20down%20into%20the%20data%20to%20check%20what%20lies%20beneath%2C%20it%20will%20remain%20a%20mystery.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20don't%20believe%20that%20any%20of%20the%20third-party%20reporting%20products%20do%20any%20better.%20This%20is%20because%20they%20all%20depend%20on%20data%20provided%20by%20Microsoft%20through%20a%20reporting%20API...%20and%20that's%20what%20Microsoft%20is%20reporting%20here%20too.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-13753%22%20slang%3D%22en-US%22%3ERe%3A%20O365%20admin%20portal%20reporting%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-13753%22%20slang%3D%22en-US%22%3EHave%20you%20checked%20the%20Office%20activations%20usage%20report%3F%20I%20think%20is%20what%20you%20are%20looking%20for%3C%2FLINGO-BODY%3E
New Contributor

Is ther a way to get a report from the admin portal wiht he version of Micosoft office that is being used by the users?

If not, is this on the road map?

7 Replies
Highlighted
Have you checked the Office activations usage report? I think is what you are looking for
Highlighted

Well, the Office Activations report seems to show whether a user has downloaded and activated Office desktop click-to-run, but it doesn't show the version number in use (could be important if you want to check lingering updates required for new functionality), nor does it show anything about MSI versions of Office (as far as I can tell) or whether old versions of Office (before 2016) are used. I also don't trust the dates because I can see an entry (in my tenant) for a user who apparently activated Office 2016 for Mac on 10 Nov 2014. It probably is that this is the date that Office for Mac was first activated on the machine and the date wasn't changed when subsequent updates were applied... I also see three activations for Office on Windows Phone for my account (but I have one phone) and 1 for iOS (I've activated on at least one iPhone and an iPad).  In short, some of the data is a mystery... and because you can't drill down into the data to check what lies beneath, it will remain a mystery.

 

I don't believe that any of the third-party reporting products do any better. This is because they all depend on data provided by Microsoft through a reporting API... and that's what Microsoft is reporting here too.

Highlighted
Thanks Juan carlos, but as Tony Redmond mentioned it only gives your the activations.
Highlighted
thank you for the input tony, We manage the updates locally and i want to push them to gorup of users and the version will be help full to decide he needs it and weho doesn't since we dont upgrade to the later version.
Highlighted
Daniel and @Tony Redmond  Microsoft Intune does a pretty good of giving you detail reports like specifically when a user last updated their office, and even which version their currently running. Yes it's an extra charge (around $9/user/m) but would give you the information and also allow you to push out updates to specific users with out having to make an investment in System Center.
Highlighted

Don't you think that this is something that should be available to tenant admins without paying an extra fee for the info? I do...

Highlighted

To chime in, yes this would be good and it would be a useful addition, you shouldn't really have to spend extra for this.  Even more so as channel versions become unsupported, like 1602 next month and making sure all PCs are on the right version.  This info isn't available either from the Power BI Office 365 Adoption pack by the way.

 

Saying that, Configuration Manager now comes with some great reporting with the Office 365 Client Management dashboard (as well as deployment and update features for O365 ProPlus), showing 

 

  • Number of Office 365 clients
  • Office 365 client versions
  • Office 365 client channels

By the way @Scott Johnson if you buy Intune, you get rights to use Config Mgr, though it's still a hefty investment with hardware and expertise etc.