KACE Product Support Question
Smart Label for Ship Date
Is there a way to create a Smart Label in Kace for machines that are older than 4 years old? We would like to know at glance how many we need to start replacing, and it doesn't appear to be the standard list of options.
select *, UNIX_TIMESTAMP(now()) - UNIX_TIMESTAMP(LAST_SYNC) as LAST_SYNC_TIME, UNIX_TIMESTAMP(MACHINE.LAST_SYNC) as LAST_SYNC_SECONDS from ORG1.MACHINE JOIN KBSYS.DELL_ASSET ON KBSYS.DELL_ASSET.SERVICE_TAG =MACHINE.BIOS_SERIAL_NUMBER where ((KBSYS.DELL_ASSET.SHIP_DATE < CURDATE() - INTERVAL 4 YEAR))