Get-WMIObject - WMI query example
Powershell command to retrieve the productcode guids of the installed MSIs
Get-WmiObject -Namespace root\ccm\CIModels -Class CCM_MSIProduct | Sort-Object ProductName |Format-Table ProductName,ProductCode,ProductVersion -auto
Use this tool to browser the WMI items to query
http://www.microsoft.com/en-us/download/details.aspx?id=8572