Scripts/Test-PSWSUSDatabaseServerConnection.ps1
|
Function Test-PSWSUSDatabaseServerConnection { <# .SYNOPSIS Tests the database connection from the console to the SQL database hosting the WSUS database. .DESCRIPTION Tests the database connection from the console to the SQL database hosting the WSUS database. .NOTES Name: Test-PSWSUSDatabaseServerConnection Author: Boe Prox DateCreated: 06DEC2010 .LINK https://learn-powershell.net .EXAMPLE Test-PSWSUSDatabaseServerConnection Description ----------- This command will test the database connection and return a boolean value based on the connection status. #> [cmdletbinding()] Param () Process { If ($wsusdb) { Try { #Test the connection to the database Write-Verbose "Testing the database connection to the WSUS database server." $wsusdb.ConnectToDatabase() Write-Output $True } Catch { Write-Output $False } } Else { Write-Warning "Please connect to the database first using Connect-PSWSUSDatabaseServer" } } } |