/bundles/itninjaweb/img/Breadcrumb_cap_w.png

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   [ - ] Hide Comments

Comments

  • Can you post what you have right now?
  • 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"]
Please log in to comment

There are no answers at this time
Answer this question or Comment on this question for clarity

Answers