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.