/build/static/layout/Breadcrumb_cap_w.png

KACE Product Support Question


How do I combine topics in a report?

01/22/2015 3948 views
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.

All 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

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