JaekelEDV

#Install-Module -Name PSSQLite 
$database = $env:LOCALAPPDATA + "\Packages\Microsoft.MicrosoftStickyNotes_8wekyb3d8bbwe\LocalState\plum.sqlite"
$query = "SELECT * FROM Note LIMIT 100"
Invoke-SqliteQuery -DataSource $database -Query $query  >  $env:USERPROFILE\Desktop\notes.txt

JaekelEDV

Symmetric and asymmetric encryption and signing

JaekelEDV

// This file was initially generated by Windows Terminal 1.2.2381.0
// It should still be usable in newer versions, but newer versions might have additional
// settings, help text, or changes that you will not see unless you clear this file
// and let us generate a new one for you.

// To view the default settings, hold "alt" while clicking on the "Settings" button.
// For documentation on these settings, see: https://aka.ms/terminal-documentation
{
    "$schema": "https://aka.ms/terminal-profiles-schema",

JaekelEDV

Diffie-Hellman-Key-Exchange

• two parties (Alice and Bob)
• don’t know each other
• communicate over insecure channel
• need both the same key to use symmetric cryptography, e.g. AES

Alice starts. She generates a key, puts it in a box, and locks it – with a padlock that only she has the key to open.

JaekelEDV

<?xml version="1.0" encoding="utf-8"?>
<unattend xmlns="urn:schemas-microsoft-com:unattend">
    <settings pass="oobeSystem">
        <component name="Microsoft-Windows-International-Core" processorArchitecture="amd64" publicKeyToken="31bf3856ad364e35" language="neutral" versionScope="nonSxS" xmlns:wcm="http://schemas.microsoft.com/WMIConfig/2002/State" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance">
            <InputLocale>de-DE</InputLocale>
            <SystemLocale>de-DE</SystemLocale>
            <UILanguage>de-DE</UILanguage>
            <UILanguageFallback>de-DE</UILanguageFallback>
            <UserLocale>de-DE</UserLocale>
        </component>

JaekelEDV

#https://superuser.com/questions/758372/query-site-for-given-ip-from-ad-sites-and-services
#Found this one - and it's working. But... I don't know why it does. Let's see...

#This is the function:
Function Get-AdSiteAndSubnetFromIP {
<#
.Synopsis
Get the matching AD Site and Subnet for a given IP Address
.DESCRIPTION
Get the matching AD Site and Subnet for a given IP Address.  The results will be returned as a Hash.

JaekelEDV

function Get-RFC {
    [CmdletBinding()]
    param (
        [Parameter(Mandatory = $True)]
        [string] $RFC
    )
    
    $url = "https://www.ietf.org/rfc/rfc$RFC.txt"
    $output = "c:\temp\rfc$RFC.txt"
    (New-Object System.Net.WebClient).DownloadFile($url, $output)

JaekelEDV

Set-ExecutionPolicy Bypass -Scope Process -Force
Invoke-Expression ((New-Object System.Net.WebClient).DownloadString('https://chocolatey.org/install.ps1'))

JaekelEDV

$Props = 'Name', @{Name = 'Size in GB'; Expression = {$_.Length / 1GB -as [int]}}, @{Name = 'Size in MB'; Expression = {$_.Length / 1MB -as [int]}}, 'Directory'
Get-ChildItem -Recurse | Sort -Descending -Property Length | select -First 5 $Props | Format-List

JaekelEDV

filter Get-InstalledSoftware {
    <#
    .SYNOPSIS
        Get all installed from the Uninstall keys in the registry.
    .DESCRIPTION
        Read a list of installed software from each Uninstall key.

        This function provides an alternative to using Win32_Product.
    .EXAMPLE
        Get-InstalledSoftware