Add SLA's to PowerON SCSM Power BI template

The PowerON SCSM Power BI Dashboard template is a great tool to use for analyzing data inside of System Center Service Manager. But it la...

Script to stop SQL Server

The reason that you might want to stop SQL server is when databases live on servers other than the local SQL server, they might get corrup...

Powershell to export permissions from SharePoint site to CSV (on-prem)

This is A powershell command to export all permissions from a SHarePoint site and subsites to CSV using PowerShell. Make sure to replace t...

How to create a collection of computers by installed software

These are directions on how to create an SCCM device collection based upon what software the device has installed on it. Use this query...

Power BI - Column for data from previous date

In Power BI, I needed to add a column for data from a previous date, not Today()-1. Since this was pulling data from a directory that migh...

Nice Power BI Date table DAX expression

Many times you want to build your own date table in Power BI to show a date range. This is the DAX expression that I used to build that, ...

Make a Copy of a SharePoint Site (for testing)

The other day I wanted to test out something in SharePoint 2016, but I didn't have a test environment.But I also didn't want to te...