1. Dell System Warranty Check
  2. Dell Warranty Check Multiple Service Tags Online

Enter Service Tag or Express Service Code: Help Auto Detect Each search may take up to 30 seconds: Contact Us. Send us an email and we'll get back to. Use the attached script to check multiple Dell Asset tags for warranty (place all asset tags in a file called: “DellServiceTags.txt”): download: wpdmfileid=”5″ When run it uses the service tags from the text file to create a csv file (results.csv). Below is an example off the results.csv file in excel.

Learning has never been so easy!
  • Nov 01, 2008  What this function is doing is sending a request to Dell's REST API with the current computer's Service Tag and the API Key selected. Then, information from the XML response is displayed in the console. This will get you the ship date and the end date of the warranties on that Dell computer. Get-DellAssetInformation -ServiceTag 'ServiceTagNumber'.
  • Use the attached script to check multiple Dell Asset tags for warranty (place all asset tags in a file called: “DellServiceTags.txt”): download: wpdmfileid=”5″ When run it uses the service tags from the text file to create a csv file (results.csv).

I use Dell workstations and servers. I like to be able to track when my warranties and system service dates expire. I'm lazy, so if its not automated then it is worthless to me. I have been using this retrieval method for about a year in other reports and decided to integrate it into my Spiceworks implementation.

11 Steps total

Step 1: Download and install the SQLLite ODBC Drivers

Grab them from here:
http://www.ch-werner.de/sqliteodbc

Dell warranty check multiple service tags for business

If you want to use MSAccess to verify connectivity then you will need to create an ODBC connection. The script does not require this.
- Admin ToolsODBC Connections
- System DSN
- Add, Choose 'SQLLite 3 ODBC Driver'
- Data Source Name = Spiceworks
- Database Name =

Step 2: Download the script

- Create a folder somewhere on your spiceworks server
- Download the script. Since I can't add an attachment to a How-To, get it from my server at home..
. . . . . http://dave.newbern.org/spiceworks/service.zip

- Unzip and save the script to a folder.
- Open a command prompt and CD to the folder.

Step 3: Execute the script

From your command prompt, type service.vbs

If your default command interpreter isn't cscript, it will re-launch itself with cscript anyway. Interactively this is okay but if you use a batch scheduler that used PIDs to monitor the job, you may want to either:
- Change the default script interpreter to cscript. (a good idea when you manage a server that runs automation scripts anyway.)
cscript.exe //h:cscript

- Launch as an argument to cscript.exe
cscript.exe service.vbs

Step 4: Custom Attributes

This script adds a few custom attributes to spiceworks. It may seem that they are not available immediately from within the interface. It may take a network scan before they appear or you may need to restart spiceworks. You can check for there existence by looking here: SettingsAdvancedCustom Attributes.

Even if you don't see them the script should populate them just fine.

Step 5: Add it to the Scheduled Tasks

Control PanelScheduled Tasks
- Right click, New
- Give it a name
- Right-click, Properties
- in the Run box, you need to give the full path to an .exe. so use something like:

c:windowssystem32cscript.exe c:binservicedatesservice.vbs

Enter credentials to run the task and schedule it how ever you want.

Step 6: Notes..

The script essentially queries Spiceworks for Dell branded computers. It then issues a web request based on the service tag (serial_number), captures the html and starts looking for data. It inserts Ship Date into the Spiceworks c_purchase_date and the takes the largest date in the warranty section (in case you extend warranties) and enters it into the Spiceworks c_warranty date.

The documentation is light. The script is fairly basic. The SQLite/ODBC is a little finicky and it doesn't seem to like all data access methods. If you modify then you may have to play a little. Whatever. it works.

Step 7: UPDATE - Sep 4, 2009

Hi everyone.

Robert from Spiceworks was kind enough to go digging through this script and seems to have figured out the problem with the date in the reporting. (Thanks Robert.) If you need to clear your service info to reload it then this script is what you need.

http://dave.newbern.org/spiceworks/cleardates.zip

Step 8: Update - Sept 30 - x64 notes

Some of you have had problems getting this to work on x64 based machines. There are 2 things that you should need to look out for.
- Make sure you get the 64 bit version of the SQLite driver.
- Make sure that the path (in the script) has the correct path. You will need to change 'Program Files' to 'Program Files (x86)'

Step 9: Update - Oct 22

- Changed to regular expression handling to grab dates. It is simply better and provides more accurate results.
- Ignores service tags that aren't 5,6, or 7 digits in length.
- Reorganized the code to make it easier to add in support for other manufacturers.
- - - HP support?. If you want support for this, go vote on this feature Request to get SW to pull the Product Number
- - - http://community.spiceworks.com/feature_request/show/Inventory/352
- Automatically detects the correct internet component.
- Automatically creates the c_warranty and c_warrantytype fields.
- Thanks to a contribution from Hendrik it now grabs the Service type as well as the dates.
- Added a little more error checking in hopes of working around some of the inconsistencies of the Dell support page.
- If the script is called with wscript.exe, it will re-launch with cscript.exe instead.

Step 10: Nov 12 - Working on HP (beta?) - want to test?

We are moving our office/datacenter tomorrow and I had some 'calm before the storm' time to work on this a little. Since I don't have a lot of HP systems in inventory, I could use your help.

** Please keep the testing feedback off of the main thread. It will just clutter it up with crap. Please PM questions/responses. **

Notes:
- Both of these scripts will create a c_product_number field on your SW.

- This is new for me but I had to bounce SW today before I could see product numbers and warranty dates in the web gui. Keep it mind. I should have checked to see if they showed up in a report while they were hidden from the gui. Webserver cache perhaps?

- I have had to switch the HTML component used due to the way the HP website communicates. If you get an error like 'can not create component ServerXMLHTTP' then try installing the MSXML components from Microsoft.

Download files: http://dave.newbern.org/spiceworks/hp_beta.zip

Is fonelab a scam email. To start recording, press a special button.Who wants to test this development in business, go to the full news, there is a link to which you can download the latest version of Fonelab Screen Recorder with the key without paying any money, that is, absolutely free of charge, at the output we get the archive, unpack and install, then use the quack / key, they need to register the program, after it can be used. Admin, founder and proud uploader of KoLomPC. In general, the program is simple to use, does not require much knowledge of computer skills, the interface is pleasant to the eye, looks stylish, there is a compact mode. Hi everyone and have a nice day as you know we have opened the file sharing server so that you can quickly and without delay download the files, unfortunately for financial reasons we have to close it, if you want to continue to use it for downloading files please go to the 'donate' page and support our project, Thank you.FoneLab Screen Recorder 1.0.38 + Patch FullFoneLab Screen RecorderFonelab Screen Recorder is another program to capture a selected area or just a desktop, to record video and save it in the format you need, which is pre-configured. In addition to video, you can capture all audio flowing through the sound card, you can create a screenshot of the desktop, there are advanced settings, and you can set up output formats and file quality.

hp_service.vbs - This is the modified service.vbs file that will check for HP systems. It requires a product number that looks like 000000-000 in order to process it.

hp_helper.vbs - this will query your SW database looking for HP systems. It will try to connect to the system to look up the product number via WMI. You will need to execute this script with an account that has sufficient access (domain admin would be good.) If it finds a product number that looks right it will store it in SW. For me, this seems to work on G5 systems but not earlier. Your mileage may vary.

Currently it only pulls the warranty date (the largest date on the page.) Are all of the warranties formatted like this? (see right.) What would you consider to be a warranty type? Are there key words that I can pick up on here that would indicate? Is 'Base Warranty' it? Are you looking to see everything in Service level? I presume only under the Maintenance support section?

Step 11: Dec 10 - a 64 bit hack

Thanks to Park8751 letting me hack a little bit on his server I was able to get the script to run using the 32 bit ODBC drivers and the 32 bit WOW environment (on your 64 bit server.) I don't know why it works on my 64 bit test system without these changes but if you want to stay 64 bit, try this.

- Install the 32 bit ODBC drivers.
- Make sure you have the (x86) in your database path (in the script)
- Call the script like this:
c:windowssyswow64cscript.exe c:service.vbs
- Cross your fingers.

Please let me know if this gets you success.

Published: Jan 24, 2009 · Last Updated: Mar 28, 2012

References

  • SQLLite ODBC Drivers

219 Comments

  • Sonora
    Marek Jan 29, 2009 at 09:10am

    Great idea. No more manual checking. Thanks

  • Jalapeno
    Paul8413 Feb 12, 2009 at 10:56am

    Very nice. Thanks for this!

  • Jalapeno
    Paul8413 Feb 13, 2009 at 03:19am

    Here's an example SQL report that goes nicely with this, shows all Dell computers with expired warranty.

    SELECT c_warranty as WarrantyExpires, c_purchase_date as Purchased, Model, Device_type, Name, current_user FROM DEVICES
    WHERE manufacturer = 'Dell'
    AND c_warranty < date('now')
    ORDER BY c_warranty

  • Pimiento
    Inampudi Feb 25, 2009 at 10:08am

    Thank you very much!!!

  • Poblano
    Martin Lillepuu Feb 26, 2009 at 06:59am

    works like a charm. lets see how I can extend this.

  • Pimiento
    Mindy6360 Mar 3, 2009 at 01:12pm

    Thank you for sharing - this will save tons of time!!!

  • Pimiento
    Filip4923 Mar 10, 2009 at 09:04am

    I have a problem using this script:

    C:service.vbs(175, 3) msxml3.dll: Access denied.

    Somebody known how to solve it?

  • Pimiento
    Filip4923 Mar 10, 2009 at 09:09am

    Sorry for multiple questions - browser hangs

  • Sonora
    Grahm4164 Mar 10, 2009 at 03:50pm

    I get the following error right after I run the service.vbs command. Does anyone know what I can check?

    'C:downloadDell Scriptserviceservice.vbs(23, 2) ADODB.Recordset: Item cannot be found in the collection corresponding to the requested name or ordinal.'

  • Sonora
    Grahm4164 Mar 10, 2009 at 03:52pm

    I get the following error right after I run the service.vbs command. Does anyone know what I can check?

    With a tap of the right analog stick, drop the puck between your skates, fake out goaltenders with a between-the-legs shot, or puck the puck in the back of the net with a bat-in.Realistic Puck Momentum (R.P.M.) means the puck is dangerous—hard shots can injure defensemen, shake up goalies in the crease, ripple the twine, or knock water bottles off the net to add insult to injury.Feel what it’s like to be on the ice. A player’s speed and size now affects his momentum and turning radius. Nhl pc game download.

    'C:downloadDell Scriptserviceservice.vbs(23, 2) ADODB.Recordset: Item cannot be found in the collection corresponding to the requested name or ordinal.'

  • Serrano
    Sergio (Zenset) Mar 11, 2009 at 03:56pm

    Just great…! You save me over a month of manual work…! Very useful…!

    I just have to change de letter of the disc from C to D on my installation path and works just fine…!

    Thank you so much…!

  • Poblano
    Gary P Mar 13, 2009 at 06:04pm

    Very helpful! Thank you!

  • Sonora
    Allen9262 Mar 17, 2009 at 05:59pm

    I also recieve the error

    'C:binDell Scriptservicedatesservice.vbs(23, 2) ADODB.Recordset: Item cannot be found in the collection corresponding to the requested name or ordinal.'
    Code: 800A0CC1
    Source: ADOCB>Recordset

  • Sonora
    Patrick8386 Mar 20, 2009 at 04:36pm

    Has anyone gotten this to work on a 64-bit system? I think the problem is with SQLite. I don't see it in the ODBC drivers list after I run the SQLite install. If I run the SQLite install on my 32-bit XP laptop, I see SQLite in the drivers tab of the ODBC data sources administrator.

  • Poblano
    David6791 Mar 24, 2009 at 09:36am

    I got the same 'C:downloadDell Scriptserviceservice.vbs(23, 2) ADODB.Recordset: Item'

    With a little investigation turns out i cant spell. in the attributes i had types 'warrenty' as the name rather than 'warranty'.

    the error i believe means it cant find c_warranty which means there is a good chance you have done something similar.

    Works fine for me now. :D

  • prev
  • 1
  • 2
  • 3
  • 4
  • 5
  • ..
  • 15
  • next
  • Solved: Checking multiple service tags - Dell Community

    dell.com

    https://www.dell.com/community/PowerEdge-Hardware-General/Checking-multiple-service-tags/td-p/3854087

    RE: Checking multiple service tags Jump to solution I've been using this and just realized that it considers Dell Digital Delivery a warranty and now all of my warranty dates are in question.

    DA:37PA:69MOZ Rank:91

  • Warranty & Contracts Dell US

    dell.com

    https://www.dell.com/support/home/en-us?app=warranty

    Enter your Service Tag, express service code or EMC product ID to check on your warranty status, additional coverage options such as accidental damage or complete care and learn about your Dell warranty.

    DA:14PA:11MOZ Rank:84

  • Check multiple Dell Asset Tags for warranty – FAQ

    bvanleeuwen.nl

    https://www.bvanleeuwen.nl/faq/?p=10

    Use the attached script to check multiple Dell Asset tags for warranty (place all asset tags in a file called: “DellServiceTags.txt”): download: [wpdm_fileid=”5″] When run it uses the service tags from the text file to create a csv file (results.csv). Below is an example off the results.csv file in excel.

    DA:3PA:93MOZ Rank:39

  • Check DELL warranty from this website for all the service ..

    experts-exchange.com

    https://www.experts-exchange.com/questions/23096728/Check-DELL-warranty-from-this-website-for-all-the-service-tags-in-the-file.html

    Hi, I have about 500 dell servers.Is there a way the script scans the txt file that has the service tags one perline and gets the warranty details from the link below.

    DA:68PA:85MOZ Rank:57

  • dell warranty check multiple service tags Solved ..

    au-e.com

    https://www.au-e.com/search/dell-warranty-check-multiple-service-tags

    Use the attached script to check multiple Dell Asset tags for warranty (place all asset tags in a file called: “DellServiceTags.txt”): download: [wpdm_fileid=”5″] When run it uses the service tags from the text file to create a csv file (results.csv).

    DA:84PA:7MOZ Rank:11

  • Dell Warranty tools issue - Spiceworks

    spiceworks.com

    https://community.spiceworks.com/topic/1594268-dell-warranty-tools-issue

    Due to a merger, I've got a few thousand new dell laptops and desktops to check warranty status on. Does anyone know of a new site or a new tool that will import a list of service tags? So far my searches have come up empty.

    DA:30PA:35MOZ Rank:14

Dell System Warranty Check

  • scripting - Batch Query Dell Service Tags - Server Fault

    serverfault.com

    https://serverfault.com/questions/67735/batch-query-dell-service-tags

    He wants to query Dell's web site to get information about the service tags-- warranty end dates, shipping dates, etc. – Evan Anderson Sep 22 '09 at 16:50 Duh, I'm an idiot! – duffbeer703 Sep 23 '09 at 12:26

    DA:57PA:36MOZ Rank:6

  • Dell Warranty Toolkit download SourceForge.net

    sourceforge.net

    https://sourceforge.net/projects/dellwt/

    Download Dell Warranty Toolkit for free. Dell warranty information. This handy tool determine Dell warranty information from Dell database.It can also import list of service tags from text file and then export to *.csv file.

    DA:53PA:64MOZ Rank:52

  • Get Dell System Warranty with PowerShell - MSEndpointMgr

    msendpointmgr.com

    https://msendpointmgr.com/2013/06/23/get-dell-system-warranty-with-powershell/

    Get warranty information from a text file with service tags. 1. Create a text file and enter the service tags you want to get warranty information for. Enter each service tag on a separate line. I’ve saved the text file as ServiceTags.txt in E:DellWarranty. 2. Open a PowerShell command prompt. 3. Browse to E:DellWarranty. 4.

    DA:31PA:76MOZ Rank:31

Dell Warranty Check Multiple Service Tags Online

  • Warranty lookup tool that works? : sysadmin

    reddit.com

    https://www.reddit.com/r/sysadmin/comments/5xt8zd/warranty_lookup_tool_that_works/

    Filter non Dell Machine (service tag > 7) Query Dell for warranty information for each machine (one by one, but you can get up to 80 with a POST request) Fill a XLSX table with all the informations (Name, servicetag, machine type, warranty type; warranty start, warranty end, last logon and warranty validity. AutoFormat and AutoFit everything

    DA:91PA:49MOZ Rank:99