Pull a report of Integrated Apps in Office365/Microsoft365

[PoorMens_Bravo]

Hi,

I know that i can navigate into admin center and have a look at the Integrated apps that are available in my tenant. However i want to know that is there a powershell way to generate a report of these integrated apps

[#2 · Accepted solution]

@PoorMens_Bravo 

Yes, by using Centralized Deployment PowerShell 

Import-Module -Name O365CentralizedAddInDeployment

Example:

New-OrganizationAddIn -ManifestPath 'C:\Users\YOURANME\Desktop\task.xml' -Locale 'en-US' -Members 'email address removed for privacy reasons', 'email address removed for privacy reasons'

[#3]

@Kidd_lp
Thank you for that and it literally saved me a big time. I installed this module and ran
Get-OrganizationAddin -getalldetails -verbose

This will show up the intagrated addons, but the limitation is it only shows the ones for which the Status is Ok, i would want to fetch the addons for the status are not ok as well. I am not sure how to modify this.

[#4]

@PoorMens_Bravo 
Ok finally i was able to find out that webapps, Teams deployed add-ins will not be listed from this command and also the 'admin' add-in too.

This was the command i finally used to build a report:

Get-OrganizationAddIn | ForEach-Object {

    Get-OrganizationAddIn -ProductId $_.ProductId
} | select ProductId,DisplayName,DefaultStateForUser,Type,@{Name="OfficeProducts";e={$_.OfficeProducts -join ";"}},@{Name="AssignedGroups";e={$_.AssignedGroups -join "|"}},@{Name="AssignedUsers";e={$_.AssignedUsers -join "|"}} | Export-Csv -Path "C:\Temp\OrgAddins-$(Get-Date -Format ddMMMyyyy-HHmmss).csv" -NoTypeInformation

However, i am now really struggling to find the owners of the apps listed here.