- Dell Warranty Check Multiple Service Tags Phone Number
- Dell System Warranty Check
- Dell Warranty Check Multiple Service Tags Near Me
- Dell Warranty Check Multiple Service Tags 2017
- Dell Support Service Tag
- Dell Server Warranty Check
Sep 12, 2016 PowerShell Script - Get Dell Warranty Status Use PowerShell to get Dell warranty information directly from Dell through their Dell Warranty Status API. This information can be used to feed an AssetManagement system, ticketing system or any other CMDB. Check warranty status for multiple products Manually enter up to twenty serial numbers below and choose ‘Submit’. There are one or more errors in the fields below. Please correct the information in the following rows.
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
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 =
- 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
- 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.
- 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
- 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
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:
- 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...
Dell Warranty Check Multiple Service Tags Phone Number
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
Dell System Warranty Check
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
Dell Warranty Check Multiple Service Tags Near Me
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)'
- 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.
- 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.
- 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.
- 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
- SonoraMarek Jan 29, 2009 at 09:10amGreat idea. No more manual checking. Thanks
- JalapenoPaul8413 Feb 12, 2009 at 10:56amVery nice. Thanks for this!
- JalapenoPaul8413 Feb 13, 2009 at 03:19amHere'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:08amThank you very much!!!
- PoblanoMartin Lillepuu Feb 26, 2009 at 06:59amworks like a charm. lets see how I can extend this.
- PimientoMindy6360 Mar 3, 2009 at 01:12pmThank you for sharing - this will save tons of time!!!
- PimientoFilip4923 Mar 10, 2009 at 09:04amI 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:09amSorry for multiple questions - browser hangs
- SonoraGrahm4164 Mar 10, 2009 at 03:50pmI 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:52pmI 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:56pmJust 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:04pmVery helpful! Thank you!
- SonoraAllen9262 Mar 17, 2009 at 05:59pmI 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:36pmHas 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:36amI 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
Dell Warranty Check Multiple Service Tags 2017
- Solved: Checking multiple service tags - Dell Community
dell.com
https://www.dell.com/community/PowerEdge-Hardware-General/Checking-multiple-service-tags/td-p/3854087RE: 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=warrantyEnter 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=10Use 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.htmlHi, 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-tagsUse 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-issueDue 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 Support Service Tag
- scripting - Batch Query Dell Service Tags - Server Fault
serverfault.com
https://serverfault.com/questions/67735/batch-query-dell-service-tagsHe 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:26DA: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 Server Warranty Check
- 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 everythingDA:91PA:49MOZ Rank:99