KACE Product Support Question
Setting the Interval in a report
02/13/2017 587 views
I have the following script to list the PCs in Kace older than 3 years.
SELECT MACHINE.NAME, CS_MODEL, BIOS_SERIAL_NUMBER, DA.SHIP_DATE, USER_FULLNAME, USER_LOGGED, MACHINE.OS_NAME
LEFT JOIN DELL_ASSET DA on MACHINE.BIOS_SERIAL_NUMBER = DA.SERVICE_TAG
WHERE MACHINE.CS_MANUFACTURER like 'Dell%'
GROUP BY MACHINE.NAME
HAVING DA.SHIP_DATE < DATE_SUB(NOW(), INTERVAL 3 YEAR)
ORDER BY DA.SHIP_DATE, MACHINE.NAME
My question is this: how do you manipulate the 'Interval' so that, for instance, I could list PCs greater than 3 years old but less than 5? Is this possible?
Answer Chosen by the Author
Please log in to answer