Raimund Andrée [MSFT] raandree

🏠

Working from home

Microsoft Premire Field Engineer focusing mainly on PowerShell, DevOps and DSC.

raandree / DSC Pull Scenario 1 with SQL Server.ps1

Created May 11, 2017 08:00

Creates a DSC Pull server lab. The pull server uses a database in a SQL Server 2016.

throw "NotImplementedYet"

raandree / Show-Tree.ps1

Created December 14, 2017 13:15

Show-Tree.ps1

	using namespace System.Collections.Generic
	function Show-Tree
	{
	# .SYNOPSIS

	# Print a tree given a key property and parent property
	#
	# .PARAMETER InputObject
	#
	# The object to print.

raandree / DscAppPoolRecyclingIssue.ps1

Created January 9, 2018 00:15

DSC Pull Server data loss reproduction

	$pullServer = Get-LabVM -Role DSCPullServer
	$sqlServer = Get-LabVM -Role SQLServer2016

	$before = Invoke-LabCommand -ActivityName 'Get Row Count' -ComputerName $sqlServer -ScriptBlock {
	Invoke-Sqlcmd -Database DSC -Query "SELECT COUNT(*) AS Count FROM StatusReport"
	} -PassThru

	Invoke-LabCommand -ActivityName 'Backup DSC Database' -ComputerName $sqlServer -ScriptBlock {
	mkdir C:\SQLBackups -Force
	$backupCmd = "BACKUP DATABASE [DSC] TO DISK = N'C:\SQLBackups\DSC {0:yyMMdd-hhmmss}.bak' WITH NOFORMAT, NOINIT, NAME = N'DSC-Full Database Backup', SKIP, NOREWIND, NOUNLOAD, STATS = 10" -f (Get-Date)

raandree / EventLogLegacy.ps1

Created June 25, 2018 23:07

EventLogLegacy.ps1

	<#
	.SYNOPSIS
	Gets event log entries from remote computers using RPC/DCOM (same as connecting to remote computer from event log viewer MMC)

	.DESCRIPTION
	Gets event log entries from remote computers using RPC/DCOM (same as connecting to remote computer from event log viewer MMC)

	.NOTES
	--------------------------------------------------------------------------------
	Script author: Per Pedersen - [email protected]

raandree / Get-KerberosKeytab.ps1

Last active December 27, 2023 02:33

Parses Kerberos Keytab files

	param(
	[Parameter(Mandatory)]
	[string]$Path
	)

	#Created by [email protected]
	#
	#Got keytab structure from http://www.ioplex.com/utilities/keytab.txt
	#
	# keytab {

raandree / New-JeaDemoInDomain.ps1

Last active November 7, 2024 10:06

JEA: Register a new restricted endpoint with JEA roles

	function Unlock-AAAccount
	{
	param(
	[Parameter(Mandatory)]
	[string]$Identity
	)

	try
	{
	$user = Get-ADUser -Identity $Identity

raandree / Connect-JeaSession.ps1

Last active October 18, 2019 19:25

JEA: Connect to a administrative endpoint created by 'New-RestrictedPSSessionConfiguration.ps1'

	function Connect-SupportSession
	{
	param(
	[Parameter(Mandatory)]
	[string]$ComputerName,

	[pscredential]$Credential
	)

	$s = New-PSSession @PSBoundParameters -ConfigurationName Support #-ErrorAction SilentlyContinue

raandree / Get-KerberosEncTypes.ps1

Created May 28, 2019 23:24

Extend Kerberos security events with cipher suite, ticket options and other fields to make data human readable that is stored as hex values

	$types = @'
	using System;

	namespace Kerberos
	{
	public enum EncryptionTypes:uint
	{
	AES256_CTS_HMAC_SHA1_96 = 18,
	AES128_CTS_HMAC_SHA1_96 = 17,
	ARCFOUR_HMAC_MD5 = 23,

raandree / GenericMeasureInfo.format.ps1xml

Created July 29, 2019 10:01

PowerShell Formatter for Measure-Object to show sizes also in MB, GB or TB

	<?xml version="1.0" encoding="utf-8" ?>
	<Configuration>
	<ViewDefinitions>
	<View>
	<Name>Microsoft.PowerShell.Commands.GenericMeasureInfo</Name>
	<ViewSelectedBy>
	<TypeName>Microsoft.PowerShell.Commands.GenericMeasureInfo</TypeName>
	</ViewSelectedBy>
	<ListControl>
	<ListEntries>

raandree / Attach-DscRunspace.ps1

Created July 29, 2019 10:07

This script attaches to the DSC LCM's PSHostProcess for debugging the runspace that is in state 'AtBreakpoint'

	#usually the process consuming the most memory is the one that hosts the LCM
	$p = Get-Process -Name WmiPrvSE \| Sort-Object -Property WS -Descending \| Select-Object -First 1

	Enter-PSHostProcess -Process $p -AppDomainName DscPsPluginWkr_AppDomain
	Start-Sleep -Seconds 1
	$rs = Get-Runspace \| Where-Object { $_.Debugger.InBreakpoint }
	Debug-Runspace -Runspace $rs