KACE Product Support : Report Help

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:

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

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 8 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 8 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 7 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. 6 years ago

Answer this question

Posted by:

View more:

KACE Product Support Questions

question