Very short and simple post however, oh so important especially when a software vendor requires using specific version / hotfix.
First we need to import the SQLPS module and connect to the instance (Optionally you could cycle though your list of instances, or use the SQL server browser service to detect all available instances. Samples can be found within the following post)
To retrieve the version (Major.Minor.Build.BuildMinor) just call;
To get the product level for the instance of SQL Server;
For retrieving all applied hotfixes, execute the following;
Additionl information about the Get-Hotfix command can be found here http://technet.microsoft.com/en-us/library/hh849836.aspx. Or provide the ID if you are looking for a specific hotfix: