How-To Guide: Tenant Manager - Large Tenants - Find Bamboo All Stats Sites PowerShell Script

If you see the following message when trying to load Analytics Data in Bamboo Tenant Manager:

⚠️ Warning: Large Tenant. Please use the powershell script to add the site to the cache.

You will need to use the PowerShell script to add the SharePoint site to the Tenant Manager cache.

Please follow the instructions in this article for the prerequisites and steps needed to set up and run the PowerShell script.

Overview

This PowerShell script searches a SharePoint Online tenant for sites containing the Bamboo All Stats list. When a Bamboo All Stats list is found, the script records the Site Title, Site URL, and SharePoint Site ID.

The Bamboo Tenant Manager Analytics functionality uses this information for large SharePoint Online tenants.

---

1. Prerequisites

Before running the script, verify the following:

• PowerShell 7.4 or later is installed.
• The PnP.PowerShell module is installed.
• The ImportExcel module is installed if required by other scripts in the process.
• The account registering the application has permission to create an Entra ID App Registration.
• An administrator is available to provide API consent if required.
• The tenant has a SharePoint App Catalog.
• A secure location is available for the certificate files.
• Download "findBambooSites.ps1" located at the bottom of this Article

Install the Required Modules

Open PowerShell 7.4 or later and run:

Install PnP.PowerShell

Install-Module -Name PnP.PowerShell -Scope CurrentUser

Install ImportExcel

Install-Module -Name ImportExcel -Scope CurrentUser

---

2. Create the Certificate Folder

Create a folder to store the certificate:

New-Item -ItemType Directory -Path "C:\mycertificates" -Force

Important: The .PFX file contains the certificate's private key and must be stored securely. Do not share or upload the PFX file to an unsecured location.

---

3. Register the Entra ID Application

Run the following command, replacing [yourtenant] with the customer's Microsoft 365 tenant name:

Register-PnPEntraIDApp -ApplicationName "PnP.PowerShell" -Tenant [yourtenant].onmicrosoft.com -OutPath "C:\mycertificates"

Example

For a tenant named contoso.onmicrosoft.com:

Register-PnPEntraIDApp  -ApplicationName "PnP.PowerShell" -Tenant contoso.onmicrosoft.com -OutPath "C:\mycertificates"

Follow the Login instructions displayed by PowerShell and authenticate with an appropriate administrator account.

After the registration is complete, record the application's:

• Client ID
• Tenant ID

The certificate files will be saved to:

C:\mycertificates

---

4. Verify the Application

In Microsoft Entra:

1. Open App registrations.
2. Locate PnP.PowerShell.
3. Verify the certificate is listed under Certificates & secrets.
4. Verify the required API permissions have been configured.
5. Record the Client ID and Tenant ID if they were not already saved.
6. Grant administrator consent if required.

---

5. Update and Run the Script

Open the supplied:

findBambooSites.ps1

Update the following parameters in the script with the information from your environment:

-ClientId "YOUR-CLIENT-ID"

-TenantId "YOUR-TENANT-ID"

-CertificatePath "C:\mycertificates\PnP.PowerShell.pfx"

-TenantPrefix "YOURTENANT"

Parameter Information

ClientId
The Application (client) ID of the PnP.PowerShell application you created.

TenantId
The Directory (tenant) ID of your Microsoft 365 tenant.

CertificatePath
The path to the .PFX certificate created during application registration.

Example:

C:\mycertificates\PnP.PowerShell.pfx

TenantPrefix
The tenant prefix used by SharePoint Online.

For example, if your SharePoint Admin Center URL is:

https://contoso-admin.sharepoint.com

your Tenant Prefix is:

contoso

Run the Script

After updating the variables, save the script.

Open PowerShell 7.4 or later, navigate to the folder containing the script, and run:

.\findBambooSites.ps1

The script will search the SharePoint Online tenant for sites containing the Bamboo All Stats list.

---

6. Script Results

The script searches the tenant for a list named:

Bamboo All Stats

When the list is found, the script returns the following information:

• Site Title
• Site URL
• Site ID

The Site ID returned by the script is the SharePoint Site ID, not the Web ID.

---

7. Update the Bamboo Sites List

Once the script has completed, review the output and update the Bamboo Sites list in the tenant's SharePoint App Catalog Site Collection.

Enter the following information for each site returned by the script:

Field	Value
Site Title	Site Title returned by the script
Site URL	Site URL returned by the script
Site ID	Site ID returned by the script

This list will contain the sites where Bamboo All Stats was found.