Having issues running a report that shows when software is added to a particular machine
I am attempting to generate a report that shows when any software that is added to a particular machine in our computer inventory. Here is the code that the KACE representative and I have been manipulating and it still doesnt yield any results when the report is ran:
select TIME, ASSET.NAME as MACHINE_NAME, DESCRIPTION
from ASSET_HISTORY, ASSET, MACHINE
WHERE DESCRIPTION LIKE '%Found Software%' AND ASSET_HISTORY.TIME >
DATE_SUB(NOW(),INTERVAL 1 DAY)
and ASSET_ID=ASSET.ID AND ASSET.NAME=MACHINE.NAME and MACHINE.USER_DOMAIN
Any assistance would be greatly appreciated.