SQL Version and Update Patch Level Report

[alex_statpro]

Hello,

I'm trying to figure out a reliable way to report on SQL update levels. I know within SQL you can run a command to get the exact build number but I can't seem to get the same results within Lansweeper.
I need to know which CU level each server is at, and have the exact version - not just the version pulled out of the add/remove programs list since it seems to be incorrect.

Does anyone have any ideas?

For more info, the report needs server name, os, os sp, domain, sql versions. I can customize from there as long as I get the right build number of sql.

Thanks!

[Hemoco · Accepted solution]

try this

Select Top 1000000 tblAssets.AssetID,
  tblAssets.AssetUnique,
  tblAssets.Domain,
  tsysOS.OSname,
  tsysOS.Image As icon,
  tblSqlServers.displayVersion As Edition,
  tblSqlServers.skuName As License,
  tblSqlServers.spLevel As SP,
  tblSqlServers.serviceName As Service,
  tblSqlServers.lastChanged,
  tblSqlServers.dataPath,
  tblSqlServers.fileVersion,
  tblSqlServers.isWow64,
  tblSqlServers.language,
  tblSqlServers.installPath As installPath1,
  tblSqlServers.installPath,
  tblSqlServers.version
From tblAssets
  Inner Join tblAssetCustom On tblAssets.AssetID = tblAssetCustom.AssetID
  Inner Join tsysOS On tblAssets.OScode = tsysOS.OScode
  Inner Join tblSqlServers On tblAssets.AssetID = tblSqlServers.AssetID
Where tblAssetCustom.State = 1
Order By tblAssets.AssetName,
  Edition