Hi all,

Running into a bit of trouble getting this report to work out correctly. What I'm expecting to see is a single Dell warranty row that shows the current status of the warranty associated to a system. Instead, I'm erroneously getting two rows, with Dell Service Tags that don't match the system that is being reported. 

I've attached a screenshot to hopefully make more sense of this:
bPQWJl.png

What am I doing wrong? Why are there multiple Service Tags for the same system? 

Any help greatly appreciated. Thanks!
Answer Summary:
Cancel
3 Comments   [ + ] Show Comments

Comments

  • Did you use the wizard or do you have a SQL query? If you have a query, please post it.

    Also, your computers may have multiple entries for the two different types of warranties. Our systems show a one year warranty and then a second extended warranty for an additional three years. Depending on the warranty you purchased for your systems you may have a similar situation.
  • I used the wizard to create the report. Be happy to provide any additional details. I understand that there may be an initial and an extended warranty tied to the machines - but what is throwing me for a loop is the fact that each system is showing two different Dell Service Tags for each warranty entry (in the above example, two warranty entries per system). It's the service tag portion that is messing me up - it's like KACE isn't pulling the correct data for the warranty based on the system name.

    I'm open to other suggestions - my overall goal is to show the system name + the dell warranty (both active and expired) information. What I was hoping would be an easy query.
  • This content is currently hidden from public view.
    Reason: Removed by member request
    For more information, visit our FAQ's.
  • Any chance the systems in question have had a motherboard swap?
    • Not since the agent has been rolled out - we are a fairly new setup.
Please log in to comment

Answers

3
Here's the report I wrote that shows the maximum warranty expiration date (it also includes the ship date):

SELECT DISTINCT(MACHINE.NAME), 
MACHINE.OS_NAME, 
MACHINE.CS_MODEL, 
MACHINE.CS_MANUFACTURER, 
DA.SHIP_DATE AS "Ship Date",
MAX(DW.END_DATE) AS "Warranty End Date",
DW.SERVICE_LEVEL_DESCRIPTION as "Service Level"
FROM MACHINE
LEFT JOIN DELL_ASSET DA on MACHINE.BIOS_SERIAL_NUMBER = DA.SERVICE_TAG
LEFT JOIN DELL_WARRANTY DW on MACHINE.BIOS_SERIAL_NUMBER = DW.SERVICE_TAG
WHERE MACHINE.CS_MANUFACTURER like 'Dell%'
GROUP BY MACHINE.NAME
ORDER BY "Ship Date", MACHINE.NAME

Answered 12/18/2014 by: chucksteel
Red Belt

  • That's perfect Chuck! Thank you so much!! Exactly what I needed!
  • This report is great and will work well for my need.

    But I have one small request, the "Last Sync" date be added to the report.

    This will help us determine workstations that are our of warranty and are still in service.

    Any help would be greatly appreciated.
    • The last sync is stored in MACHINE.LAST_SYNC so you can add that field to the end of the field list being selected. After DW.SERVICE_LEVEL_DESCRIPTION as "Service Level" add a comma and MACHINE.LAST_SYNC. If you really just want the date, then use DATE(MACHINE.LAST_SYNC).
      • Thank You, that did the trick. I also just needed the dates, for the warranty so I changed the MAX(DW.END_DATE) AS "Warranty End Date", to DATE(DW.END_DATE) AS "Warranty End Date",

        The only other field that I could use is the last logged in user, if you could share that it would be helpful.

        Here's the SQl that we're using so far.

        SELECT DISTINCT(MACHINE.NAME),
        MACHINE.OS_NAME,
        MACHINE.CS_MODEL,
        MACHINE.CS_MANUFACTURER,
        DA.SHIP_DATE AS "Ship Date",
        DATE(DW.END_DATE) AS "Warranty End Date",
        DW.SERVICE_LEVEL_DESCRIPTION as "Service Level",DATE(MACHINE.LAST_SYNC)
        FROM MACHINE
        LEFT JOIN DELL_ASSET DA on MACHINE.BIOS_SERIAL_NUMBER = DA.SERVICE_TAG
        LEFT JOIN DELL_WARRANTY DW on MACHINE.BIOS_SERIAL_NUMBER = DW.SERVICE_TAG
        WHERE MACHINE.CS_MANUFACTURER like 'Dell%'
        GROUP BY MACHINE.NAME
        ORDER BY "Ship Date", MACHINE.NAME

        Thanks for your help with this.
      • FYI, your Dell computers might have two warranty end dates because of the different service levels, which is why I was using MAX(DW.END_DATE) to get the latest date. If you just want the date of the last date use DATE(MAX(DW.END_DATE)).
  • Thanks Chuck this really worked well for me but I recently noticed many of my Warranty end dates were wrong and I found the report is recording the Direct Line Service and/or Dell Labor Support entry in KACE's warranty (service level) section. Is there a way to exclude these? By using the DATE(DW.END_DATE) I was able to not get the Direct Line Service dates but the Labor Support dates keeps showing.
    On a side note I noticed there were a few systems which had no entry and when I went to KACE I had to update them to get the service level dates. Is there a way to send a command to KACE to update all warranty on all inventory?
    Thanks
    • I'm choosing the maximum end date which is probably why it always returns the labor support entry. You could try adding a line to match the DW.SERVICE_LEVEL_DESCRIPTION = "Direct Line Service" to just get that.

      I'm not familiar with a way to automatically update the warranty information.
Please log in to comment
Answer this question or Comment on this question for clarity