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.
Integrating PowerShell with PowerBI: Automating in Azure (Part 3)
In this blogpost we will take a look at how to automate the process of updating the data in the Power BI report we created in part 2, without any need of a computer/server. We will manage to do this by scheduling a Runbook in Azure Automation. I asume that you allready have signed up … Continue reading Integrating PowerShell with PowerBI: Automating in Azure (Part 3)
Integrating PowerShell with PowerBI: Module, script and reporting (Part 2)
So now if you read part one, you are set to go starting using this newly created integration. (If not read part one here.) What we will take a look at in this post: - What you can do with the module. - Writing a reporting script that send data to Power BI. - Create … Continue reading Integrating PowerShell with PowerBI: Module, script and reporting (Part 2)
Integrating PowerShell with PowerBI (Part 1)
Power BI is a extremely powerful data and visualization tool. It have opened a new world for me. But the first thing i always think about when taking a look at Microsoft products, there have to be a way to control this with PowerShell. I did not find any good information about any PowerShell module … Continue reading Integrating PowerShell with PowerBI (Part 1)
Call que timeout, less than a minute?
I see on Tech Community there have been some requests regarding the call que timeout in Skype Online. The minimum time you can set is 60 seconds, before the call is passed on to somewhere else. I have seen some requests that people need/want to set the timeout to less than 60 seconds. In the … Continue reading Call que timeout, less than a minute?
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
Skype Teams? One product to rule them all?
Late last night I came over a tweet from John Cook that showed us some mysterious new services you will find when running Get-MsolServicePrincipal in PowerShell on your tenant. There were many services starting with the name Skype Teams. When I checked on my own tenant, a service named Skype Teams Services was missing from the output. … Continue reading Skype Teams? One product to rule them all?
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
A blog about automation and technologies in the cloud 