Report SPPKG usage CSV all site collections and tenant wide

Demo how to report on SPPKG usage to CSV with both (1) tenant app catalog and (2) every site collection app catalog. For example, tenant app catalog may show only 6 SPPKG in SharePoint Admin Center but we really have 15 site collection catalogs with 45 total SPPKG. PowerShell PNP script here gives granular report with full SPPKG app detail. Cheers.

VIDEO

CODE

https://github.com/spjeff/office365/blob/master/SPJeff-Inventory-SPKG-Available.ps1

REFERENCES

Ultra wide Modern SharePoint homepage with CEWP+CSS

Microsoft offers “Full Width Section” with only 3 web parts.

Want to add more? Any web part? To Full Width Section then watch here step by step.

1) PNP add site App Catalog
2) Upload Modern CEWP
3) Apply HTML with CSS selector to reduce left and right blank space

Cheers

Source code at GitHub repo https://github.com/spjeff/office365/tree/master/spo-modern-CEWP-wide-CSS

VIDEO

REFERENCES

Centro 365 Must Have Chrome Extension for M365 Admins

Live demo for “Centro 365” Chrome Extension which gives fast bookmark access to all essential Microsoft 365 cloud endpoint URLs. SharePoint, PowerPlatform, Azure, Entra, Intune, PowerBI, Stream, and more. With so many M365 cloud services memorizing URLs has become challenging and Centro 365 delivers with fast way to jump to favorite administration screens. Cheers.

VIDEO

DOWNLOAD FOR CHROME

https://chrome.google.com/webstore/detail/centro-365/caajbiigelogfdelpmeldfjmanjjafac?hl=en-GB

DOWNLOAD FOR EDGE

https://microsoftedge.microsoft.com/addons/detail/centro-365/ampgmpmlobbbhjoplcbdfcgplbkbmked

DEVELOPER PROJECT

https://seanosullivan.co.uk/projects/centro365/

End User PowerShell – Create SharePoint fields from CSV. Provision schema demo.

Live coding demo for to Create SharePoint fields from CSV. Available to any end user and does not require SharePoint tenant admin, site collection admin, or high level access.

Provision list schema and create fields with DisplayName, InternalName, and Data Type from CSV input.

Cheers.

VIDEO

SOURCE CODE

Format-Table with row colors in PowerShell

How to run Format-Table in PowerShell and format output as table with color logic driven from cell value. Full code below. Cheers

VIDEO

SOURCE CODE

# List process and format as table
$proc = Get-Process
$proc | Format-Table @{
    # Add column "Name" to table
    Label = "Name"
    Expression = {
        if ($_.Name -eq "chrome") {
            # Format row color Green when Name is "chrome"
            $color = "32" # Green
        } else {
            # Format row color Red when Name is not "chrome"
            $color = "31" # Red
        }
        # Character 27 is ESC
        $e = [char]27
        # Format row with name and color
        "$e[${color}m$($_.Name)$e[0m"
    }
}, PID, CPU, PM, WS, VM, NPM, Path -AutoSize

Launch multiple M365 tenant PowerShell PNP console

Demo how to quickly launch multiple M365 tenant PowerShell PNP console. When supporting PROD, TEST, DEV lifecycle or have multiple M365 tenants we can leverage Devolutions Remote Desktop Manager (RDM) to have many PowerShell “profiles” and quickly authenticate with Client ID and Client Secret.

Great for M365, SharePoint Online SPO, and PowerPlatform tasks including:

  • View SharePoint sites
  • Increase SharePoint site quota
  • Grant SharePoint site administrator
  • Create SharePoint Site App Catalog
  • Generate CSV reports of sites and usage
  • Provision OneDrive users
  • Review M365 tenant security settings

Download RDM

https://devolutions.net/remote-desktop-manager/home/downloadfree

POWERSHELL

# Configuration
$SiteURL        = "https://TENANT-admin.sharepoint.com/"
$ClientID       = "GUID-HERE"
$ClientSecret   = "SECRET-HERE"
# Connect to the Site
Connect-PnPOnline -URL $SiteURL -ClientID $ClientID -ClientSecret $ClientSecret -WarningAction "Ignore"
Get-PnPTenantSite | Format-Table -AutoSize

VIDEO

SCREENSHOT

REFERENCES

https://medium.com/ng-sp/sharepoint-add-in-permission-xml-cheat-sheet-64b87d8d7600

https://pnp.github.io/powershell/

https://pnp.github.io/powershell/cmdlets/Connect-PnPOnline.html

Return to Top ▲Return to Top ▲