script

How to install the latest SPO PowerShell Module

Mike Lee - October 27, 2022 - 0 Comments

Summary It’s a good practice to ensure the latest version of the SharePoint Online Module is installed, because it’s constantly being updated with new and improved features. I’m just sharing a quick PowerShell script that ensures the latest SharePoint online PowerShell module is installed. There 2 different ways to install this module. Download and install […]

Unable to create new root site after enabling the “SPTrustedBackedByUPAClaimProvider”

Mike Lee - March 2, 2022 - 0 Comments

After enabling the new SharePoint Server Subscription Edition feature to find users from the UPA directly with the SPTrustedBackedByUPAClaimProvider,, you may be unable to create a root site in a new Web Application.

Collect SharePoint Verbose ULS logs for reproducible issues

Mike Lee - February 23, 2022 - 1 Comment

If you need to collect VerboseEX logs from a SharePoint Farm, this script makes it simple for reproducible issues. Simply execute the script, reproduce the issue and hit enter …. Done

SharePoint Population Script V2

Mike Lee - October 13, 2021 - 0 Comments

Summary This is my 2nd version of SharePoint Population Script with a few minor changes. Removed the Hosts file and host header creation to simplify the process. The new script will only create a single DB. A new Web Application using the server host name over a different port is now allowed. A Modern Team […]

Install BGINFO on Multiple Servers

Mike Lee - October 7, 2021 - 0 Comments

Summary This blog details how to install and configure BGINFO to start on multiple servers. What is BGINFO? BGINFO stands for “Background Information”. This program will allow users to display computer details on the desktop wallpaper. This is very handy when working with multiple virtual servers that all have the same default background. Example: Get […]

SharePoint / Script to locate documents encrypted with passwords

Mike Lee - July 9, 2020 - 0 Comments

Summary A customer asked if there was a method to identity documents stored in SharePoint online that were encrypted with passwords. Since nothing like this existed, it was created using PowerShell. I’m sharing this because the logic in the script may be useful for others. The Code Takeaways This scripts loops though a specified document […]

Script to check if a reg key is set on multiple servers

Mike Lee - June 18, 2019 - 0 Comments

Summary If your servers require a reg key and unsure if its properly configured. You can use this script to check if the key is present or is set to the correct value across multiple servers. The Script

PowerShell

#Simple Server list $servers = Get-Content C:\servers.txt # Loop through all servers and check key foreach ($server in $servers) { $REG = [Microsoft.Win32.RegistryKey]::OpenRemoteBaseKey('LocalMachine', $server) $REGKEY = $REG.OpenSubKey("SYSTEM\CurrentControlSet\Control\Lsa") $val = $REGKEY.GetValue("DisableLoopBackCheck") # If the key is missing or not set it will be displayed in red # If the key is set it will be displayed in green if (!$val){ Write-Host $server "is not set" -ForegroundColor Red } if ($val -ne "1"){ Write-Host $server "is not set properly" -ForegroundColor Red } else{ Write-Host $server "is set" -ForegroundColor Green } }

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26

#Simple Server list $servers = Get-Content C:\servers.txt   # Loop through all servers and check key foreach ($server in $servers) {   $REG = [Microsoft.Win32.RegistryKey]::OpenRemoteBaseKey('LocalMachine', $server) $REGKEY = $REG.OpenSubKey("SYSTEM\CurrentControlSet\Control\Lsa") $val = $REGKEY.GetValue("DisableLoopBackCheck")   # If the key is missing or not set it will be displayed in red # If the key is set it will be displayed in green   if (!$val){   Write-Host $server "is not set"  -ForegroundColor Red }   if ($val -ne "1"){ Write-Host $server "is not set properly"  -ForegroundColor Red }   else{ Write-Host $server "is set" -ForegroundColor Green } }

What the Script Does In the sample above it will check the “DisableLoopBackCheck” key across a […]

Script to copy specified IIS logs from multiple Servers

Mike Lee - June 14, 2019 - 0 Comments

Summary Need to copy a set of IIS logs from multiple servers for data analysis? Are you doing it manually?  If so, please check out this script as it will help expedite the process. The Script:

PowerShell

#Modify Inputs # Host and Drive to store the IISLogs $Hostdir = "\\HOSTSERVER\c$" # Actual Location of the IIS Logs on the Server $iislogsfolder = "c$\inetpub\logs\LogFiles\W3SVC1892304237" #A wild card parameter to determine a file range $thefiles = "*ex1906*" # Create a target folder on host if does not exist $TARGETROOT = "$Hostdir\logs" if(!(Test-Path -Path $TARGETROOT)){ New-Item -ItemType directory -Path $TARGETROOT } # Create an export folder if it does not exist $target = "$Hostdir\logs\export" if(!(Test-Path -Path $target)){ New-Item -ItemType directory -Path $target } #Simple Server list $servers = Get-Content C:\servers.txt # For loop to do the work foreach ($server in $servers) { #make a new folder by server name if it does not exist $TARGETDIR = "$target\$Server" if(!(Test-Path -Path $TARGETDIR)){ New-Item -ItemType directory -Path $TARGETDIR } #Get the files $iislogLogDir = "\\$server\$iislogsfolder" $iislogName = Get-ChildItem "$iislogLogDir" -Recurse -Include "$thefiles" | Get-Item #Start a loop to copy all the files to the host locatiion foreach ($log in $iislogName) { copy-Item -path $log $TARGETDIR } }

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48

#Modify Inputs   # Host and Drive to store the IISLogs $Hostdir = "\\HOSTSERVER\c$"   # Actual Location of the IIS Logs on the Server $iislogsfolder = "c$\inetpub\logs\LogFiles\W3SVC1892304237"   #A wild card parameter to determine a file range $thefiles = "*ex1906*"     # Create a target folder on host if does not exist $TARGETROOT = "$Hostdir\logs" if(!(Test-Path -Path  $TARGETROOT)){ New-Item -ItemType directory -Path  $TARGETROOT }     # Create an export folder if it does not exist $target = "$Hostdir\logs\export" if(!(Test-Path -Path  $target)){ New-Item -ItemType directory -Path $target }     #Simple Server list $servers = Get-Content C:\servers.txt   # For loop to do the work foreach ($server in $servers) {   #make a new folder by server name if it does not exist $TARGETDIR = "$target\$Server" if(!(Test-Path -Path  $TARGETDIR)){ New-Item -ItemType directory -Path $TARGETDIR }   #Get the files $iislogLogDir = "\\$server\$iislogsfolder" $iislogName = Get-ChildItem "$iislogLogDir" -Recurse -Include "$thefiles" | Get-Item   #Start a loop to copy all the files to the host locatiion foreach ($log in $iislogName) { copy-Item -path $log $TARGETDIR } }

What the Script Does You only need to modify the inputs and create a server list. Then the […]

Script to backup event logs using a server list

Mike Lee - June 6, 2019 - 0 Comments

Summary Have you ever needed to back up event logs for root cause analysis or auditing? Did you access each server and manually export the requested log file? If yes, I hope you find this script handy. The script

PowerShell

# Specify which Log File $EventLogName = “Application” # Specify drive to store event logs $drive= “c$” # Specify server to store event logs $dest = "SERVERNAME" #Simple Server list $servers = Get-Content C:\servers.txt # For loop to do the work foreach ($server in $servers) { # Create a target folder on host if does not exist $TARGETROOT = "\\$server\$drive\logs" if(!(Test-Path -Path $TARGETROOT)){ New-Item -ItemType directory -Path $TARGETROOT } # This is the WMI call to select the application log from each server $logFile = Get-WmiObject -EnableAllPrivileges -ComputerName $server Win32_NTEventlogFile | Where-Object {$_.logfilename -eq $EventLogName} # Creating a file name based on server, log and time $exportFileName = $server + “_” + $EventLogName + “_” +(get-date -f yyyyMMdd) + “.evt” # Perform the backup $logFile.backupeventlog($TARGETROOT + “\” + $exportFileName) # Create an export folder if it does not exist $target = "\\$dest\$drive\logs\export" if(!(Test-Path -Path $target)){ New-Item -ItemType directory -Path $target } # Since WMI does the work on the remote machine you can’t copy to file share. # This is a workaround to move to files to a single location after the backup Move-Item $TARGETROOT\$exportFileName $target }

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43

# Specify which Log File $EventLogName = “Application”   # Specify drive to store event logs $drive= “c$”   # Specify server to store event logs $dest = "SERVERNAME"   #Simple Server list $servers = Get-Content C:\servers.txt # For loop to do the work foreach ($server in $servers) {   # Create a target folder on host if does not exist $TARGETROOT = "\\$server\$drive\logs" if(!(Test-Path -Path  $TARGETROOT)){ New-Item -ItemType directory -Path  $TARGETROOT }    # This is the WMI call to select the application log from each server $logFile = Get-WmiObject -EnableAllPrivileges -ComputerName $server Win32_NTEventlogFile | Where-Object {$_.logfilename -eq $EventLogName}   # Creating a file name based on server, log and time $exportFileName = $server + “_” + $EventLogName + “_” +(get-date -f yyyyMMdd) + “.evt”   # Perform the backup $logFile.backupeventlog($TARGETROOT + “\” + $exportFileName)   # Create an export folder if it does not exist $target = "\\$dest\$drive\logs\export" if(!(Test-Path -Path  $target)){ New-Item -ItemType directory -Path $target }   # Since WMI does the work on the remote machine you can’t copy to file share.   # This is a workaround to move to files to a single location after the backup Move-Item $TARGETROOT\$exportFileName $target }

What does it the script do? This script will read a list of servers and […]

Fun with SharePoint Service Application Pools!

Mike Lee - January 4, 2018 - 0 Comments

Summary The blog referenced in the resource section below does a great job at demonstrating how to create a new SharePoint Web Application Pool and associate it with the Web App using PowerShell. However, as mentioned in the blog the process is a little different for Service Applications. The following information is just a quick […]