/build/static/layout/Breadcrumb_cap_w.png

Kace report of systems 5 years old from Dell warranty ship date

Hi I'm looking to sort systems that are older than 5 years from the Dell ship date. Could someone assist with such report? Would like it to be sorted by "Decommission date"

Headers:
"Host name"
"End-user"
"System Model"
"Ship date"
"Warranty End Date"
"Decommission Date"


0 Comments   [ + ] Show comments

Answers (1)

Answer Summary:
Posted by: IgorAngelini 3 months ago
Second Degree Blue Belt
0

Top Answer

Here is a query that does sorta what you want, please define "Decommission date", it's the only thing that's missing.

SELECT MACHINE.NAME AS 'HOSTNAME',
USER.FULL_NAME AS 'ENDUSER',
MACHINE.CS_MODEL AS 'SYSTEM MODEL',
DELL_ASSET.SHIP_DATE AS 'SHIP DATE',
MAX(DELL_WARRANTY.END_DATE) AS 'WARRANTY END DATE'

FROM MACHINE

LEFT JOIN USER
ON MACHINE.USER = USER.USER_NAME

LEFT JOIN DELL_ASSET
ON DELL_ASSET.SERVICE_TAG = MACHINE.BIOS_SERIAL_NUMBER

LEFT JOIN DELL_WARRANTY
ON DELL_WARRANTY.SERVICE_TAG = MACHINE.BIOS_SERIAL_NUMBER

WHERE DELL_ASSET.SHIP_DATE < NOW() - INTERVAL 5 YEAR

GROUP BY MACHINE.ID

ORDER BY DELL_ASSET.SHIP_DATE /*DESC*/


Uncomment DESC to invert the sorting order to descend

 
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