Custom report for software

[So0neX]

Hello all,

I would like to know which request I need to do for get a list of machine where a programm are not install.
I already have the same request for get where is it install.

Select Top 1000000 Count(Distinct upgrade_tblSoftware.SoftwareID) As Totals,
upgrade_tblSoftware.softwareName,
upgrade_tblSoftware.softwareVersion,
upgrade_tblComputers.Computer,
upgrade_tblComputers.Username,
upgrade_tblSoftware.SoftwarePublisher
From upgrade_tblComputers
Inner Join upgrade_web40ActiveComputers
On upgrade_web40ActiveComputers.Computername =
upgrade_tblComputers.Computername
Inner Join upgrade_tblSoftware On upgrade_tblComputers.Computername =
upgrade_tblSoftware.ComputerName
Where upgrade_tblSoftware.SoftwarePublisher Like '%MYPROGRAM%'
Group By upgrade_tblSoftware.softwareName,
upgrade_tblSoftware.softwareVersion,
upgrade_tblComputers.Computer,
upgrade_tblComputers.Username,
upgrade_tblSoftware.SoftwarePublisher

What I need change for know where "MYPROGRAM" are not install ?

Thanks a lot.

[Susan_A · Accepted solution]

There is a sample report in our report center for this. You can find it here and add it to your Lansweeper installation by following these instructions.