Batch Query Dell Service Tags

Question

Anyone know of a way to get a bunch of information for a list of service tags, does Dell have a section on their site for this? I would also be open to any Perl / Python libraries or *nix shell scripts.

Right now I mostly want some sort of date for each tag.

Answer 1

Download the following URL (replacing SVCTAG at the end with the actual service tag) for each tag:

http://support.dell.com/support/topics/global.aspx/support/my_systems_info/details?c=us&l=en&s=gen&ServiceTag=SVCTAG

Parsing the resulting page for the info you're interested in is left as an exercise for the reader :-)

Answer 2

Add your system in the dell support site, in the section "my Systems". You can handle up to 100 systems.

You have to have an account to Dell site of course.

Unfortunately I don't know about a batch system to do the job, even if you can of course use curl, snoopy or whatever you are familiar with in order to automatically do the login, retrieve the list and parse the results.

Answer 3

Service Tag is generally analogous with serial number.

The WMI Win32_BaseBoard.SerialNumber class contains this information. Google "wmi serial number" and you'll find several example solutions for getting this data. We use a script at build time to name the box using serial number and other prepended characters as our workstation hostnames, which makes troubleshooting much easier with large numbers of clients.

Answer 4

#!/usr/bin/python

# dell_warranty.py v0.1
# Written by Frode Egeland <egeland[at]gmail.com> - Copyright 2009
# Released under the terms of the GNU GPL v3 - see http://www.gnu.org/licenses/gpl-3.0.html
#
# Version History
# 0.1 - 2009-10-12 - Frode Egeland - Initial version. Tested with a simple csv list of service tags only.
# 

import urllib2, csv, re
from BeautifulSoup import BeautifulSoup

url="http://support.dell.com/support/topics/global.aspx/support/my_systems_info/details?c=us&l=en&s=gen&ServiceTag=%s"

stlist = []

# generate a list of servicetags from a csv
csvfile = csv.reader(open('taglist.csv'))

for line in csvfile:
 for entry in line:
  stlist.append(entry)

fixdate = re.compile("(\d{1,2})\/(\d{1,2})\/(\d{4})")

print "Service Tag, Warranty Type, Provider, Start Date, End Date, Days Remaining"

for currtag in stlist:
 page = urllib2.urlopen(url % (currtag,))

 for line in page.readlines():
  if "Parts only Warranty" in line:
   soup = BeautifulSoup(line)
   break
 table = soup.find('table',{'class':"contract_table"})
 rows = table.findAll('tr')
 rows = rows[1:]
 for row in rows:
  output = "%s" % (currtag,)
  cells = row.findAll('td')
  for cell in cells:
   if cell.a: # link / formatted text
    txt = cell.a.string
   elif cell.b: # bold text
    txt = cell.b.string
   elif cell.i: # italic
    txt = cell.i.string
   else: #normal text
    txt = cell.string
   match = fixdate.search(txt)
   if match:
    txt = "%d-%d-%d" % (int(match.group(3)),int(match.group(1)),int(match.group(2)))
   output = "%s,%s" % (output,txt)
  output = output.strip()
  print output

Answer 5

I know this is quite an old thread (I only found it because it was linked from a newer one) , but maybe you can use this nagios plugin: nagios exchange

python check_dell_warranty.py
OK: Service Tag: tag Warranty: Next Business Day, Provider: DELL, Start: 2010-02-24, End: 2013-02-25, Days left: 860 Warranty: NBD ProSupport For IT On-Site, Provider: DELL, Start: 2010-02-24, End: 2013-02-25, Days left: 860

The script queries standard localhost, trying dmidecode. You can also run it against a remote host using SNMP or you could run it from NRPE. Quite handy.

Answer 6

Dell now have an option to save your service tags. You need to create a login with them and that is all. It also shows which servers warranties are expiring and you can export from it.

Answer 7

dmidecode -s system-serial-number

will return the service tag

you can use ssh to remotely run it on all your systems in a batch. assuming they are all running Linux of course

Answer 8

Just open microsoft word, go to tools or insert macro, type a new name and create macro.

paste the script in it. save macro and save word file.

now create the text file as instructed with service tags beginning each line.

go back to word, open the macro you saved and click the play/run button.

your MS word should freeze for a while then you see the success prompt.

the results.csv file should have been created on the folder. It worked for me. Thanks (82 service tags in 45 seconds!)