Hopefully, you have seen my session at the Scottish summit for “Azure Automation to the rescue, PnP PowerShell your way to the fun stuff”, whist quite a lengthy title, talks about how you can leverage Azure cloud services to offload tasks especially those that are repetitive or commonly requested – that can run on a schedule or ad-hoc.
I have mentioned a few resources and scripts within the session, that you can refer to below, if you would like to setup similar services.
Source Script for Reporting on Teams Private Channels
Adding and installing the Modules for local installation
This sample shows importing the Excel module into Azure Automation. Note: this is dependent on the Az PowerShell module (v5.5.0) to be installed on your machine.
The Azure Runbook for finding Teams Private Channels in a tenant and generating an Excel report
This is the script for the Teams Private Channels report runbook used in the session. This works if the services are setup with the sample from the PnP repository.
Links to mentioned or related resources
The following resources were mentioned in my session, I recommend these fir further reading:
- Azure Automation
- Azure Automation Blog – 2020 Recap and What’s New
- Azure Automation GitHub Repository for Sample Scripts, Packs and Tools
- Microsoft Identity Platform
- PnP Community Site
- PnP Sharing is Caring
- PnP PowerShell – Documentation Site
- PnP PowerShell – Connect to SharePoint Online using Application permissions with Azure Automation
Thank you for reading more about my session, I hope you enjoyed it, if you have any feedback, please post below.