How do I combine topics in a report?
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?
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
-
You need to learn MySQL to be able to do stuff like this. - h2opolo25 9 years ago
Answers (2)
Please log in to answer
Posted by:
chucksteel
9 years ago
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
