fblesno.blogg.se - Dell warranty look up

This code is available for anyone to use, although you will need to apply for your own Dell API key on Dell TechDirect: If you want to mirror my setup then create the custom fields like this: It assumes that you have already created the custom fields with date/time data types.

The script imports the Dell warranty data from the newly created CSV file and imports it into PDQ Inventory as custom fields.

Some of my devices had a 1-year initial entitlement and a 3-year extended entitlement so I just wanted to know when all of its warranties would be expired. Because a computer can have several entitlements it just grabs the maximum of all the dates returned. Right now the data grabbed is "Ship Date" and the device's entitlement (warranty) end dates.

The script iterates through each service tag in the CSV file, performs a Dell API lookup to grab its warranty data, and saves that data into an output CSV file.

I have the filters on the report set to this:

If you do an auto report make sure to NOT include the date in the file path and make sure to overwrite old files. I have this on an auto-report which saves the CSV file to a UNC path on a network share every night at 6:00 PM. It must have the Computer Name and Computer Serial Number fields, but it can contain additional fields as well if you want.

The script looks at a CSV file containing every Dell computer in your PDQ Inventory.

I couldn't find a great solution so I decided to automate importing some data into PDQ to make this work. One of my coworkers was tasked with pulling reports of old computers that need to be replaced which sent me down a rabbit hole of trying to automatically determine that based on data in PDQ Inventory.