UPDATE (2010-05-23) – Frank van der Horst added some nice “eye candy” to this script. For each Service Tag in Computers.txt, the script will display a small Internet Explorer window with a progress bar. Thanks, Frank!

Do you or your company use Dell laptops, desktop and server computers? If asked, could you provide the current warranty information for those computers in a report? Sherry Kissinger at MyITForum.com posted a way for SMS (Microsoft System Management Server) administrators to get Dell warranty information from individual computers.

We modified the script to accept a text file (Computers.txt) of Dell Service Tag numbers (one per line) as input, then output the warranty information for each Service Tag to an Excel spreadsheet. It’s a quick way to provide this warranty information on demand.

The script works by looping through however many Service Tag numbers are in Computers.txt, using VBScript’s Msxml2.XMLHTTP object to request the information from Dell’s website, then “screen-scraping” the information for that Service Tag and populating the Excel spreadsheet with that information.

Here’s the script. Change the file extension from .txt to .vbs in order to run it. This script requires that Excel 2007 be installed. Create Computers.txt in the same folder as the VBScript file. When you run the script, the Excel spreadsheet will be created in the same location as the script.

Do you find this script useful? How can it be improved? Let us know in your comment.