Update LS database with warranty information from Dell's site

[Corbett]

FYI: Lansweeper 5.0 which is currently in beta will have this feature build-in for Dell, HP, Lenovo

This isn't exactly a "custom action" but this topic seems the best. I wrote an application that when executed it will update the Purchase Date and Warranty Date custom fields of all Dell computers in the LS database. It accomplishes this by making an HTTP request to Dell's support site and pulling down the appropriate dates. Some assumptions are made here: The oldest date found on the support page is the purchase date and the most recent date found on the page is the warranty expiration date.

EDIT (3/21/2012): Dell changed their support site which broke the program. The program now uses the web service that Dell provides for getting warranty information. Due to this change a new line needs to be added to the .config file:

<add key="DellWarrantyURL" value="http://xserv.dell.com/services/assetservice.asmx"/>

This is a .NET application and therefore requires Framework 3.5.

Before running the program be sure to edit the .config file and set the connectionString option with the appropriate SQL Server computer name, database name, username and password.

In my situation I used the Task Scheduler to run this application once a week (UpdateDellWarrantyInfo -all) to make sure all computers have the most recent warranty information and once a day
(UpdateDellWarrantyInfo -warrantyInfo) to get the warranty information for new computers.

12/21/2009, 4:15PM ET - Added most recent version of utility.
12/24/2009, 10:50AM ET - Attached most recent version (v1.4) of utility and updated the documentation.
01/04/2010, 1:30PM ET - Fixed bug where invalid Asset Tags (AAAAAA5 for example) would throw an exception. It now just skips it and keeps going. Attached v1.5.
01/13/2010, 10:07AM ET - Added a proxy authentication mechanism (integrated authentication only), fixed a SQL statement that failed on SQL 2000, added -verbose option for troubleshooting (rewrote argument handling routines), added stack trace to error output for additional troubleshooting. Attached v1.6.
01/18/2010, 8:16AM ET - Rewrote date handling routine to better handle different date formats. Attached v1.7.
07/02/2010, 12:16PM ET - I haven't had much time to maintain this lately. Attached v1.7 of the source.
03/21/2012, 8:26AM ET - Rewrote the warranty fetch routine to use the Dell web service. Note this version now requires a DellWarrantyURL key in the .config file. Attached v2.0.

Usage: UpdateDellWarrantyInfo [options] [-verbose]

Options

-all
Will update the warranty information for all Dell computers in the Lansweeper
database.

-warrantyInfo
Will update the warranty information only for the Dell computers that have
empty warranty and purchase dates in the Lansweeper database.

-assetTag <assetTag>
Will update the warranty information for a single Dell computer based on the
asset tag.  Must provide a single asset tag.

-computer <computerName>
Will update the warranty information for a single Dell computer based on the
computer name.  Must provide a single computer name.

-verbose
Print troubleshooting information to the console.

-help
Will display this screen.

NOTE: If no options are provided, will update all Dell computers.

[meaglin]

How would you set the connection string when using LS with a local DB file instead of a SQL server?

[Hemoco]

meaglin wrote:
How would you set the connection string when using LS with a local DB file instead of a SQL server?

Lansweeper 5.1 automatically scans Dell warranty info (if you own a Lansweeper license). Update by following the instructions on page 176 and beyond of our online documentation, if you haven't already: http://www.lansweeper.com/documentation.pdf
You can refresh warranty information by hitting the Rescan All Asset Warranties Now button in the Lansweeper web console under Configuration/Scanning Setup/Server Options.

[carl_stern]

What would I use as user and pass in the config file if I normally log in using integrated authentication?

Thanks!

[sk0tto]

It looks like you're missing the Lenovo asset link in the database.

Run the LS config tool and go to the "Vendor Support Links" page. Create a new record with Lenovo as the vendor and the following (minus the quotes) for the AssetLink:

"http://support.lenovo.com/templatedata/Web Content/JSP/warrantyLookup.jsp?sysMachType={model}&sysSerial={assettag}"

Try running again once you have done this.

[mac]

when i run the exe i got this error.


No Lenovo asset link found
8/14/2012 9:19:20 AM+Query for: 27
System.UriFormatException: Invalid URI: The URI is empty.
at System.Uri.CreateThis(String uri, Boolean dontEscape, UriKind uriKind)
at System.Uri..ctor(String uriString)
at System.Net.WebRequest.Create(String requestUriString)
at UpdateLenovoWarrantyInfo.warrantyInfo..ctor(String URL, String ServiceTag
String Model)
at System.Uri.CreateThis(String uri, Boolean dontEscape, UriKind uriKind)
at System.Uri..ctor(String uriString)
at System.Net.WebRequest.Create(String requestUriString)
at UpdateLenovoWarrantyInfo.warrantyInfo..ctor(String URL, String ServiceTag
String Model)
System.ArgumentNullException: Value cannot be null.
Parameter name: input
at System.Text.RegularExpressions.Regex.Matches(String input)
at UpdateLenovoWarrantyInfo.warrantyInfo..ctor(String URL, String ServiceTag
String Model)
at UpdateLenovoWarrantyInfo.Program.Main(String[] args)
at System.Text.RegularExpressions.Regex.Matches(String input)
at UpdateLenovoWarrantyInfo.warrantyInfo..ctor(String URL, String ServiceTag
String Model)
at UpdateLenovoWarrantyInfo.Program.Main(String[] args)


and it stops

[sk0tto]

It seems a little sluggish on my end today too. Try it again in a few hours and let me know if it's still not working.

It was working great for me last night. It's still working now, but it looks to be timing out once in a while..

[rgross]

It appears HP has changed their warranty look up page. Has anyone been able to get this to work for HP's?

Here's the link for the new warranty look up
http://h20566.www2.hp.com/portal/site/hpsc/public/wc/home/

[sk0tto]

Not sure if anybody still needs this or not, but I managed to alter the original source code to work with Lenovo warranty lookups. The Zip file is attached. Run it the same way you would run the Dell lookup utility.

A BIG thanks goes out to Corbett who wrote and provided the code for the Dell warranty lookup!

[mac]

sk0tto wrote:
Not sure if anybody still needs this or not, but I managed to alter the original source code to work with Lenovo warranty lookups. The Zip file is attached. Run it the same way you would run the Dell lookup utility.

A BIG thanks goes out to Corbett who wrote and provided the code for the Dell warranty lookup!

Hi this doesn't work to me.

it seems is not able to connect to lenovo site