/build/static/layout/Breadcrumb_cap_w.png

Report Help - Dell Warranty

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!

3 Comments   [ + ] Show 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. - chucksteel 9 years ago
  • 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. - bpatton 9 years ago
  • Any chance the systems in question have had a motherboard swap? - EdT 9 years ago
    • Not since the agent has been rolled out - we are a fairly new setup. - bpatton 9 years ago

Answers (1)

Answer Summary:
Posted by: chucksteel 9 years ago
Red Belt
4
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


Comments:
  • That's perfect Chuck! Thank you so much!! Exactly what I needed! - bpatton 9 years ago
  • 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. - mihenry 8 years ago
    • 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). - chucksteel 8 years ago
      • 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. - mihenry 8 years ago
      • 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)). - chucksteel 8 years ago
  • 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 - jamturtle 7 years ago
    • 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. - chucksteel 7 years ago
  • I added
    and DW.SERVICE_LEVEL_CODE not like 'D'
    and DW.SERVICE_LEVEL_CODE not like 'DL'
    to the WHERE statement, to weed out Dell Digital Delivery entries, since they go for 9 years after the purchase date. (I named them specifically instead of using 'D%' in case there are future service level codes that also start with D.) - ondrar 6 years ago
    • Thanks for posting this!!! Very helpful change to my script that gave me a false sense of security. I thought I was good for years longer. - five. 5 years ago

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