Tips.PowerShell.md

Userful PowerShell Resources

Documentation

• https://aka.ms/PSWindows

  • Check PowerShell versions installed:
    • $PSVersionTable.PSVersion
  • Install PowerShell on Windows
    • https://learn.microsoft.com/en-us/powershell/scripting/install/install-powershell-on-windows?view=powershell-7.5
      • List Available Versions:
        • winget search --id Microsoft.PowerShell
      • Install by version name:
        • winget install --id Microsoft.PowerShell --source winget
  • See Known Limitations:
    • https://learn.microsoft.com/en-us/powershell/scripting/install/install-powershell-on-windows?view=powershell-7.5#known-limitations

• https://docs.microsoft.com/en-us/powershell/

• https://devblogs.microsoft.com/powershell/

PowerShell Gallery

• https://www.powershellgallery.com/
  • "The central repository for sharing and acquiring PowerShell code including PowerShell modules, scripts, and DSC resources."
  • https://docs.microsoft.com/en-us/powershell/gallery/overview
  • https://docs.microsoft.com/en-us/powershell/gallery/getting-started

PowerShell Learning/Tutorial/Example Resources

• https://docs.microsoft.com/en-us/powershell/scripting/samples/sample-scripts-for-administration?view=powershell-5.1

• https://docs.microsoft.com/en-us/powershell/scripting/samples/sample-scripts-for-administration?view=powershell-6

• https://docs.microsoft.com/en-us/powershell/scripting/samples/sample-scripts-for-administration?view=powershell-7

• https://www.johndcook.com/blog/powershellcookbook/

• https://www.robvanderwoude.com/powershellexamples.php

• https://www.hongkiat.com/blog/windows-powershell-commands/

• https://www.varonis.com/blog/windows-powershell-tutorials/

• https://www.tutorialspoint.com/powershell/powershell_scripting.htm

• http://powershelltutorial.net/

• https://twitter.com/PowerShellMich1

  • https://github.com/ZanattaMichael
  • https://www.linkedin.com/in/michael-zanatta-61670258/
  • https://www.twitch.tv/powershellmichael/

Community Resources

• https://docs.microsoft.com/en-us/answers/search.html?type=question%20OR%20idea%20OR%20kbentry%20OR%20answer%20OR%20topic%20OR%20user&redirect=search%2Fsearch&sort=relevance&q=%23powershell

• https://docs.microsoft.com/en-us/answers/topics/windows-server-powershell.html

• https://stackoverflow.com/questions/tagged/powershell

Suggest Books

• Windows Server 2019 & PowerShell All-in-One For Dummies, 1st Edition

• Windows PowerShell in Action 3rd Edition

• Windows PowerShell 6 (IT Pro Solutions)

• Learn Windows PowerShell in a Month of Lunches, 3rd Edition

• Learn PowerShell Scripting in a Month of Lunches

• Learn PowerShell Toolmaking in a Month of Lunches, 1st Edition

• PowerShell in Depth, 2nd Edition

• Windows PowerShell Cookbook: The Complete Guide to Scripting Microsoft's Command Shell, Third Edition

• Windows PowerShell Pocket Reference: Portable Help for PowerShell Scripters, Second Edition

• Windows PowerShell in 24 Hours, Sams Teach Yourself, 1st Edtion

• Learn PowerShell Core 6.0: Automate and control administrative tasks using DevOps principle

• Pro PowerShell for Amazon Web Services: DevOps for the AWS Cloud

• The PowerShell Conference Book (2018)

• 2020 Books to look for...

  • PowerShell for Sysadmins: A Hands-on Guide to Automating Your Workflow

Useful Commands:

• What Version am I running?

  • $PSVersionTable.PSVersion

• Add a firewall rule

  • netsh advfirewall firewall add rule name="docker engine" dir=in action=allow protocol=TCP localport=2375

• Generate a GID

  • [guid]::newguid()

• Get Hash

  • https://learn.microsoft.com/en-us/powershell/module/microsoft.powershell.utility/get-filehash?view=powershell-7.3
  • Get-FileHash
  • Algorithms supported: SHA1, SHA256, SHA384, SHA512, MD5

• Get Serial Numbers:

  • wmic memorychip get serialnumber
  • wmic diskdrive get serialnumber
  • wmic baseboard get serialnumber
  • wmic cdrom where drive='d:' get SerialNumber

• Disable WiFi

  • netsh interface set interface name="Wireless Network Connection" admin=DISABLED

• Hybernation

  • powercfg /hibernate on
  • powercfg /hibernate off

• Explore a command...

  • <command> | Get-Member
  • Will return:
    • Properties
    • Methods
    • AliasProperty
    • Event
    • ScriptMethod
    • ...
  • Examples:
    • get-localuser | Get-Member
  • Also see:
    • Get-Command
    • Get-Help
    • Get-Member

PowerShell for the SQL DBA

• https://groupby.org/conference-session-abstracts/powershell-for-the-sql-dba/
  • Enable-PSRemoting
  • Set ExecutionPolicy RemoteSignted -force
  • (...many other examples in the video...)

Running PowerShell Scripts:

• PowerShell script files end in ".ps1"

• To pass parameters into a sccript:

  • Define parameters on first line, such as:
  • Param([string]$clsid)

• To execute a file, use the command line form of .\{sciprt.ps1}

• Get BIOS info

  • Get-WmiObject win32_bios
  • Get-WmiObject -Class Win32_BIOS | Format-List *
  • https://sumtips.com/snippets/powershell/get-bios-information-with-powershell-cmd/

• "Start Using Constrained Language Mode"

  • https://devblogs.microsoft.com/powershell/powershell-constrained-language-mode/

Running PowerShell Scripts from command-line, or windows batch files

• https://blog.danskingdom.com/allow-others-to-run-your-powershell-scripts-from-a-batch-file-they-will-love-you-for-it/
• https://stackoverflow.com/questions/19335004/how-to-run-a-powershell-script-from-a-batch-file
  • Powershell.exe -executionpolicy remotesigned -File ps.ps1
  • PowerShell -NoProfile -ExecutionPolicy Bypass -Command "& {Start-Process PowerShell -ArgumentList '-NoProfile -ExecutionPolicy Bypass -File ""C:\Users\SE\Desktop\ps.ps1""' -Verb RunAs}"
    • If you need to run as Admin
  • powershell.exe -ExecutionPolicy Bypass -Command "Path\xxx.ps1"
    • If you launch PowerShell as administrator...