Report by ProSupport Warranty End Date
Has anyone created a report to show all PC that have ProSupport warranty end date within the next 3 number of months (or similar)?
I have done some reports but they come out with systems showing up 3 to 6 times in the report because they have different types of warranties. We are looking to do a report that only shows the ProSupport (primary warranty) coming up. I'd appreciate if anyone has been able to generate this report sharing their SQL Code.
Thanx
2 Comments
[ + ] Show comments
Answers (0)
Please log in to answer
Be the first to answer this question
["SELECT SYSTEM_DESCRIPTION, CHASSIS_TYPE, CSP_ID_NUMBER, CS_MODEL, MACHINE.NAME AS SYSTEM_NAME, MACHINE.ID as TOPIC_ID, ifnull(MACHINE.ID,0) as SEED_COLUMN FROM MACHINE ORDER BY SYSTEM_DESCRIPTION","SELECT DELL_WARRANTY.END_DATE, DELL_WARRANTY.SERVICE_LEVEL_DESCRIPTION, MACHINE.ID as TOPIC_ID, GROUP_CONCAT(DISTINCT REPORT_TEMP.TT1.ROW ORDER BY REPORT_TEMP.TT1.ROW) AS PARENT_ROW FROM DELL_WARRANTY left join MACHINE on MACHINE.BIOS_SERIAL_NUMBER = DELL_WARRANTY.SERVICE_TAG left join (select @limitct :=0) T on 1=1 JOIN REPORT_TEMP.TT1 ON (REPORT_TEMP.TT1.ID = MACHINE.ID) WHERE ((DELL_WARRANTY.SERVICE_LEVEL_DESCRIPTION = 'ProSupport') AND (DELL_WARRANTY.END_DATE > '2016-12-31 15:38:09') AND (DELL_WARRANTY.END_DATE < '2018-12-31 15:33:33')) GROUP BY DELL_WARRANTY.SERVICE_TAG,START_DATE,END_DATE ORDER BY END_DATE"] - DaveMT 6 years ago