Report showing Windows assets missing Java

[sullivane]

I am trying to create a report that will have all the assets that do not have Java installed on them. I have this report that shows all of them that are not at the current version:

Select Top 1000000 tblAssets.AssetID,
tblAssets.AssetUnique,
tblSoftwareUni.softwareName,
tblSoftwareUni.SoftwarePublisher,
tblSoftware.softwareVersion,
tblAssets.AssetName
From tblAssets
Inner Join tblSoftware On tblAssets.AssetID = tblSoftware.AssetID
Inner Join tblSoftwareUni On tblSoftware.softID = tblSoftwareUni.SoftID
Inner Join tblAssetCustom On tblAssets.AssetID = tblAssetCustom.AssetID
Where tblSoftwareUni.softwareName Like '%Java%' And
tblSoftwareUni.SoftwarePublisher Like '%Oracle%' And
tblSoftware.softwareVersion Not Like '%8.0.740.2%' And tblAssetCustom.State =
1
Order By tblAssets.AssetName

I tried to modify it, for NOT LIKE, but it should be all the software on all the assets that isn't Java. Not the assets that are missing java.

Select Top 1000000 tblAssets.AssetID,
tblAssets.AssetUnique,
tblSoftwareUni.softwareName,
tblSoftwareUni.SoftwarePublisher,
tblSoftware.softwareVersion,
tblAssets.AssetName
From tblAssets
Inner Join tblSoftware On tblAssets.AssetID = tblSoftware.AssetID
Inner Join tblSoftwareUni On tblSoftware.softID = tblSoftwareUni.SoftID
Inner Join tblAssetCustom On tblAssets.AssetID = tblAssetCustom.AssetID
Where tblSoftwareUni.softwareName Not Like '%Java%' And
tblSoftwareUni.SoftwarePublisher Not Like '%Oracle%' And
tblAssetCustom.State = 1
Order By tblAssets.AssetName

Any help would be appreciated, I am not a SQL guy.

[sullivane]

Oh thank you! I looked for something in there, must have missed that one!

Thanks again!

[Susan_A · Accepted solution]

There is a sample report in our report center that lists Windows computers missing a specific software package. You can find it here.