cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
So0neX
Engaged Sweeper
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.
1 ACCEPTED SOLUTION
Susan_A
Lansweeper Alumni
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.

View solution in original post

1 REPLY 1
Susan_A
Lansweeper Alumni
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.