sql_app_detection.ps1

<#
************************************************************************************************
 This Script used for SQL Version Detection
************************************************************************************************
 Created by:  Ioan Popovici, 18/03/2015
************************************************************************************************
 ModIfied by: Octavian Cordos, 21/03/2018
************************************************************************************************
#>

## Variables for Reference SQL Versions
[System.Version]$SQLVersion =  "13.0.4466.4" #2016 KB4057119
Try {

    $RegExPattern = "[0-9]+\.[0-9]+\.[0-9]+.[0-9]+"
    [System.Version]$GetSQLVersion = (Invoke-Command -ScriptBlock { SQLCMD.exe -Q "Select @@Version" } -ErrorAction Stop | Select-String -Pattern $RegExPattern).Matches.Value
}
Catch {
    ## Catch Error if SQLCMD is not Found
}

If ($GetSQLVersion.Major -eq $SQLVersion.Major -and $GetSQLVersion -ge $SQLVersion) {
    Write-Output "SQL is Updated"
}