/build/static/layout/Breadcrumb_cap_w.png

KACE Product Support Question


Warranty details help

08/18/2016 567 views
Hi All,

Im using this Query im getting all the details  as below but i want only the start and end date with one row..any query ?

select distinct UCASE(m.NAME) as NAME, m.USER_FULLNAME,m.USER, m.OS_NAME, m.CS_MANUFACTURER, m.CS_MODEL,w.SERVICE_LEVEL_DESCRIPTION, w.SERVICE_TAG, w.START_DATE,w.END_DATE ,DATEDIFF(Now(), w.START_DATE) as DayCount
from MACHINE as m, DELL_WARRANTY as w 
where m.BIOS_SERIAL_NUMBER = w.SERVICE_TAG
order by w.START_DATE DESC

SERVICE_TAG SERVICE_LEVEL_DESCRIPTION   START_DATE END_DATE NAME
15FW4XX Parts Only Warranty 2/3/12 13:00 2/4/13 12:59  DTP0111
15FW4XX Parts Only Warranty 2/3/10 13:00 2/4/12 12:59  DTP0111
15FW4XX Next Business Day response 2/3/12 13:00 2/4/13 12:59  DTP0111
15FW4XX Next Business Day response 2/3/10 13:00 2/4/12 12:59  DTP0111
0 Comments   [ + ] Show comments

Comments


All Answers

1
You need to select just the Max dates. Here is my warranty report:
SELECT M.NAME AS MACHINE_NAME, M.CS_MODEL AS MODEL, DA.SERVICE_TAG, DA.SHIP_DATE,M.USER_LOGGED AS LAST_LOGGED_IN_USER, DW.SERVICE_LEVEL_CODE, 
DW.SERVICE_LEVEL_DESCRIPTION, MAX(DW.END_DATE) AS EXPIRATION_DATE 
FROM DELL_WARRANTY DW JOIN DELL_ASSET DA ON (DW.SERVICE_TAG = DA.SERVICE_TAG) 
JOIN MACHINE M ON (M.BIOS_SERIAL_NUMBER = DA.PARENT_SERVICE_TAG OR M.BIOS_SERIAL_NUMBER = DA.SERVICE_TAG) 
WHERE M.CS_MANUFACTURER LIKE '%dell%' 
AND M.BIOS_SERIAL_NUMBER!='' 
AND DA.DISABLED != 1 
This includes a few different fields but should demonstrate the concept you need to apply.

Answered 08/18/2016 by: chucksteel
Red Belt

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