Martin, try to download version 1.6.1 this seems to have solved the problem for me....

Thx Corbett

Thanks for your reply and help. Still no joy though...

15/01/2010 08:47:15*CON:Data Source=Marge\marge_2005;Initial Catalog=LansweeperDB;Integrated Security=True;Connection Timeout=400
15/01/2010 08:47:15*SQL:SELECT TOP 1 Assetlink FROM tsysassetlinks WHERE (Vendor LIKE 'dell%')
15/01/2010 08:47:15*URL:http://support.euro.dell.com/support/topics/topic.aspx/emea/shared/support/my_systems_info/en/details?c=uk&l=en&s=bsd&~tab=1&ServiceTag={assettag}
15/01/2010 08:47:15*SQL:SELECT Computername, IdentifyingNumber FROM dbo.tblComputersystemProduct where vendor like '%dell%' and identifyingnumber <> '' and identifyingnumber is not null order by computername
15/01/2010 08:47:15+Query for: 36CP93J
15/01/2010 08:47:17 -Purchase Date: '28/11/2007'
15/01/2010 08:47:17 -Warranty Date: '28/11/2010'
15/01/2010 08:47:17*SQL:begin tran;update dbo.tblCompCustom with (serializable) set PurchaseDate=CONVERT(DATETIME,'28/11/2007',102), Warrantydate=CONVERT(DATETIME,'28/11/2010',102) where computername = '36CP93J';if @@rowcount = 0 begin insert into dbo.tblCompCustom (Computername, PurchaseDate, Warrantydate) values ('36CP93J',CONVERT(DATETIME,'28/11/2007',102),CONVERT(DATETIME,'28/11/2010',102)) end;commit tran;
System.Data.SqlClient.SqlException: The conversion of a char data type to a datetime datatype resulted in an out-of-range datetime value.
The statement has been terminated.

Thanks anyway,
Martin

Thanks for letting me know that it isn't quite right. I completely rewrote the date handling to hopefully work with different date formats better. Can you please try out this version and let me know?

Thanks.

Hi

This works so well, thank you for all of the effort!

Would you be able to do the same for IBM/Lenovo and HP?

I have sample data etc for you if you need data to test with.

we have roughly 140 HP's if you want a tester?

Sure, i used this for Dell Workstations:



and this one for the servers:




The report shows you all devices that have no longer Dell Support.

Sorry, I never received any links to an HP system's warranty information. With this new information it sounds like it's going to be quite difficult to get the warranty information automatically from their web site.

I found the HP part number in the BIOS under the heading SKU Number. I also found this script below to pull it through WMI, however, when I look at the SKU Number in WMI CIM Studio its blank. The script pulls back a blank SKU number also. Maybe, it will make sense to someone and they can figure it out. Thanks,

Set objWMIService = GetObject("winmgmts:" & "{impersonationLevel=impersonate}!\\" & strComputer & "\root\cimv2")
Set colItems = objWMIService.ExecQuery("Select * from Win32_ComputerSystemProduct",,48)
For Each objItem in colItems
Wscript.Echo "Caption: " & objItem.Caption
Wscript.Echo "Description: " & objItem.Description
Wscript.Echo "IdentifyingNumber: " & objItem.IdentifyingNumber
Wscript.Echo "Name: " & objItem.Name
Wscript.Echo "SKUNumber: " & objItem.SKUNumber
Wscript.Echo "UUID: " & objItem.UUID
Wscript.Echo "Vendor: " & objItem.Vendor
Wscript.Echo "Version: " & objItem.Version
Next