functions/SharedFunctions.ps1
|
<#
.Synopsis Connect to SQL Server .DESCRIPTION Function can connect to SQL server with authetication Windows .EXAMPLE Example of how to use this cmdlet .EXAMPLE Another example of how to use this cmdlet .LINK Author: Mateusz Nadobnik Link: mnadobnik.pl Date: 16.07.2017 Version: 1.0.1.0 Keywords: Shared function, Version, SQL Server Notes: 1.0.0.4 - Without change. 1.0.0.6 - Repaired syntax 1.0.0.9 - Added SQL Server 2017 to Get-SQLServerFullName function #> Function Get-SQLServerFullName($param) { switch ($param) { 9 { return "SQL Server 2005" } 10 { return "SQL Server 2008" } 10.50 { return "SQL Server 2008 R2" } 11 { return "SQL Server 2012" } 12 { return "SQL Server 2014" } 13 { return "SQL Server 2016" } 14 { return "SQL Server 2017" } } } function Get-SQLServerVersion { [CmdletBinding()] Param ( # Param1 help description [Parameter(Mandatory = $true, ValueFromPipeline = $true)] [string]$ServerInstance ) Begin { } Process { try { $connectsqlserver = New-Object Microsoft.SqlServer.Management.Smo.Server $ServerInstance $connectsqlserver.ConnectionContext.ApplicationName = "DBA PowerShell App" $connectsqlserver.ConnectionContext.ConnectTimeout = 10 Write-Verbose "Connect to server $ServerInstance" if ($connectsqlserver.ConnectionContext.IsOpen -eq $false) { Write-Verbose "ConnectionString:$($connectsqlserver.ConnectionContext)" $connectsqlserver.ConnectionContext.LoginSecure = $true $connectsqlserver.ConnectionContext.Connect() } $connectsqlserver | Select-Object Name, Product, Edition, ProductLevel, VersionMajor, @{L = "VersionName"; E = { Get-SQLServerFullName $_.versionmajor } }, @{L = "Build"; E = { $_.VersionString } } } catch { Write-Debug -Message $_.Exception Write-Host $_.Exception.Message -ForegroundColor Yellow } } End { Write-Verbose "The disconnect connection with $ServerInstance" try { if ($connectsqlserver.ConnectionContext.IsOpen -eq $true) { $connectsqlserver.ConnectionContext.Disconnect() } } catch { Write-Host $_.Exception.Message -ForegroundColor Yellow } } } |