Report for: Software is installed but the version is not up to date

[Quast]

With the following Report i get all assets without the Flashplayer and the specified Version:
Report:
Select Top 1000000 tsysAssetTypes.AssetTypeIcon10 As icon,
tblAssets.AssetID,
tblAssets.AssetUnique,
tblAssets.AssetName,
tblAssets.Domain,
tblAssets.Uptime,
tblState.State,
tblState.Statename,
tblAssets.Lastseen
From tblAssets
Inner Join tsysAssetTypes On tsysAssetTypes.AssetType = tblAssets.Assettype,
tblState
Where tblAssets.AssetID Not In (Select tblSoftware.AssetID
From tblSoftware Inner Join tblSoftwareUni On tblSoftwareUni.SoftID =
tblSoftware.softID
Where tblSoftwareUni.softwareName Like '%Adobe Flash Player 18 ActiveX%' And
tblSoftware.softwareVersion Like '18.0.0.232%') And tblAssets.Assettype = -1
Order By tblAssets.AssetUnique

End of Report

But what i want to get are all Assets with flash already installed but which don´t have the latest Version.

Can somebody help me with that topic?
Thank you

[Quast · Accepted solution]

I think i have the solution... just a "not"

Select Top 1000000 tsysAssetTypes.AssetTypeIcon10 As icon,
tblAssets.AssetID,
tblAssets.AssetUnique,
tblAssets.AssetName,
tblAssets.Domain,
tblAssets.IPAddress As IP,
tblAssets.Lastseen,
tblAssets.Username
From tblAssets
Inner Join tsysAssetTypes On tsysAssetTypes.AssetType = tblAssets.Assettype
Where tblAssets.AssetID In (Select tblSoftware.AssetID
From tblSoftware Inner Join tblSoftwareUni On tblSoftwareUni.SoftID =
tblSoftware.softID
Where tblSoftwareUni.softwareName Like '%Adobe Flash Player%ActiveX'
And tblSoftware.softwareVersion Not Like '24.0.0.221%') And
tblAssets.Lastseen <> '' And tblAssets.Assettype = -1
Order By tblAssets.AssetUnique