/build/static/layout/Breadcrumb_cap_w.png

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
  • Can you post what you have right now? - JasonEgg 2 years ago
  • Here ya go. I narrowed it down by having it only display the ProSupport, but my procurement person would like it to be one line per device when they run the report to an XLS format:

    ["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 2 years ago

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