3 PowerShell Snippets

This section will contain various, helpful PowerShell snippets used by Professional Services.

3.1 Privilege-related

3.1.1 Test if prompt is administrative

([Security.Principal.WindowsPrincipal] [Security.Principal.WindowsIdentity]::GetCurrent()).IsInRole( [Security.Principal.WindowsBuiltInRole] "Administrator")

Returns a [System.Boolean] True if prompt is an admin. False if it is not.

3.2 .NET Framework-related

3.2.1 Display current .NET Framework version

(Get-ItemProperty "HKLM:\SOFTWARE\Microsoft\NET Framework Setup\NDP\v4\Full").Version

Returns the currently installed .NET Framework version as a [System.String]. For example 4.8.04084.

3.3 Active Directory-related

3.3.1 Show current forest

([System.DirectoryServices.ActiveDirectory.Forest]::GetCurrentForest()).Name

Returns the currently joined forest as a [System.String]. For example domain.com.

3.3.2 Set SPN for a user

Sets an SPN for a designated user:

Get-ADUser svc-username | Set-ADUser -ServicePrincipalNames @{Add='MSSQLSvc/MSSQLSERVER01.domain.com:1433'}