/build/static/layout/Breadcrumb_cap_w.png

Machine detailed inventory

HI Team,

               I need a help to identify the machines which are lying more than 3years in my network not by using a warranty expired report.
               Because i need to create a detail report about the machines which are 2yrs, 3yrs, 4yrs .. older.

Thanks
Raja Singh
Asked 9 years ago 1047 views
1 Comment   [ + ] Show comment
  • The challenge you have is finding a date that is when the machine was installed. If the device is a dell machine you can use the shipped date field within the warranty section of the inventory. Otherwise if you have had KACE for years you could use the Created date, or if the machine has not been reimaged then you can use the OS install date. - Hobbsy 9 years ago

Answers (2)

Posted by: Hobbsy 9 years ago
Red Belt
0
Or try using this SQL in a report and see what results you get ;o)

SELECT
MACHINE.CS_MODEL as 'Model',
COUNT(DISTINCT CASE WHEN YEAR(DELL_WARRANTY.START_DATE) = YEAR(NOW())-1 THEN MACHINE.ID END) as '1Yr',
COUNT(DISTINCT CASE WHEN YEAR(DELL_WARRANTY.START_DATE) = YEAR(NOW())-2 THEN MACHINE.ID END) as '2Yr',
COUNT(DISTINCT CASE WHEN YEAR(DELL_WARRANTY.START_DATE) = YEAR(NOW())-3 THEN MACHINE.ID END) as '3Yr',
COUNT(DISTINCT CASE WHEN YEAR(DELL_WARRANTY.START_DATE) = YEAR(NOW())-4 THEN MACHINE.ID END) as '4Yr',
COUNT(DISTINCT CASE WHEN YEAR(DELL_WARRANTY.START_DATE) = YEAR(NOW())-5 THEN MACHINE.ID END) as '5Yr',
COUNT(DISTINCT CASE WHEN YEAR(DELL_WARRANTY.START_DATE) <= YEAR(NOW())-6 THEN MACHINE.ID END) as '6+Yr',

FROM
DELL_WARRANTY
LEFT JOIN MACHINE ON DELL_WARRANTY.SERVICE_TAG = MACHINE.BIOS_SERIAL_NUMBER 
GROUP BY 
MACHINE.CS_MODEL
ORDER BY
Posted by: aragorn.2003 9 years ago
Red Belt
0
Based on the shipped date you can run the following SQL script

select distinct UCASE(m.NAME), m.CS_MANUFACTURER, m.CS_MODEL, w.SERVICE_TAG, w.START_DATE
  from MACHINE as m, DELL_WARRANTY as w
 where m.BIOS_SERIAL_NUMBER = w.SERVICE_TAG
   and w.START_DATE < MAKEDATE(YEAR(NOW()),MONTH(NOW())) - interval 5 year
order by w.START_DATE
Comments:

Posted by:

Raja Frost Senior White Belt
Ninja since: 9 years ago

Don't be a Stranger!

Sign up today to participate, stay informed, earn points and establish a reputation for yourself!

Sign up! or login

View more:

KACE Product Support Questions
question

Related Questions

Link

Related Links

Post

Related Posts

Share

 
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