/build/static/layout/Breadcrumb_cap_w.png

Kace Inventory of Lenovo Warranty Info

I'm not sure if anyone else has found a better solution for this. I thought I would share just in case. If anyone has a shorter way please let me know. 

We're about to open a new building and I've recently been tasked with getting warranty info on our machines. Unfortunately we do not have all Dells so this was a little challenging. I started by running a simple query to find all of my Lenovos.

SELECT CS_MODEL, BIOS_SERIAL_NUMBER
FROM MACHINE M
WHERE CS_MANUFACTURER = 'LENOVO'

I exported the results of this query to a csv. I then went to Lenovos warranty site and uploaded the csv under the batch query section. 

http://support.lenovo.com/en_US/product-service/warranty-status/default.page?

Clicking the link will give you an option to download a template. Copy and paste your csv from the above query to fill in the required fields. Once this is down upload the new csv. This will return yet another csv "warranty information.csv". I formatted the "WarrantyEndDate" field to yyyy-mm-dd before saving it (used for reporting). I did have problems uploading all my machines at the same time. I had to break it up in groups of 3,500(Google Chrome 23.0.1271.97).


 

I added a field "Warranty End Date" to the existing computer type in assets. I then took this warranty information.csv and imported it into assets. After the import I am now able to run queries to find out which machines will be expiring in the next month. 

 

***Note this query will be unique to your Kbox***

SELECT DISTINCT M.NAME AS 'Machine Name',BIOS_SERIAL_NUMBER AS 'Serial Number', A5.FIELD_56 AS 'Warranty End Date'
FROM MACHINE M
LEFT JOIN ASSET A ON A.MAPPED_ID = M.ID AND A.ASSET_TYPE_ID=5
LEFT JOIN ASSET_DATA_5 A5 ON A5.ID = A.ASSET_DATA_ID
WHERE CS_MANUFACTURER = 'lenovo' AND (A5.FIELD_56 > DATE_ADD(NOW(),INTERVAL 1 DAY))
AND (A5.FIELD_56 < DATE_ADD(NOW(),INTERVAL 1 MONTH))
ORDER BY A5.FIELD_56

 

Since machines come with at least a year warranty this should on need to be done every six months or so. Hope this helps.


Comments

  • Great writeup! HP has a similar site: https://h20565.www2.hp.com/portal/site/hpsc/public/wc/home/ howver it's not CSV frienly unfortunately. I'm working on a script that would query the website[s] for HP, Lenovo, etc.and write the info to the Registry, that way I can use a custom inventory rule to get it into the K1 database. If anyone else has already written such a thing or is working on it please reach out to me. cblake at kace.com - cblake 9 years ago
    • Thanks. I started looking at this thread yesterday http://social.technet.microsoft.com/Forums/en/configmgrreporting/thread/dc04ef29-0d93-4c7e-92c1-0093dd247b03 I tried modifying it for the Kace DB. Looks like it will provide a link in a report, but I'm not sure if there's a way to pull the actual date. My SQL skills are not that great.

      This new building we are opening could possibly be using HPs. I have about seven months to figure it out if so. - dugullett 9 years ago
  • UPDATE: When running this query again to update your list you can run something like this to only get the machines that do not have a current warranty date. This way you can just upload the ones that are missing instead of your whole list again. Also keep in mind that the A5.FIELD_56 is unique to my Kbox. Yours should be different.

    SELECT CS_MODEL, BIOS_SERIAL_NUMBER
    FROM MACHINE M
    LEFT JOIN ASSET A ON A.MAPPED_ID = M.ID AND A.ASSET_TYPE_ID=5
    LEFT JOIN ASSET_DATA_5 A5 ON A5.ID = A.ASSET_DATA_ID
    WHERE CS_MANUFACTURER = 'LENOVO'
    AND A5.FIELD_56 IS NULL - dugullett 9 years ago
This post is locked
 
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