Link to home
Start Free TrialLog in
Avatar of bsharath
bsharathFlag for India

asked on

Check DELL warranty from this website for all the service tags in the file.

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.

http://supportapj.dell.com/support/topics/topic.aspx/ap/shared/support/my_systems_info/en/details?c=in&cs=inbsd1&l=en&s=bsd


The results to a csv file.

I know there must be a way .....
Regards
Sharath
Avatar of Éric Moreau
Éric Moreau
Flag of Canada image

You better contact Dell directly. Send them a Excel file of your service tag and they should be able to send you the information you need.
ASKER CERTIFIED SOLUTION
Avatar of RobSampson
RobSampson
Flag of Australia image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of bsharath

ASKER

Yes i know but if a script can do this that would be great.
Every month we upgrade some servers/desktops and need to cross check if they have been updated on the server.
Rob thanks for this...I just tried with 500+ service tags and it got me the results in 3 min.
You dont know how much you have helped me with this...You are great.... :-)
I really appritiate your help .Thanks a lot....

I have attached the xls file which needs a little help on the headers for the other data....
Results.xls
Rob is the same thing possible on a HP website as well?
That XLS file looks fine.  Just copy the five field headings
Description      Provider      Start Date      End Date      Days Left

for as many columns you take up.  The same five rows are repeated.

I'm not sure about the HP website.  What is the URL to check that?

Regards,

Rob.
Thanks Rob...I really dont know how to thank you...
Avatar of CCSDUSS
CCSDUSS

What kind of script is it and how do I use it?
Rob,

would it be possible please to tell me how can I create the script you wrote for Dell warranty,
I would really appreciate it.
Thank you.
This VBScript still works like a champ!  Took like 5 seconds to query warranty info on 50 servers!

How to use -> Copy the script to notepad and save w/ *.vbs extension.  Save your service tags into a Notepad file named DellServiceTags.txt, one per line (save this file to same folder/location as vbscript).  Open DOS window, browse to where you saved the files and simply type name of script (i.e. dellquery.vbs) and hit enter.  You'll get a pop-up in a few seconds along with a *.csv file with the results!  Thanks a million!
Hi Rob,
Thanks a lot for writing this script! Its works great! I was wondering if there's a way to add conversion from Hostname (or IP) to Service Tag and then query those service tags for warranty info?


Unbelievable......absolutely unbelievable!  You do not know how much time this will save us!  I cannot believe how fast it is................works like a charm!

Now if I can only incorporate this into my CRM solution where it would queery our CRM SQL database field for the serial # and auto fill in the warranty expiration field to boot............now that would be as good as winning the lottery the first time trying!
Does anyone know if this is still valid? i tried it today and received the following error:

line: 18
char: 7
error: access denied

code: 80070005
source: msxml3.dll

I've tried it on a couple machines with the same error. Any ideas?
Having the same problem.........................

Have over 500 machines to get information on!!!!!!!!!

Thanks