r4lfvb

(Get-AzLocation -OutVariable locations) |
Where-Object { $_.GeographyGroup -and $_.RegionType -eq 'Physical' } |
Select-Object -Property @{Name='Geography';Expression={$_.GeographyGroup}},
    @{Name='Region';Expression={$_.Location}},
    PhysicalLocation,
    @{Name='PairedRegion';Expression={$_.PairedRegion.Name}},
    @{Name='PairedRegionPhysicalLocation';Expression={
        ($locations | Where-Object location -eq $_.PairedRegion.Name).PhysicalLocation
    }} |
Sort-Object Geography, Region |

r4lfvb

Ensure the ImportExcel module is installed

Install-Module -Name ImportExcel -Scope CurrentUser -Force

Save Azure Region and AZ details to Excel

  if ($_.RegionType -eq 'Physical') {
    $regionName = $_.RegionName
    $id = $_.ID

r4lfvb

Create QR code in Excel

Add this to Cell A1

https://chart.googleapis.com/chart?chs=300x300&cht=qr&chl=

Then add this to Cell A2

https://www.bing.com

r4lfvb

Create a battery report in Windows

In Windows terminal: powercfg /batteryreport /output "battery_report.html"

r4lfvb

PowerShell tricks

Create a new GUID

[guid]::newguid()

Reload the PATH in the current session

$env:Path = [System.Environment]::GetEnvironmentVariable("Path","Machine") + ";" + [System.Environment]::GetEnvironmentVariable("Path","User")