Reports =List of PCs with out a specific software installed

[jonreichert]

We require that a certain software program is installed on all of our PCs. Can I create a report that returns a list of PCs that do nit have this specific software installed? Thanks ins advance...

[brandon_jones]

Try this. Just replace "put software name here" with the name of your software.

Select Top 1000000 tsysOS.Image As icon,
tblAssets.AssetID,
tblAssets.AssetName,
tblAssets.Domain,
tblAssets.Username,
tblAssets.Userdomain,
tblAssets.IPAddress,
tblAssets.Firstseen,
tblAssets.Lastseen,
tblAssets.Lasttried
From tblAssets
Inner Join tblAssetCustom On tblAssets.AssetID = tblAssetCustom.AssetID
Inner Join tsysOS On tsysOS.OScode = tblAssets.OScode
Where tblAssets.AssetID Not In (Select Top 1000000 tblSoftware.AssetID
From tblSoftware Inner Join tblSoftwareUni On tblSoftwareUni.SoftID =
tblSoftware.softID
Where tblSoftwareUni.softwareName Like'%put software name here%') And tblAssetCustom.State = 1
Order By tblAssets.Domain, tblAssets.AssetName