/build/static/layout/Breadcrumb_cap_w.png

Systems Management Question


Report by ProSupport Warranty End Date

03/09/2018 722 views

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

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"]

Be the first to answer this question

 
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