Returns SQL Server Build information on a SQL instance.
Returns info about the specific build of a SQL instance, including the SP, the CU and the reference KB, wherever possible.
It also includes End Of Support dates as specified on Microsoft Lifecycle Policy.
Returns SqlInstance, SPLevel, CULevel, KBLevel, Supported Until for server sqlserver2014a.
Get-DbaSqlBuildReference -SqlInstance sqlserver2014a
Does the same as above but logs in as SQL user “sqladmin”.
$cred = Get-Credential sqladmin
Get-DbaSqlBuildReference -SqlInstance sqlserver2014a -SqlCredential $cred
Returns information about a build identified by “12.00.4502” (which is SQL 2014 with SP1 and CU11).
Get-DbaSqlBuildReference -Build “12.00.4502”
This command was created by Simone Bizzotto. You can find Simone on LinkedIn.