How to find SPO sites that have 3rd party apps installed

Romila baretto 136 Reputation points
2023-05-03T11:34:37.9266667+00:00

How can i get a list of all sites within our o365 tenant that have this (or other 3rd party apps) installed?

SharePoint
SharePoint
A group of Microsoft Products and technologies used for sharing and managing content, knowledge, and applications.
7,117 questions
0 comments No comments
{count} votes

2 answers

Sort by: Most helpful
  1. Yanli Jiang - MSFT 10,921 Reputation points Microsoft Vendor
    2023-05-04T03:05:00.4866667+00:00

    Hi @Romila baretto ,

    If you want to get app list from tenant level, you can use this pnp PowerShell command.

    Get-PnPApp

    Here's what I tested:

    Connect-PnPOnline -Url "https://tenant-admin.sharepoint.com/" -Credentials $cred
    Get-PnPApp
    
    

    05041

    If you have enabled MFA, you can Change the parameters from

    -Credentials $cred to -UseWebLogin.

    And I found a similar post for your reference:

    https://sharepoint.stackexchange.com/questions/279159/how-to-find-spo-sites-that-have-3rd-party-apps-installed

    Note: Microsoft is providing this information as a convenience to you. The sites are not controlled by Microsoft. Microsoft cannot make any representations regarding the quality, safety, or suitability of any software or information found there. Please make sure that you completely understand the risk before retrieving any suggestions from the above link. 


    If the answer is helpful, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".

    Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.


  2. Yanli Jiang - MSFT 10,921 Reputation points Microsoft Vendor
    2023-05-09T08:26:05.14+00:00

    Hi @Romila baretto ,

    Please try this:

    #Set Parameter
    $TenantSiteURL="https://domain.sharepoint.com"
     
    #Connect to the Tenant site
    Connect-PnPOnline $TenantSiteURL -Credentials (Get-Credential)
     
    #sharepoint online pnp powershell get all sites
    $sites=Get-PnPTenantSite
    
    
    foreach($site in $sites)
    {
    
    
    $web = Get-PnPWeb –Includes AppTiles
    
    $appTiles = $web.AppTiles
    Invoke-PnPQuery
    
    foreach ($appTile in $appTiles)
    {
        $appTitle = $appTile.AppTitle
        $appType = $appTile.AppType
        $appStatus = $appTile.AppStatus
        $appSource = $appTile.AppSource
        $isCorporateCatalogSite = $appTile.IsCorporateCatalogSite
    
        if ($appType -eq "Instance")
        {
            $appTile
        }
    }
    write $appTile
    }
    
    

    For more information, please refer to:

    https://gist.github.com/OlafD/75dedc9820076f7acf2a1cd331c80ca8


    If the answer is helpful, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".

    Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.