Software Report

[chads]

So we currently have this report to show all installations of Google Chrome.

How do i make another one that shows machines that don't have Google Chrome.

Current Report

Select Top 1000000 upgrade_web40osname.Compimage As icon,
upgrade_tblcomputers.Computername,
upgrade_tblcomputers.Computer,
upgrade_tblcomputers.Domain,
upgrade_tblsoftware.softwareName As Software,
upgrade_tblsoftware.softwareVersion As Version,
upgrade_tblsoftware.SoftwarePublisher As Publisher,
Convert(Varchar(10),upgrade_tblsoftware.Installdate,101) As Installdate,
upgrade_tblsoftware.Lastchanged
From upgrade_tblcomputers
Inner Join upgrade_web40osname On upgrade_web40osname.Computername =
upgrade_tblcomputers.Computername
Inner Join upgrade_tblsoftware On upgrade_tblcomputers.Computername =
upgrade_tblsoftware.ComputerName
Where upgrade_tblsoftware.softwareName Like '%chrome%' And
upgrade_tblsoftware.SoftwarePublisher Like '%google%'
Order By upgrade_tblcomputers.ComputerUnique

[Hemoco · Accepted solution]

A sample report can be seen below.

Select Top 1000000 tsysAssetTypes.AssetTypeIcon10 As icon,
tblAssets.AssetID,
tblAssets.AssetUnique,
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 '%Chrome%' and blSoftwareUni.SoftwarePublisher Like '%google%') And
tblAssets.Lastseen <> '' And tblAssets.Assettype = -1
Order By tblAssets.AssetUnique