bsharath
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
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
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
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
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.
Every month we upgrade some servers/desktops and need to cross check if they have been updated on the server.
ASKER
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
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
ASKER
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.
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.
ASKER
Thanks Rob...I really dont know how to thank you...
ASKER
Here is the new post for HP Rob...
https://www.experts-exchange.com/questions/23097377/Script-to-check-the-warranty-of-servicetags-from-the-HP-website.html
https://www.experts-exchange.com/questions/23097377/Script-to-check-the-warranty-of-servicetags-from-the-HP-website.html
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.
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!
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?
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......absolute ly 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!
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?
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
Have over 500 machines to get information on!!!!!!!!!
Thanks