→ Having trouble accessing our new support portal or creating a ticket? Please notify our team here

cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
Randolfini
Engaged Sweeper
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
1 REPLY 1
Randolfini
Engaged Sweeper
*Bump*