Cannot remove SharePoint subsite using Remove-SPWeb

Recently I ran into a problem with a subsite that errored out on creation, but still was partially created. I needed to go into PowerShel...

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...

Color Code SharePoint List Rows or Cells using Javascript

You can color code your list rows of a SharePoint list by using this code. Insert a script editor webpart, paste in this code, and change ...

Powershell to restart a service

Recently I had a service on a server that keeps stopping, and I needed to check to make sure it's started, and if not then I need to r...

Exchange powershell script to find all users mailbox sizes

This Powershell script will give you the size of all user's mailboxes. Save this to a .ps1 and run it Get-MailboxStatistics -Serve...

Add https to your SCSM portal after initial install

Here was my problem: I installed SCSM 2019 and installed the web portal on the same SCSM app server. During the install I chose to use htt...