Hallo Simon,
das folgende Statement kannst du für dein Vorhaben verwenden:
select HostName, ScanDate, SoftwareName, SoftwarePublisher, SoftwareInstallDate
from tHosts
INNER JOIN tDocu ON tHosts.HostID = tDocu.DocuID
INNER JOIN tSoftware ON tDocu.DocuID = tSoftware.DocuID
where Archiv = 0
and HostTypeID IN (1,2,3)
and SoftwareInstallDate > CURRENT_TIMESTAMP – 14
order by SoftwareInstallDate desc
Mit freundlichen Grüßen,
Docusnap Support