Hi, all.

I'm working on a copy of the "Computers with Expired Dell Warranty Coverage" built-in report, and I'd like to combine the Device and Dell Warranty topics sin such a way that each computer will print to it's own line, especially when exporting to .csv. How would I go about doing this, provided that I have next to no knowledge of SQL?
1 Comment   [ + ] Show Comment

Comments

  • You need to learn MySQL to be able to do stuff like this.
Please log in to comment

Answers

1
You would need to use MySQL in order to create a report like this. I have created a report that only returns results based on the maximum warranty date and the query is below. Is this what you are looking for?
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 
Answered 01/23/2015 by: chucksteel
Red Belt

Please log in to comment
Answer this question or Comment on this question for clarity