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.
0 Comments
[ + ] Show comments
Answers (1)
Answer Summary:
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))
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))
Please log in to answer
Posted by:
dugullett
11 years ago
Are they all Dells? This would work for a report. Also have a look at this http://www.itninja.com/question/windows-7-readiness-report We're getting ready to do something similiar.
SELECT NAME AS Computer_Name, D.SHIP_DATE FROM MACHINE M JOIN KBSYS.DELL_ASSET D ON D.SERVICE_TAG = M.BIOS_SERIAL_NUMBER WHERE D.SHIP_DATE < CURDATE() - INTERVAL 4 YEAR ORDER BY D.SHIP_DATE
Comments:
-
Thanks for the reply! All the computers are Dells, and the report you have works great. I'm wondering, though, if it is possible to put that in a Smart Label. Perhaps not because Ship Date isn't one of their included fields. - retter 11 years ago
-
Try this. I don't have a ton a Dell's so I can't really test accurately, but it seems to be working. Create a dummy label. Then go into that label and paste this into the SQL query.
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))
Keep in mind that the machines will not get the label until next check in. - dugullett 11 years ago-
That's perfect! Thanks for the help! - retter 11 years ago
-
