Windows 8.1 Update

[CBTechnology]

I would like the ability to differentiate between a machine with Windows 8.1 and one that has the new 8.1 Update. As of now I don't see a way to know if a machine has the update or not. Is there a way to do this now or something coming soon?

Thanks!

[ict-user]

You can create a registry scan for:

"HKLM\SOFTWARE\Microsoft\Windows NT\CurrentVersion"
BuildLabEx = 9600.17085.amd64fre.winblue_gdr.140330-1035

http://www.lansweeper.com/kb/18/report-based-on-registry-keys.html

has to be 17085 or higher

http://superuser.com/questions/742124/how-to-differentiate-windows-8-1-update-1-from-windows-8-1

[RCorbeil]

The initially-posted code put "Win 8.1 Update" in a separate field. I revised it to return "Win 8.1 Update" if the KB is found, else return whatever the recorded OS is, so presumably "Win 8.1" if the KB isn't found. (I don't have any Win 8 machines to verify with, but in theory it should work.)

[CBTechnology]

Definitely a good idea but the code as it is doesn't work. That code results in showing all my devices.

EDIT - My Bad...took another look at the code and see that it will return all my units and add the column for the update. Thanks a lot, this works well enough for the time being.

[RCorbeil · Accepted solution]

Would checking for the presence of KB2919355 do the trick?

SELECT Top 1000000 tblAssets.AssetID,
  tblAssets.AssetName,
  tsysAssetTypes.AssetTypename,
  tsysAssetTypes.AssetTypeIcon10 As icon,
  tblAssets.IPAddress,
  tblAssets.Lastseen,
  tblAssets.Lasttried,
  CASE
    WHEN EXISTS ( SELECT
                    tblQuickFixEngineering.AssetID
                  FROM
                    tblQuickFixEngineering
                    INNER JOIN tblQuickFixEngineeringUni ON tblQuickFixEngineeringUni.QFEID = tblQuickFixEngineering.QFEID
                  WHERE
                    tblQuickFixEngineering.AssetID = tblAssets.AssetID
                    And tblQuickFixEngineeringUni.HotFixID Like 'KB2919355%'
                )
    THEN 'Win 8.1 Update'
    ELSE tsysOS.OSname
  END AS OSName,
  tblAssets.SP
FROM
  tblAssets
  INNER JOIN tblAssetCustom ON tblAssets.AssetID = tblAssetCustom.AssetID
  INNER JOIN tsysAssetTypes ON tsysAssetTypes.AssetType = tblAssets.Assettype
  INNER JOIN tsysOS ON tblAssets.OScode = tsysOS.OScode
WHERE
  tblAssetCustom.State = 1