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.

New to Lansweeper?

Try Lansweeper For Free

Experience Lansweeper with your own data.
Sign up now for a 14-day free trial.

Try Now