Skip to content

Instantly share code, notes, and snippets.

View raandree's full-sized avatar
🏠
Working from home

Raimund Andrée raandree

🏠
Working from home
276 followers · 13 following
View GitHub Profile
@raandree
raandree / Get-SqlConnections.sql
Created March 4, 2020 10:56
Gets all connection from a SQL server including authentication type
SELECT
s.session_id,
c.connect_time,
s.login_time,
s.login_name,
c.protocol_type,
c.auth_scheme,
s.HOST_NAME,
s.program_name
FROM sys.dm_exec_sessions s
@raandree
raandree / Attach-Debugger.ps1
Last active September 10, 2024 16:49
Debug DSC code running in a different process
[DSCLocalConfigurationManager()]
configuration LcmDebugConfig
{
Node localhost
{
Settings
{
RefreshMode = 'Push'
DebugMode = 'ForceModuleImport'
}
@raandree
raandree / azure-pipelines.yml
Created February 14, 2020 14:14
Parallel job execution in Azure DevOps
trigger:
- '*'
stages:
- stage: develop
jobs:
- job: A
strategy:
parallel: 4
pool:
@raandree
raandree / Get-Enum.ps1
Created November 19, 2019 14:36
Get-Enum
function Get-Enum
{
param (
[type]$Type
)
[enum]::GetValues($Type) |
Select-Object -Property `
@{ Name = 'Name'; Expression={ [string]$_ } },
@{ Name = 'Value'; Expression={ [int]$_ }},
@raandree
raandree / New-RestrictedPSSessionConfigurationLocalAccounts.ps1
Last active December 3, 2020 16:56
JEA: Register a new restricted endpoint with one JEA role. The endpoint runs with a virtual account. The assigned groups and users are local ones. No domain membership is required.
function Get-Test
{
Get-Date
}
function New-TestRole
{
New-PSRoleCapabilityFile -Path c:\TestRole.psrc `
@raandree
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
@raandree
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
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
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
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