Problem generating report

[mreis18]

I need help creating a report

"how many machines do not have the FORCEPOINT ONE ENDPOINT software

can anyone help me wI need help creating a report

"how many machines do not have the FORCEPOINT ONE ENDPOINT software

can anyone help me with thisith this

[mreis18]

it worked thanks

[brandon_jones]

Try This. Be sure to replace the name of the program you are looking for in place of NameOfProgramHere that is in bold.

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
Inner Join tblAssetCustom On tblAssets.AssetID = tblAssetCustom.AssetID
Inner Join tsysAssetTypes tsysAssetTypes1 On tsysAssetTypes1.AssetType =
tblAssets.Assettype
Inner Join tblComputersystem On tblAssets.AssetID = tblComputersystem.AssetID
Where tblAssets.AssetID Not In (Select tblSoftware.AssetID
From tblSoftware Inner Join tblSoftwareUni On tblSoftwareUni.SoftID =
tblSoftware.softID
Where
tblSoftwareUni.softwareName Like '%NameOFProgramHere%')
And tblAssets.Lastseen <> '' And tblAssetCustom.State = 1 And tblComputersystem.Domainrole < 2
Order By tblAssets.AssetUnique