PoShMon

1.3.0

Functions/PoShMon.Monitoring.SharePoint/Test-SPDatabaseHealth.ps1

Function Test-SPDatabaseHealth
{
    [CmdletBinding()]
    param (
        #[System.Management.Automation.Runspaces.PSSession]$RemoteSession
        [hashtable]$PoShMonConfiguration
    )

    $mainOutput = Get-InitialOutputWithTimer `
                                            -SectionHeader "Database Status" `
                                            -OutputHeaders ([ordered]@{ 'DatabaseName' = 'Database Name'; 'Size' = 'Size (GB)'; 'NeedsUpgrade' = 'Needs Upgrade?' }) `
                                            -HeaderUrl ($PoShMonConfiguration.SharePoint.CentralAdminUrl + "/_admin/DatabaseStatus.aspx") `
                                            -LinkColumn 'DatabaseName'

    $spDatabases = Invoke-RemoteCommand -PoShMonConfiguration $PoShMonConfiguration -ScriptBlock {
                        return Get-SPDatabase | Sort DiskSizeRequired -Descending
                    }

    foreach ($spDatabase in $spDatabases)
    {
        $needsUpgradeText = if ($spDatabase.NeedsUpgrade) {"Yes"} else {"No"}
        $SizeText = ($spDatabase.DiskSizeRequired/1GB).ToString(".00")

        Write-Verbose "`t$($spDatabase.DisplayName) : $needsUpgradeText : $SizeText GB"

        $highlight = @()

        if ($spDatabase.NeedsUpgrade)
        {
            $mainOutput.NoIssuesFound = $false
            $highlight += 'NeedsUpgrade'
            Write-Warning ("`t" + $spDatabase.DisplayName + " (" + $spDatabase.ApplicationName + ") is listed as Needing Upgrade")
        }

        if ($spDatabase.Type -eq 'Content Database')
            { $itemLink = ($PoShMonConfiguration.SharePoint.CentralAdminUrl + "/_admin/oldcntdb.aspx?DatabaseId={$($spDatabase.Id)}") }
        else
            { $itemLink = '' }

        $mainOutput.OutputValues += [pscustomobject]@{
            'DatabaseName' = $spDatabase.DisplayName;
            'NeedsUpgrade' = $needsUpgradeText
            'Size' = $SizeText;
            'Highlight' = $highlight
            'ItemLink' = $itemLink
        }
    }

    return (Complete-TimedOutput $mainOutput)
}
<#
    $output = Test-SPDatabaseHealth $remoteSession -Verbose
#>