In the Microsoft Teams admin center you have various usage reports under "Analytics & reports->Usage reports". One of them is the "Teams user activity" report, that shows you how many meetings, chat messages, video minutes and so on that each user have and in total for your tenant. I have created a small script that … Continue reading Which department is most active on Microsoft Teams?
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!
Get detailed data from your Teams meetings.
Today I will teach you how to setup a Graph API subscription to get a Microsoft Teams meeting id, which you again can use to get detailed diagnostics data from your meetings. First we need to create a subscription to the Call Records endpoint in the Graph API change notifications system (more info here). To … Continue reading Get detailed data from your Teams meetings.
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!
Authenticate against Exchange Online in Azure Automation securely and easy with a certificate
When using Azure Automation one of the big questions have always been, what do we do about Runbooks that needs access to Exchange Online PowerShell? If you were reckless security wise you could always have an admin account with basic auth and no MFA. The second best thing, but a hassle, is to setup a … Continue reading Authenticate against Exchange Online in Azure Automation securely and easy with a certificate
Fewer emails after deploying Microsoft Teams?
Many organizations send files and have long conversations on email internally. What will happen to the number of emails sent internally after the deployment of Microsoft Teams? I have created a verry simple script/method to automatically gather/messaure this by. You should set it up as soon as you are in the pre-planning of a Teams … Continue reading Fewer emails after deploying Microsoft Teams?
Wouldn’t it be cool to get that report through PowerShell/Graph API?
In the Microsoft Teams admin portal you have several interesting reports. You can run the reports and download as a csv. Then after import downloading, you could import the csv into PowerShell to play with the data. Wouldnt it be better to get these data directly into PowerShell? What if you want only a portion … Continue reading Wouldn’t it be cool to get that report through PowerShell/Graph API?
Consolidate Teams and SharePoint activity reports!
Want an easy way to see Teams and SharePoint usage data in the same report? Then you have come to the right place. This reports on all your teams with SharePoint data, but not SharePoint sites without a team. This will be a halfway automatic process, as you need to manually download two reports from … Continue reading Consolidate Teams and SharePoint activity reports!
Disable and revoke Azure AD tokens from expired AD users
If you have an environment on-premises and are starting to take advantage of the cloud, then there's a lot to be aware of. One big thing to take notice of is that Azure AD does not respect user expired state in AD. When logging on to Office 365 services outside of ADFS with CloudNative Auth, … Continue reading Disable and revoke Azure AD tokens from expired AD users
Teams Auto Attendant Holiday Schedule Generator
Simple and short blogpost this time to help get ready for the holidays. The script reads the holidays for a specified country from officeholidays.com and adds them to a specified Auto Attendant in Teams. Link to script.