Hello,
As a starting SQL scripter I'm trying to get a report with:
All computers which have 'SafeGuard Enterprise 5.30.0 Client' installed but not have 'SafeGuard Enterprise 5.35.2 Client ' installed. In the report i would like to have the computername and description.
SELECT distinct
dbo.tblSoftware.ComputerName,dbo.tblADComputers.Description
FROM dbo.tblSoftware,dbo.tblADComputers
WHERE (softwareName = 'SafeGuard Enterprise 5.30.0 Client')
AND (NOT (softwareName = 'SafeGuard Enterprise 5.35.2 Client '))
The script above gives me a huge list with the same computernames. So obviously i'm doing something wrong. But i cannot figure out what.
Any help is appreciated.
