/build/static/layout/Breadcrumb_cap_w.png

Create Report for machines five years and older from Ship Date.

Hello,
I have tried and searched but I cannot figure out how to create a report that takes the Ship Date and then reports back all items that are five years and older and which ones are getting close to five years. Does anyone have something like this?

Thanks.

0 Comments   [ + ] Show comments

Answers (1)

Answer Summary:
Posted by: chucksteel 9 years ago
Red Belt
2

Top Answer

This query will find Dell computers over five years old:
SELECT MACHINE.NAME, MACHINE.OS_NAME, MACHINE.CS_MANUFACTURER, DA.SHIP_DATE
FROM MACHINE
LEFT JOIN DELL_ASSET DA on MACHINE.BIOS_SERIAL_NUMBER = DA.SERVICE_TAG

WHERE MACHINE.CS_MANUFACTURER like 'Dell%'
GROUP BY MACHINE.NAME
HAVING DA.SHIP_DATE < DATE_SUB(NOW(), INTERVAL 5 YEAR)
ORDER BY DA.SHIP_DATE, MACHINE.NAME

I'm not sure how you would define "close to five years" but you can play with the interval clause to get different results. 

Comments:
  • This only shows windows 7. If I shorten the interval, how do I get it to pull any OS? - jlackman 6 years ago
    • The report includes Windows 10 machines when I run it on my appliance. It does not include any limits that would make it only include Windows 7 machines. - chucksteel 6 years ago
      • Yeah that's what I expected so I'm not sure what's up here. I have been doing a lot of upgrades on this appliance and I think I will open a ticket see what they say as several reports (even canned ones) have some unusual behavior. - jlackman 6 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

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