I have created a script that does a count of each file type in all teams in Microsoft Teams.It also shows when that file type was last modified in the team. You need an Azure App registration with the Group.Read.All and Site.Read.All rights.
Script
Teams Devices Configuration Profiles Uploader
There's a lot of long manual processes in the Teams Admin Center, like entering configuration profiles for devices like Phones, Panels, Displays, and Teams Rooms on Android. If you work as a consultant, you probably have to redo all this work on each tenant you work on. People maybe add 50-100 profiles for each tenant. … Continue reading Teams Devices Configuration Profiles Uploader
Teams Network Planner Automated!
When you are uploading building data to Teams CQD you are provided with a neath CSV file to ease the input of data(CQD Buildingdata). When done, you just upload the CSV to the CQD portal. Now what about the Teams Network Planner? It uses the same data you have in the CQD CSV, but with … Continue reading Teams Network Planner Automated!
Export a users Exchange Online contact list/folder with Graph API!
Short blog post today with a script that exports the root contact list or a specific folder of a users Exchange Online mailbox. You need an Azure application with the app right Contact.Read. If you don't know how to use Graph API in PowerShell and create an Azure app, take a look here at my … Continue reading Export a users Exchange Online contact list/folder with Graph API!
Automatic update Holidays in AutoAttendant.
First of all, this can be you if you automate holiday updates in AutoAttendant with my script: A couple of days ago Microsoft realeased new features in preview for AutoAttendant. AutoAttendant in Skype for Business Online finaly have the ability to create holiday schedules! After fixing a bug that outputted wronge date values, i made … Continue reading Automatic update Holidays in AutoAttendant.
Password age for users in Office 365
Short script that gets all the users in your Office 365 tenant, and finds the password age. Creates a list with UPN and password age, then sort by oldest password. Also finds the average password age for your tenant.
SharePoint LastItemUserModifiedDate
Wrote a short script that list all SharePoint sites in your Office 365 tennant with the LastItemUserModifiedDate. Could be handy to see if some sites are not used anymore. First i used Get-SPOSite and LastContentModified, but after some research it turned out that it was not so reliable: https://social.msdn.microsoft.com/Forums/office/en-US/6e264b4e-e4b4-4b46-a7b0-9686c0f6128e/lastcontentmodifieddate-is-not-giving-me-the-right-values-for-site-collections-sharepoint-online?forum=sharepointdevelopment My script is a modified version … Continue reading SharePoint LastItemUserModifiedDate
Office 365 Groups reporting
Script for listing all groups with owners and members in Office 365. Added count of groups left to process to see progress when running scripts in large environments. Run either: Get-UnifiedGroup | Get-Member or Get-UnifiedGroupLinks | Get-Member to see what other properties you get add to the report. The script creates one CSV file for … Continue reading Office 365 Groups reporting
Custom notifications in Microsoft Teams
I started googling around to see if Teams had any PowerShell commandlets. Does not look like it, but its a work in progress. There is still a way to interact with Teams trough PowerShell. There is a connector in Teams called Incoming Webhook. This connector can post notifications from any scripting language trough JSON formatted … Continue reading Custom notifications in Microsoft Teams
Skype for Business – Automatic RGS Holidayset
The inspiration for this script came from Chris Hayward´s blogpost/script for creating holiday sets from a JSON source: http://chrishayward.co.uk/2017/07/07/skype-for-business-automatically-set-rgs-holiday-sets-with-powershell-and-json/ As he mentions in the blogpost, the only source for JSON dates for most countries is sites that cost $$$. I ended up with the same conclusion. I thought that there should be a way to … Continue reading Skype for Business – Automatic RGS Holidayset