Computers who dosen't have specific Software Name

[tgrignon]

What is the query to have the listed computers who dosen't have a specific software name?

[Hemoco · Accepted solution]

A sample report can be seen below. Replace YourSoftware with the name of the software package you would like to report on.

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