joerodgers

## CustomSearchConfigurationMangagement.ps1
Add-PSSnapin Microsoft.SharePoint.PowerShell

function Enable-SearchConfigurationFeature
{
    [cmdletbinding()]
    param
    (
        [Parameter(Mandatory=$true,ValueFromPipeline=$true)][Microsoft.SharePoint.SPWeb]$Web
    )

## Get-RSAddInVersion.ps1
Add-PSSnapin -Name Microsoft.SharePoint.PowerShell

$servers = @(Get-SPServer | ? Role -ne "Invalid" | SELECT -ExpandProperty Name)

foreach( $server in $servers )
{
    $products = @(Get-CimInstance -ClassName Win32_Product -ComputerName $server -Filter "Name like 'Microsoft SQL Server%RS Addin%'")

    if( $products.Count -gt 0 )
    {

## Get-PrincipalGroupMembership.ps1

function Get-PrincipalGroupMembership
{
    [CmdletBinding()]
    param
    (
        [parameter(Mandatory=$true,ValueFromPipeline=$true)][string]$Login
    )

    begin

## Get-SandboxSolutionInstances.ps1
Add-PSSnapin Microsoft.SharePoint.PowerShell -ErrorAction SilentlyContinue | Out-Null

$sites = Get-SPSite -Limit All | ? IsReadLocked -eq $false

$results = @()

foreach( $site in $sites )
{
    $solutions = @($site | Get-SPUserSolution)

## Get-TotalItemsInContentDatabase.ps1
$sites = Get-SPSite -Limit All -ContentDatabase "SP2016_CONTENT_001"

$itemCounts = @()

foreach( $site in $sites )
{
    $itemCount = 0

    $lists = $site | Get-SPWeb -Limit All | SELECT -ExpandProperty Lists

## Get-WorkflowInstance.ps1
Add-PSSnapin Microsoft.SharePoint.PowerShell

function Get-WorkflowInstance
{
    [cmdletbinding()]
    param
    (
        [Parameter(Mandatory=$true,ValueFromPipeline=$true)][Microsoft.SharePoint.SPWeb]$Web
    )

## Download-Folder.ps1
Add-PSSnapin Microsoft.Sharepoint.PowerShell

function Download-Folder
{
    [CmdletBinding()]
    param
    (
        [Parameter(Mandatory=$true)][string]$SharePointFolderUrl,
        [Parameter(Mandatory=$true)][string]$Path,
        [Parameter(Mandatory=$false)][switch]$Recurse

## Get-FilesThatWillNotOpen.ps1
Add-PSSnapin -Name Microsoft.SharePoint.PowerShell

function Get-FilesThatWillNotOpen
{
    [cmdletbinding()]
    param
    (
        [parameter(Mandatory=$true)][Microsoft.SharePoint.SPSite]$Site
    )


## debug1.ps1

$web = Get-SPWeb -Identity "https://sharepoint.2016.contoso.com/sites/teamsite"
$Library = $web.Lists.TryGetList("Documents")

$query = New-Object Microsoft.SharePoint.SPQuery
$query.ViewXml = "<View Scope='RecursiveAll'>
                      <Query>
                          <Where>
                              <Eq>
                                  <FieldRef Name='FSObjType'/>

## GetAutoGrowthSettings.sql

SELECT
     DB_NAME(mf.database_id) AS 'Database Name'
    ,mf.Name AS 'Database File Name'
    ,CONVERT(DECIMAL (20,2)
    ,CONVERT(DECIMAL, size)/128) AS 'Current File Size'
    ,CASE mf.is_percent_growth
        WHEN 1 THEN 'Yes'
        ELSE 'No'
        END AS 'Is Percentage Growrth'