Expand and Refresh CLI for Microsoft 365 Script Coverage

[Adam-it]

In PnP Script Sample repo, many scenarios lack any CLI for Microsoft 365 example, and others rely on an old version of CLI for Microsoft 365. We want to close those gaps so contributors have a current, high-quality CLI for Microsoft 365 guidance alongside existing PowerShell samples.

Goal

1. For most script samples that currently only provide a PnP PowerShell version, add a corresponding CLI for Microsoft 365 implementation.spo-remove-orphaned-redirect-sites
2. Review existing CLI for Microsoft 365 script samples that still reference versions older than v10.x, updating them to the latest release while improving code quality where needed.

Tasks for refreshing older CLI samples

CLI v3.x

• scripts/aad-guest-signin-activity (3.7.0) --> 🏗️ In Progress
• scripts/create-comm-sites-specific-locale (3.7.0)
• scripts/flow-runs-status-list-dashboard (3.7.0) --> 🏗️ In Progress
• scripts/get-all-site-collections-subwebs (3.7.0) --> 🏗️ In Progress
• scripts/graph-call-graph (3.7.0)
• scripts/graph-get-teams-tabs-export-to-csv (3.7.0)
• scripts/reset-files-permission-unique-to-inherited (3.7.0) --> 🏗️ In Progress
• scripts/spo-add-multiple-lists-using-csv-file (3.7.0)
• scripts/spo-cleanup-site-column-usage (3.7.0) --> Refactors script - 'spo cleanup site column usage' #886
• scripts/spo-generate-demo-events (3.7.0) --> 🏗️ In Progress
• scripts/spo-get-and-export-list-fields (3.7.0) --> 🏗️ In Progress
• scripts/spo-get-lists-libraries-item-count-permissions (3.7.0)) --> 🏗️ In Progress
• scripts/spo-list-items-large-lists (3.7.0) --> 🏗️ In Progress
• scripts/teams-full-report (3.7.0) --> 🏗️ In Progress
• scripts/spo-remove-teamify-link (3.8.0)

CLI v4.x

• scripts/spo-add-site-design-with-custom-list (4.1.0)--> 🏗️ In Progress
• scripts/aad-analyze-users-hibp (4.3.0)
• scripts/spo-create-bulk-libraries (4.3.0)
• scripts/spo-search-export-to-csv (4.3.0) --> 🏗️ In Progress
• scripts/teams-export-teams-information (4.3.0)--> 🏗️ In Progress

CLI v5.x

• scripts/create-dummy-docs-versions-in-library (5.3.0) --> Refactors script spo-add-dummy-folders-and-files #890
• scripts/fetch-user-profile-properties (5.3.0) --> 🏗️ In Progress
• scripts/spo-export-sharepoint-list-items-to-csv (5.3.0)--> 🏗️ In Progress
• scripts/spo-get-list-library-permission-export-to-csv (5.3.0)
• scripts/spo-install-deploy-spfx-solution (5.3.0) --> 🏗️ In Progress
• scripts/spo-modern-page-publishing-report (5.3.0)
• scripts/spo-set-home-site (5.3.0)
• scripts/teams-bulk-create-teams (5.3.0)
• scripts/m365-get-unifiedlog-spo-dlp-exchange-entra (5.4.0)
• scripts/planner-copy-planner-plan (5.4.0) --> 🏗️ In Progress
• scripts/planner-migration-spo-list (5.4.0) ) --> 🏗️ In Progress
• scripts/spo-copy-library-view (5.4.0)
• scripts/spo-list-site-externalusers-in-groups (5.4.0) --> 🏗️ In Progress
• scripts/aad-get-app-permission (5.5.0)
• scripts/copilot-studio-assets-automation (5.6.0)
• scripts/flow-how-to-automate-your-flow-test (5.6.0)
• scripts/spo-export-termstore-terms-to-csv (5.6.0)
• scripts/teams-export-channel-conversations-to-html (5.6.0)
• scripts/tenant-governance-compliance-report (5.6.0)
• scripts/tenant-health-notify-teams (5.6.0)
• scripts/spo-delete-orphaned-temporary-sitepages (5.9.0)
• scripts/bulk-undelete-from-recyclebin --> 🏗️ In Progress --> 🐞 used stage in site recyclebinitem list which does not exist, should use --secondary flag

CLI v6.x

• scripts/ReportTermUse (6.1.0) --> 🏗️ In Progress
• scripts/spo-enable-site-collection-app-catalog (6.2.0)
• scripts/spo-export-file-shared-links (6.2.0)
• scripts/spo-get-message-centre-announcements-and-post-to-teams-channel (6.2.0)
• scripts/spo-apply-json-view-formatting (6.3.0)
• scripts/spo-export-upa-accounts (6.3.0)
• scripts/spo-remove-site-scripts (6.3.0)
• scripts/spo-activate-site-feature (6.6.0) --> 🏗️ In Progress
• scripts/spo-add-app-catalog (6.6.0)
• scripts/spo-add-page-template (6.6.0)
• scripts/spo-associate-multiple-sites-to-hub (6.6.0)
• scripts/spo-remove-page-title-area (6.6.0)
• scripts/spo-remove-site-designs (6.6.0)
• scripts/spo-update-page-banner-image (6.6.0)
• scripts/spo-add-update-image-column (6.7.0)
• scripts/spo-allow-custom-scripts (6.7.0) --> 🏗️ In Progress
• scripts/spo-create-sharepoint-groups-bulk-csv (6.7.0)
• scripts/spo-disable-list-comments (6.7.0 (beta)) --> 🏗️ In Progress
• scripts/spo-empty-recycle-bin (6.7.0 (beta))
• scripts/spo-empty-tenant-recyclebin (6.7.0)
• scripts/spo-hide-list-from-site-contents (6.7.0)
• scripts/spo-list-download-contenttype-documenttemplate (6.7.0) --> 🏗️ In Progress
• scripts/spo-open-doc-in-client (6.7.0)
• scripts/spo-remove-custom-themes (6.7.0) --> 🏗️ In Progress
• scripts/teams-list-teams-owners-and-members (6.7.0)
• scripts/remove-delete-option-library (6.8.0)
• scripts/spo-copy-list (6.8.0)
• scripts/spo-disable-list-comments-tenant (6.8.0 (beta))
• scripts/spo-download-files-and-archive (6.8.0)
• scripts/spo-add-formextension-to-list (6.9.0 (beta))
• scripts/spo-file-version-trimmer (6.9.0)
• scripts/power-automate-replace-owner (6.11.0)
• scripts/spo-create-colored-folder (6.11.0)
• scripts/spo-create-library-add-contenttype (6.11.0)
• scripts/generate-markdown-lcids (6.14.22)
• scripts/report-private-teams-excel (6.14.22) --> 🏗️ In Progress
• scripts/spo-add-document-library-webpart-to-page (6.14.22) --> 🏗️ In Progress
• scripts/spo-add-sppkg-ad-app-certificate (6.14.22)
• scripts/spo-add-tenant-theme (6.14.22)
• scripts/spo-export-data-to-sharepoint-lists (6.14.22) --> 🏗️ In Progress
• scripts/spo-list-items-with-caml-query (6.14.22)

CLI v7.x

• scripts/spo-add-fields-to-contenttypes (7.0.0) --> Refactors spo add fields to contenttype #889
• scripts/spo-bulk-creation-sharepoint-sites-csv (7.0.0)
• scripts/spo-enable-disable-search-crawling (7.0.0)
• scripts/spo-list-disable-quick-property-editing (7.0.0)
• scripts/spo-add-bulk-users-to-groups (7.3.0) --> 🏗️ In Progress
• scripts/spo-add-dummy-folders-and-files (7.3.0)
• scripts/spo-add-multiple-folders-in-libraries-using-csv-file (7.3.0) --> 🏗️ In Progress
• scripts/spo-register-org-assets-library (7.3.0)
• scripts/spo-remove-org-assets-library (7.3.0)
• scripts/aad-delete-m365-groups-and-sharepoint-sites (7.5.0) --> 🚫Blocked (related issue: Bug report: entra m365group remove does not work cli-microsoft365#7054)
• scripts/aad-replace-owner-with-a-different-one (7.5.0) --> Refactors aad replace owner with a different one #888
• scripts/spo-check-unaccessable-homepages (7.5.0)
• scripts/spo-export-content-type-details-to-csv (7.5.0)
• scripts/spo-get-customfields-lists (7.5.0)
• scripts/spo-reindex-sites (7.5.0)
• scripts/aad-ensure-ownersaremembers-m365groups --> Refactors aad ensure ownersaremembers m365groups #887

CLI v9.x

• scripts/spo-download-files-from-doclib (9.1.0)

Tasks for new scripts

Entra ID

• scripts/aad-control-guestaccount-m365-groups-teams --> 🏗️ In Progress
• scripts/aad-get-duplicate-m365group --> 🏗️ In Progress
• scripts/aad-get-tenantid
• scripts/aad-grant-serviceprincipal-api-permissions
• scripts/aad-renew-m365-group --> 🏗️ In Progress
• scripts/aad-replace-membership-of-selected-groups
• scripts/aad-update-m365-global-unified-settings --> 🏗️ In Progress
• scripts/get-disabled-or-inactive-user-accounts

Power Automate (Flow)

• scripts/flow-export-all-flows-in-environment
• scripts/flow-runs-day-summary

Microsoft Teams

• scripts/teams-clone-team
• scripts/teams-createteam-from-template
• scripts/teams-force-filestab-provision
• scripts/teams-get-channel-spo-urls
• scripts/teams-get-templates
• scripts/teams-list-all-app-descriptions
• scripts/teams-list-ownerless-teams

OneDrive

• scripts/export-onedrive-sites-details-to-csv
• scripts/onedrive-export-admins --> 🏗️ In Progress

SharePoint Online (General)

• scripts/spo-export-hub-site-hierarchy --> New script spo time based file reports #937
• scripts/bulk-restore-from-recyclebin
• scripts/create-dummy-docs-in-library
• scripts/export-data-from-microsoft-search
• scripts/export-inactive-sites-based-on-days-to-csv
• scripts/get-spo-invalid-user-accounts
• scripts/modernize-blog-pages
• scripts/modernize-bulk-publishing-pages
• scripts/modernize-classic-pages-from-publishing-sites
• scripts/pnp-modern-searchv3-scanner

SharePoint Online (SPO-prefixed)

• scripts/spo-add-contenttypehub-format-field-to-List --> 🏗️ In Progress
• scripts/spo-add-demo-content-from-site
• scripts/spo-add-language-settings
• scripts/spo-add-modern-calendar-view--> 🏗️ In Progress
• scripts/spo-add-multiple-document-libraries-with-list-template --> 🏗️ In Progress --> wrong approach
• scripts/spo-add-sitedesign-permissions
• scripts/spo-apply-OOB-sitedesign
• scripts/spo-apply-pnptemplate-with-files-and-listitems
• scripts/spo-apply-pnptemplate-with-parameters
• scripts/spo-apply-site-theme --> New script spo apply site theme #912
• scripts/spo-bulk-delete-recyclebin-in-batch-avoid-lvt
• scripts/spo-bulk-import-data
• scripts/spo-bulk-publish-syntex-model --> 🏗️ In Progress
• scripts/spo-bulk-remove-retention-labels --> 🏗️ In Progress
• scripts/spo-change-list-url
• scripts/spo-change-retention-labels --> 🏗️ In Progress
• scripts/spo-clean-comments
• scripts/spo-compare-files --> New script spo compare files #913
• scripts/spo-configure-documentid-feature
• scripts/spo-copy-directory-structure-to-sharepoint-list --> 🏗️ In Progress
• scripts/spo-copy-hubsite-navigation
• scripts/spo-copy-library-across-tenants
• scripts/spo-copy-webpart-settings --> 🏗️ In Progress
• scripts/spo-copy-webparts-to-another-page --> 🏗️ In Progress
• scripts/spo-create-documentset
• scripts/spo-create-modern-pages-add-web-parts --> 🏗️ In Progress
• scripts/spo-create-multi-hub-sites
• scripts/spo-csom-properties
• scripts/spo-delete-companywide-anonymous-sharinglink --> 🏗️ In Progress
• scripts/spo-delete-empty-folders --> 🏗️ In Progress
• scripts/spo-delete-expired-sharing-link-folder-file-item
• scripts/spo-delete-hub-and-sites --> 🏗️ In Progress
• scripts/spo-delete-sharinglink-folder-file-item
• scripts/spo-delete-site-with-retention-policy
• scripts/spo-deploy-install-update-spfx-hubsite-associatedsites --> 🏗️ In Progress
• scripts/spo-deploy-install-update-spfx-hubsiteassociatedsites-tenantappcatalog
• scripts/spo-deploy-pnpmodernsearch-webpart
• scripts/spo-deploy-sppkgs-and-install-apps --> 🏗️ In Progress
• scripts/spo-detect-theme
• scripts/spo-dev-agent-config-creation
• scripts/spo-dev-tenant-report-export
• scripts/spo-disable-template-dialog --> 🏗️ In Progress
• scripts/spo-document-sets-modern-new-form
• scripts/spo-documentset-configuration
• scripts/spo-download-all-doclibs --> 🏗️ In Progress
• scripts/spo-download-sppkgs
• scripts/spo-enable-disable-app-bar
• scripts/spo-enable-page-scheduling
• scripts/spo-ensure-cts-before-template
• scripts/spo-export-all-customformatting
• scripts/spo-export-all-site-pages-details
• scripts/spo-export-author-byline-users --> 🏗️ In Progress
• scripts/spo-export-basic-sitecollection-info --> 🏗️ In Progress
• scripts/spo-export-checked-out-files-in-all-sites-associated-with-a-hub-site-to-csv --> 🏗️ In Progress
• scripts/spo-export-checked-out-files-in-tenant-using-search
• scripts/spo-export-duplicate-files --> 🏗️ In Progress
• scripts/spo-export-import-folderstructure
• scripts/spo-export-page-html --> 🏗️ In Progress
• scripts/spo-export-people-web-part-users --> 🏗️ In Progress
• scripts/spo-export-report-files-incidents
• scripts/spo-export-site-all-content
• scripts/spo-export-sitecollection-permission-with-subwebs
• scripts/spo-export-space-page-as-template-and-save-to-sharepoint
• scripts/spo-export-stream-classic-webparts
• scripts/spo-extract-and-invoke-site-template
• scripts/spo-extract-modern-pages
• scripts/spo-find-links-in-canvas
• scripts/spo-find-script-editor-webpart-using-search
• scripts/spo-find-site-creationsource --> 🏗️ In Progress
• scripts/spo-find-spfx-packages-installed-tenant-sitecollection-appcatalog --> 🏗️ In Progress
• scripts/spo-find-web-part-in-pages --> 🏗️ In Progress
• scripts/spo-generate-sp-file-count-report --> 🏗️ In Progress
• scripts/spo-get-agent-list --> 🏗️ In Progress
• scripts/spo-get-all-hub-site-main-sites-and-navigation-nodes
• scripts/spo-get-canonical-url-from-sharinglink --> 🏗️ In Progress
• scripts/spo-get-checkedoutfiles-nocheckedinversion --> 🏗️ In Progress
• scripts/spo-get-contenttype-usage-listitem-listversion
• scripts/spo-get-details-spfx-packages-tenant-sitecollection-appcatalog --> 🏗️ In Progress
• scripts/spo-get-everyone-everyoneexceptexternalusers --> 🏗️ In Progress
• scripts/spo-get-existing-site-structure
• scripts/spo-get-files-and-creators-modifiers --> 🏗️ In Progress
• scripts/spo-get-files-retentionlabel-sensitivitylabel --> 🏗️ In Progress
• scripts/spo-get-folder-item --> 🏗️ In Progress
• scripts/spo-get-items-not-indexed-since-last-update
• scripts/spo-get-items-with-custom-permissions
• scripts/spo-get-libraries-with-webhooks --> 🏗️ In Progress
• scripts/spo-get-list-item-version-history
• scripts/spo-get-permission-audit --> 🏗️ In Progress
• scripts/spo-get-sharepoint-storage-currentquota --> 🏗️ In Progress
• scripts/spo-get-sharinglinks --> 🏗️ In Progress
• scripts/spo-get-site-list-ids --> 🏗️ In Progress
• scripts/spo-get-site-sharing-settings --> 🏗️ In Progress
• scripts/spo-get-siteid-from-microsoftgraph --> 🏗️ In Progress
• scripts/spo-get-sites-membership-report --> 🏗️ In Progress
• scripts/spo-get-sites-with-unique-permissions --> 🏗️ In Progress
• scripts/spo-get-sp-site-page-viewers-details
• scripts/spo-get-spfx-apipermissions
• scripts/spo-get-storage-site-versionsrecyclebin --> 🏗️ In Progress
• scripts/spo-get-usage-from-audit-logs --> 🏗️ In Progress
• scripts/spo-grant-app-site-permission
• scripts/spo-import-csv-data-to-existing-sharepoint-list --> 🏗️ In Progress
• scripts/spo-import-taxonomy-terms-labels
• scripts/spo-large-list-items-to-pnp-template
• scripts/spo-list-formatting
• scripts/spo-list-site-externalusers --> 🏗️ In Progress
• scripts/spo-list-spfx-field-customizer
• scripts/spo-list-update-contenttype-systemupdate
• scripts/spo-locate-orphaned-termstore-terms
• scripts/spo-mailchimp-integration
• scripts/spo-modern-page-url-report --> 🏗️ In Progress
• scripts/spo-most-recent-update-report --> 🏗️ In Progress
• scripts/spo-move-files-library-sites
• scripts/spo-multiline-field-properties --> 🏗️ In Progress
• scripts/spo-pin-field-filterpane --> 🏗️ In Progress
• scripts/spo-provision-folders-libraries
• scripts/spo-provision-homepage
• scripts/spo-quicklink-wp-creator
• scripts/spo-record-lock-unlock-file --> 🏗️ In Progress
• scripts/spo-recover-meeting-recordings
• scripts/spo-register-app-login-using-app
• scripts/spo-reindex-list-where-term-is-used
• scripts/spo-remote-event-receivers
• scripts/spo-remove-access-requests --> 🏗️ In Progress
• scripts/spo-remove-list-designs
• scripts/spo-remove-orphaned-redirect-sites --> 🏗️ In Progress
• scripts/spo-remove-webpart-from-pages --> 🏗️ In Progress
• scripts/spo-rename-hub-siteurl --> 🏗️ In Progress
• scripts/spo-reorder-list-content-type
• scripts/spo-repair-user-idmismatch
• scripts/spo-replace-people-in-people-web-part
• scripts/spo-request-pnp-reindex-user-profile
• scripts/spo-restore-multiple-items --> 🏗️ In Progress
• scripts/spo-retrieve-effectivepermissions-user
• scripts/spo-revoke-app-site-permission --> Adds CLI for Microsoft 365 script for spo revoke app site permission sample #922
• scripts/spo-run-jobs-in-parallel
• scripts/spo-search-change-placeholder-text
• scripts/spo-serviceprincipals-sites.selected-permission-sites
• scripts/spo-set-page-authorbyline --> 🏗️ In Progress
• scripts/spo-set-sharepoint-regional-settings
• scripts/spo-setup-example-site --> 🏗️ In Progress
• scripts/spo-sharepoint-alerts-audit
• scripts/spo-tenant-site-inventory
• scripts/spo-time-based-file-reports --> 🏗️ In Progress
• scripts/spo-translate-list --> 🏗️ In Progress
• scripts/spo-trim-and-m365-archive-sitecollection
• scripts/spo-uninstall-spfx-hubsiteassociatedsites-tenantappcatalog
• scripts/spo-update-branding-sitelogo-thumbnail --> 🏗️ In Progress
• scripts/spo-update-contentype-from-hub --> 🏗️ In Progress
• scripts/spo-update-document-library-templates
• scripts/spo-update-highlightcontentwebpart-seeall
• scripts/spo-update-largelist-pnpbatch-with-retry --> 🏗️ In Progress
• scripts/spo-update-list-icons-and-color
• scripts/spo-update-list-item-as-system --> 🏗️ In Progress
• scripts/spo-update-lookup-field --> 🏗️ In Progress
• scripts/spo-update-modern-webpart-properties
• scripts/spo-update-people-web-part
• scripts/spo-update-search-result-webparts --> 🏗️ In Progress
• scripts/spo-webhook-subscription-maintenance

[Adam-it]

Now, we only need to assign Copilot to that and work done right 😁
@pkbullock I added this issue to track my work (most probably not achievable), but I will do my very best to cover some of the tasks from this list gradually in the coming months 👍
I should add a first batch of PRs in the coming days.

[juandresrodca]

I'd like to add the CLI for Microsoft 365 implementation for scripts/get-disabled-or-inactive-user-accounts (currently PnP PowerShell only). PR incoming.