New add-in inventory report for Configuration Manager

%3CLINGO-SUB%20id%3D%22lingo-sub-110571%22%20slang%3D%22en-US%22%3ENew%20add-in%20inventory%20report%20for%20Configuration%20Manager%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-110571%22%20slang%3D%22en-US%22%3E%3CP%3EToday%20a%20new%20report%20was%20released%20to%20the%20GitHub%20community%20site%20that%20allows%20you%20to%20collect%20and%20view%20an%20inventory%20of%20the%20Office%20Add-ins%20that%20are%20in%20use%20by%20the%20clients%20that%20you%20manage%20with%20System%20Center%20Configuration%20Manager%20(2012%20R2%20or%20later).%3C%2FP%3E%0A%3CP%3EThis%20report%20gathers%20the%26nbsp%3Binventory%20of%20each%20Office%20add-in%20that%20is%20installed%20as%20well%20as%20the%20device%20that%20has%20it%20installed%20and%20the%20status%20(enabled%2C%20disabled)%20allowing%20you%20to%20determine%20which%20add-ins%20are%20in%20use%20as%20well%20as%20the%20impact%20based%20on%20the%20number%20of%20installations.%26nbsp%3B%20This%20report%20also%20provides%20a%20link%26nbsp%3Bto%20Microsoft's%20Office%20ProPlus%20Add-in%20Readiness%20report%20which%20you%20can%20view%20from%20%3CA%20href%3D%22http%3A%2F%2Faka.ms%2Faddinreadiness%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%22%3Ehttp%3A%2F%2Faka.ms%2Faddinreadiness%3C%2FA%3E.%3CBR%20%2F%3E%3C%2FP%3E%0A%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20style%3D%22width%3A%20795px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F20996i4E540B084590FDB8%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20alt%3D%22ShowCountOfEachAddIn-2.PNG%22%20title%3D%22ShowCountOfEachAddIn-2.PNG%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3ETo%20get%20this%20new%20report%2C%20download%20it%20directly%20from%20GitHub%20at%20%3CA%20href%3D%22https%3A%2F%2Fna01.safelinks.protection.outlook.com%2F%3Furl%3Dhttps%253A%252F%252Fgithub.com%252FOfficeDev%252FOffice-IT-Pro-Deployment-Scripts%252Ftree%252Fmaster%252FOffice-ProPlus-Management%252FGet-OfficeAddins%26amp%3Bdata%3D02%257C01%257CChris.Hopkins%2540microsoft.com%257C1d2c3a608dbd46fa6eb508d500421e57%257C72f988bf86f141af91ab2d7cd011db47%257C1%257C0%257C636415206336424775%26amp%3Bsdata%3Dnelr1O6hkt6%252B%252BwbJg9b3LFixWir9W9%252FJwsOb8%252BhXNro%253D%26amp%3Breserved%3D0%22%20target%3D%22_blank%22%20rel%3D%22nofollow%20noopener%20noreferrer%22%3Ehttps%3A%2F%2Fgithub.com%2FOfficeDev%2FOffice-IT-Pro-Deployment-Scripts%2Ftree%2Fmaster%2FOffice-ProPlus-Management%2FGet-OfficeAddins%3C%2FA%3E%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-110571%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EAdmin%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EProPlus%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1806041%22%20slang%3D%22en-US%22%3ERe%3A%20New%20add-in%20inventory%20report%20for%20Configuration%20Manager%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1806041%22%20slang%3D%22en-US%22%3E%3CP%3EHad%20to%20adjust%20the%20report%20files%20with%20report%20builder%20as%20they%20had%20a%20hard%20coded%20database%20name%20of%20CM_S01%2C%20but%20this%20works%20great!%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1809935%22%20slang%3D%22en-US%22%3ERe%3A%20New%20add-in%20inventory%20report%20for%20Configuration%20Manager%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1809935%22%20slang%3D%22en-US%22%3E%3CP%3Efound%20a%20slight%20problem%20here...%20It%20does%20not%20record%20addins%20that%20come%20from%20the%20microsoft%20store.%20This%20appears%20to%20only%20capture%20COM%20addins%20that%20are%20installed%20on%20the%20machine.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThis%20makes%20it%20useless%20for%20me%2C%20because%20we%20had%20the%20setting%20turned%20on%20that%20people%20could%20install%20applications%20from%20the%20microsoft%20store%20and%20the%20end%20goal%20here%20is%20for%20me%20to%20figure%20out%20who%20has%20done%20that%20and%20what%20they%20are%20using.%20This%20does%20not%20appear%20to%20work%20for%20this%20purpose.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1813351%22%20slang%3D%22en-US%22%3ERe%3A%20New%20add-in%20inventory%20report%20for%20Configuration%20Manager%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1813351%22%20slang%3D%22en-US%22%3E%3CP%3Efound%20this%20article%20now%2C%20and%20it%20shows%20you%20with%20one%20power%20shell%20command%2C%20how%20to%20extract%20this%20information%20from%20exchange%20and%20dump%20it%20into%20a%20CSV.%20even%20goes%20over%20how%20to%20create%20a%20nice%20pivot%20table%20chart!%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Fwww.howto-outlook.com%2Fhowto%2Freport-office-store-app-usage.htm%22%20target%3D%22_blank%22%20rel%3D%22noopener%20nofollow%20noreferrer%22%3Ehttps%3A%2F%2Fwww.howto-outlook.com%2Fhowto%2Freport-office-store-app-usage.htm%3C%2FA%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EHere%20is%20the%20command%20incase%20that%20page%20goes%20defunct%3A%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CPRE%20class%3D%22lia-code-sample%20language-powershell%22%3E%3CCODE%3EGet-Mailbox%20-ResultSize%20Unlimited%20%7C%20ForEach-Object%20%7BGet-App%20-Mailbox%20%24_.identity%20%7C%20Select-Object%20-Property%20DisplayName%2C%20Enabled%2C%20AppVersion%20%7C%20Export-Csv%20applist-export.csv%20-NoTypeInformation%20-Append%7D%3C%2FCODE%3E%3C%2FPRE%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3Eyou%20could%20easily%20tweak%20that%20to%20find%20which%20user%20has%20what%20plugin%20too.%3C%2FP%3E%3C%2FLINGO-BODY%3E
Microsoft

Today a new report was released to the GitHub community site that allows you to collect and view an inventory of the Office Add-ins that are in use by the clients that you manage with System Center Configuration Manager (2012 R2 or later).

This report gathers the inventory of each Office add-in that is installed as well as the device that has it installed and the status (enabled, disabled) allowing you to determine which add-ins are in use as well as the impact based on the number of installations.  This report also provides a link to Microsoft's Office ProPlus Add-in Readiness report which you can view from http://aka.ms/addinreadiness.

ShowCountOfEachAddIn-2.PNG

 

To get this new report, download it directly from GitHub at https://github.com/OfficeDev/Office-IT-Pro-Deployment-Scripts/tree/master/Office-ProPlus-Management/...

 

 

4 Replies

Had to adjust the report files with report builder as they had a hard coded database name of CM_S01, but this works great!

 

found a slight problem here... It does not record addins that come from the microsoft store. This appears to only capture COM addins that are installed on the machine.

 

This makes it useless for me, because we had the setting turned on that people could install applications from the microsoft store and the end goal here is for me to figure out who has done that and what they are using. This does not appear to work for this purpose.

found this article now, and it shows you with one power shell command, how to extract this information from exchange and dump it into a CSV. even goes over how to create a nice pivot table chart!

 

https://www.howto-outlook.com/howto/report-office-store-app-usage.htm

 

Here is the command incase that page goes defunct:

 

Get-Mailbox -ResultSize Unlimited | ForEach-Object {Get-App -Mailbox $_.identity | Select-Object -Property DisplayName, Enabled, AppVersion | Export-Csv applist-export.csv -NoTypeInformation -Append}

 

you could easily tweak that to find which user has what plugin too.

I'm running into to same issue. I'm getting this message when trying to run the report "Invalid object name 'CM_S01.dbo.Custom_OfficeAddins_DATA'". I tried replacing "CM_S01" with my database name but I'm getting the same error. Did you have to replace more than just "CM_S01"? Thanks