/build/static/layout/Breadcrumb_cap_w.png

Dell Warranty Reporting SQL: Display only "Next Business Day Support"

Good Afternoon everyone,

I have a report set up in KACE set up to display my Dell warranties. Unfortunately the Warranty information it displays is not what I had intended. Im trying to only display the "Next Business Day Support" End Date and will display whatever shows in spot #1 for Service Level Description.  Can someone provide additional criteria I am missing. Below is the SQL I have been using:

SELECT DISTINCT(MACHINE.NAME), 

MACHINE.OS_NAME, 

MACHINE.CS_MODEL, 

MACHINE.CS_MANUFACTURER, 

DA.SHIP_DATE AS "Ship Date",

MAX(DW.END_DATE) AS "Warranty End Date",

DW.SERVICE_LEVEL_DESCRIPTION as "Next Business Day Support",

MACHINE.USER_LOGGED

FROM MACHINE

LEFT JOIN DELL_ASSET DA on MACHINE.BIOS_SERIAL_NUMBER = DA.SERVICE_TAG

LEFT JOIN DELL_WARRANTY DW on MACHINE.BIOS_SERIAL_NUMBER = DW.SERVICE_TAG

WHERE MACHINE.CS_MANUFACTURER like 'Dell%'

GROUP BY MACHINE.NAME

ORDER BY "Ship Date", MACHINE.NAME


Thanks everyone,
Frank M. Siemen


0 Comments   [ + ] Show comments

Answers (0)

Be the first to answer this question

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