Missing versions of Visual Studio

[Randolfini]

Hi,

I have a Microsoft Audit report that I've built over time, however recently I noticed that the report won't list minor versions of Visual Studio products. For example it will show Microsoft Visual Studio Professional 2013 but not Microsoft Visual Studio Professional 2013 with Update 4. Report is below.

Select Top 1000000 tblAssets.AssetID,
  tblAssets.AssetName,
  tblAssets.IPAddress,
  tblAssets.Mac,
  tblAssets.Username,
  tblAssets.Lastseen,
  tblSoftwareUni.softwareName,
  tsysOS.OSname,
  tsysOS.Image As icon,
  tblSoftware.softwareVersion
From tblAssets
  Inner Join tblAssetCustom On tblAssets.AssetID = tblAssetCustom.AssetID
  Inner Join tblSoftware On tblAssets.AssetID = tblSoftware.AssetID
  Inner Join tblSoftwareUni On tblSoftwareUni.SoftID = tblSoftware.softID
  Inner Join tsysOS On tblAssets.OScode = tsysOS.OScode
Where tblAssets.Lastseen > GetDate() - 30 And (tblSoftwareUni.softwareName Like
    'Microsoft office %' Or
    tblSoftwareUni.softwareName Like 'Microsoft project%' Or
    tblSoftwareUni.softwareName Like 'Microsoft visio%' Or
    tblSoftwareUni.softwareName Like 'Microsoft office visio%' Or
    tblSoftwareUni.softwareName Like 'Microsoft visual studio%') And
  tblSoftwareUni.softwareName Not Like '%viewer%' And
  tblSoftwareUni.softwareName Not Like '%designer%' And
  tblSoftwareUni.softwareName Not Like '%live%' And
  tblSoftwareUni.softwareName Not Like '%tools%' And
  tblSoftwareUni.softwareName Not Like '%express%' And
  tblSoftwareUni.softwareName Not Like '%shell%' And
  tblSoftwareUni.softwareName Not Like '%sdk%' And
  tblSoftwareUni.softwareName Not Like '%prerequisites%' And
  tblSoftwareUni.softwareName Not Like '%framework%' And
  tblSoftwareUni.softwareName Not Like '%community%' And
  SubString(tblSoftwareUni.softwareName, Len(tblSoftwareUni.softwareName) - 3,
  2) = '20' And tblAssetCustom.State = 1
Order By tblAssets.AssetName,
  tblSoftwareUni.softwareName

[Randolfini]

*Bump*