Tags: Ars Technica, Dan Goodin, David Frink, dell service tag, dell support scam, Lucy Thomson, Peter Sullivan, service tag number, Yosef Kaner This entry was posted on Friday, February 19th, 2016. 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. Once an account is created, go to 'My Products' to enter the list of systems. Click 'Find and Add Products Now '. Enter Service Tags individually, or upload as asset database as a CSV file. View the results in a summarized list (Note: not all entitlements will be listed in this format) 5. 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. Dell has authorized DSR to provide customers with fast, expert repair for Dell owners who need to claim warranty service for their device. If your warranty check reveals you are covered, we recommend that you get your Dell serviced as soon as possible. To get your Dell fixed as fast as possible, visit our location in Hanover, MD and be sure to. Learning has never been so easy!
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
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 Do i need antivirus for my mac.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.zipStep 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
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 Dell Warranty Check Multiple Service Tags OnlineReferences
*SQLLite ODBC DriversDell Warranty Check Multiple Service Tags For Business219 Comments
*SonoraMarek Jan 29, 2009 at 09:10am
Great idea. No more manual checking. Thanks
*JalapenoPaul8413 Feb 12, 2009 at 10:56am
Very nice. Thanks for this!
*JalapenoPaul8413 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
*PimientoInampudi Feb 25, 2009 at 10:08am
Thank you very much!!!
*PoblanoMartin Lillepuu Feb 26, 2009 at 06:59am
works like a charm. lets see how I can extend this.
*PimientoMindy6360 Mar 3, 2009 at 01:12pm
Thank you for sharing - this will save tons of time!!!
*PimientoFilip4923 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?
*PimientoFilip4923 Mar 10, 2009 at 09:09am
Sorry for multiple questions - browser hangs
*SonoraGrahm4164 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.'
*SonoraGrahm4164 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?
'C:downloadDell Scriptserviceservice.vbs(23, 2) ADODB.Recordset: Item cannot be found in the collection corresponding to the requested name or ordinal.'
*SerranoSergio (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…!
*PoblanoGary P Mar 13, 2009 at 06:04pm
Very helpful! Thank you!
*SonoraAllen9262 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
*SonoraPatrick8386 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.
*PoblanoDavid6791 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
*nextDell Laptop Warranty Check
*
*
Receive new systems ready to use out of the box.
PCs are configured and customized in our factory. Prior to shipping your new systems, we can load your image, customize BIOS settings, partition hard drives and install any third party software or hardware. So your systems arrive at your site pre-configured with minimal to no further customization required. In addition we can apply asset tags, box labels and provide asset reports.
Note:For Dell to provide configuration services, we must first ensure your image is exportable in accordance with the U.S. Export law. Learn More
*
*
Configuration Services Key Benefits
*PCs arrive at your site with minimal or no further customization needed
*Ensures consistency as new systems have same version of same software
*Eliminates the need to image and configure PCs at a staging area or desk-side
*Track PCs from our factory to the end-user’s desk without ever opening the boxDell Warranty Check Multiple Service Tags For Iphone
*
*RESOURCESLearn more about Dell EMC Configuration Services
*Configuration Services Datasheet
Reduce deployment time and ensure the consistency of your end-user environment with standard configurations.
*ImageAssist Datasheet
Effortlessly create, deploy, and update cross-platform images faster than ever.
*Asset Tagging and Reporting Datasheet
With our Asset Tagging and Reporting services, we make identifying, tracking, and securing your computers easier.
*Provisioning for VMware Workspace ONE
What used to take hours can now be done in minutes. Get a low touch deployment with instant end-user productivity.
*Provisioning for Windows Autopilot
Accelerate adoption of Windows 10 and Unified Endpoint ManagementDell Warranty Check Multiple Service Tags Online
*From offering expert advice to solving complex problems, we've got you covered.
*
1 Depending upon the type of license provided and policy configuration, unauthorized non-business application may be automatically pushed from the cloud on first boot. These applications may appear as Start Menu tiles and could include such packages as Candy Crush, Solitaire, Bubble Witch, etc.
