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
Share SNMP OID and MIB Information
It’s easy to add custom SNMP OID GETs to your Dell KACE K1000 inventory, but where do you find the exact OIDs you need for a specific device? This is the place to share the OIDs and MIBs you have – and to request the ones you need.

Share