/build/static/layout/Breadcrumb_cap_w.png

KACE Product Support Question


Smart Label for Ship Date

08/09/2012 2794 views

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

Comments


All 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
 
This website uses cookies. By continuing to use this site and/or clicking the "Accept" button you are providing consent Quest Software and its affiliates do NOT sell the Personal Data you provide to us either when you register on our websites or when you do business with us. For more information about our Privacy Policy and our data protection efforts, please visit GDPR-HQ