Scripting

Hello,

We currently have a script that everyday at 7am emails a set of people. I took this script to see if I could get a list of assets that were updated within the last 365 days so I changed INTERVAL 24 HOUR to INTERVAL 365 DAY but got the same result when exporting both reports. What am I doing wrong?

SELECT ASSET_HISTORY.* 

FROM ORG1.ASSET_HISTORY

JOIN ASSET on ASSET.ID = ASSET_HISTORY.ASSET_ID

WHERE ASSET.ASSET_TYPE_ID = 5

AND TIME > DATE_SUB(NOW(), INTERVAL 24 HOUR)  AND USER_ID != 0