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.

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))
Cancel
0 Comments   [ + ] Show Comments

Comments

Please log in to comment

Answers

3

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
Answered 08/09/2012 by: dugullett
Red Belt

  • 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.
    • 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.
      • That's perfect! Thanks for the help!
  • Very cool idea, I'll have to start using this as well!

    John
Please log in to comment
Answer this question or Comment on this question for clarity

Share