/PowerShell

Various PowerShell functions and scripts

Primary LanguagePowerShellMIT LicenseMIT

PowerShell

Various PowerShell functions and scripts. These are published as WFTools on the PowerShell Gallery (thanks to @psrdrgz for the idea!)

Two functions have been migrated to their own repositories to simplify and enable improved collaboration. Copies remain here for historical purposes and may be updated:

Instructions

These files contain functions. For example, Invoke-Sqlcmd2.ps1 contains the Invoke-Sqlcmd2 function.

    # PowerShell 5, or PackageManagement available?
    Install-Module WFTools -Force
    Import-Module WFTools
    Get-Command -Module WFTools
    Get-Help ConvertTo-FlatObject -Full

    # Alternatively:
    # Download and unblock the file(s).
    # Dot source the file(s) as appropriate.
    . "\\Path\To\Invoke-Sqlcmd2"

    # Use the functions
    Get-Help Invoke-Sqlcmd2 -Full
    Invoke-Sqlcmd2 -ServerInstance MyServer\MyInstance -Query "SELECT ServerName, VCNumCPU FROM tblServerInfo" -As PSObject -Credential $cred | ?{$_.VCNumCPU -gt 8}

Note: Using Import-Module to load these functions will break certain scenarios for Invoke-Parallel's variable import (details) - dot source the function if you need this.

TechNet Galleries Contributions

Many of these functions started out in the Technet Gallery. You might find more context at these links.

Help!

Would love contributors, suggestions, feedback, and other help!