bielawb

<#
    List taken from SO answer:
    http://stackoverflow.com/questions/4730152/what-indicates-an-office-open-xml-cell-contains-a-date-time-value
#>

$ExCellStyles = @{
    0 = 'General'
    1 = '0'
    2 = '0.00'
    3 = '#,##0'

mattifestation

function ConvertFrom-SID {
    param (
        [Parameter(Position = 0, Mandatory = $True)]
        [String]
        [ValidateNotNullOrEmpty()]
        $SID
    )

    $AccountSIDInstance = Get-CimInstance -ClassName Win32_AccountSID -Filter "Setting = 'Win32_SID.SID=`"$SID`"'"

IISResetMe

#Requires -Modules ActiveDirectory

function Get-ADUserPasswordExpiration
{
    param(
        [Parameter(Mandatory=$true,ValueFromPipeline=$true,ValueFromPipelineByPropertyName=$true)]
        [Alias('DistinguishedName')]
        [Microsoft.ActiveDirectory.Management.ADUser[]]$Identity
    )

IISResetMe

$Properties = 'employeeID'

# Retrieve all workers with their "manager" attribute
Get-ADUser -Filter "title -like '*worker*'" -Properties @('manager';$Properties) |ForEach-Object {
  # Iterate over workers, retrieve each workers manager individually
  [pscustomobject]@{
    Worker = $_
    Manager = Get-ADUser -Identity $_.manager -Properties $Properties -ErrorAction SilentlyContinue
  }
}

duffney

$source = "C:\LabResources\xTimeZone"

$destination = "C:\temp"

$Version = (Get-ChildItem -Path $source -Depth 1).Name
$ResoureName = (Get-ChildItem -Path $source -Depth 1).Parent.Name
$ModuleName = $ResoureName+'_'+$Version

New-Item -Path ($destination+'\'+$ModuleName) -ItemType Directory

mgreenegit

function Get-WSManTrust {
    (Get-Item -Path WSMan:\localhost\Client\TrustedHosts | % Value).split(',')
}

function New-WSManTrust {
param(
[string]$hostname
)
    Set-Item -Path WSMan:\localhost\Client\TrustedHosts -Value $hostname -Concatenate -Force
}

JustinGrote

function Get-AzSpotPrice {
    [CmdletBinding()]
    param (
        #VM SKU (e.g. Standard_F8s)
        [String]$Sku,
        #Azure Region (e.g. brazilsouth)
        [String]$Region,
        #ODATA filter to use on the data
        [String]$Filter,
        #Maximum number of records to retrieve, or specify 'Unlimited' for all records. Defaults to 100. This behaves like the Exchange Cmdlets

markekraus

function ConvertTo-Base64KMSEncryptedString {
    [CmdletBinding()]
    param (
        [Parameter(
            Mandatory = $true,
            ValueFromPipeline = $true
        )]
        [String[]]
        $String,

ChendrayanV

Import-Module Polaris -Verbose
Import-Module PSHTML -Verbose
Add-Type -AssemblyName System.Web

New-PolarisGetRoute -Path "/Login" -Scriptblock {
    $HTML = html {
        head {
            Title "Login Page"
        }

vfarcic

#################################################
# Terraform vs. Pulumi vs. Crossplane           #
# Infrastructure as Code (IaC) Tools Comparison #
# https://youtu.be/RaoKcJGchKM                  #
#################################################

#########
# Setup #
#########