→ 🚀What's New? Join Us for the Fall Product Launch! Register Now !
‎09-20-2014 12:17 AM
Solved! Go to Solution.
‎02-14-2015 09:03 AM
‎02-17-2015 05:56 PM
‎02-14-2015 09:03 AM
‎02-11-2015 02:09 PM
Lansweeper was unable to read the HP warranty page. If rescanning warranties does not resolve this issue, a proxy server may be blocking access or HP may be pointing to a blank or error page
‎02-02-2015 06:26 PM
Select Top 1000000 tblAssets.AssetID,
tblAssets.AssetName,
tblAssets.Domain,
tblAssets.ServiceVersion,
Case When tblAssetCustom.Model Is Null Or tblAssetCustom.Serialnumber Is Null
Or tblAssetCustom.SystemSKU Is Null Or tblAssetCustom.Model = '' Or
tblAssetCustom.Serialnumber = '' Or
tblAssetCustom.SystemSKU =
'' Then
'Warranty scanning not supported for this asset! Model, serial and SKU are required!' End As Comment,
'http://h20566.www2.hp.com/portal/site/hpsc/template.PAGE/action.process/public/kb/search/?javax.portlet.action=true&javax.portlet.sync=c976365085d9a0536a2e338142a15c01&javax.portlet.tpst=867000c4cf25636cc859bfdeb053ce01&javax.portlet.prp_867000c4cf25636cc859bfdeb053ce01=wsrp-interactionState%3D_serialNumber%253D' + tblAssetCustom.Serialnumber + '%257C_productNumber%253D' + SubString(tblAssetCustom.SystemSKU, CharIndex('#', tblAssetCustom.SystemSKU) - 20, 20) + '%257C_op%253Dserial&javax.portlet.begCacheTok=com.vignette.cachetoken&javax.portlet.endCacheTok=com.vignette.cachetoken&sp4ts.oid=4091412&sp4ts.pn=' + SubString(tblAssetCustom.SystemSKU, CharIndex('#', tblAssetCustom.SystemSKU) - 20, 20) + '&sp4ts.sn=' + tblAssetCustom.Serialnumber As hyperlink_hyp,
'Link to HP warranty page: ' + tblAssetCustom.Serialnumber As
hyperlink_name_hyp,
tblAssetCustom.Manufacturer,
tblAssetCustom.Model,
tblAssetCustom.Serialnumber,
tblAssetCustom.SystemSKU,
tblAssetCustom.PurchaseDate,
tblAssetCustom.Warrantydate,
tblWarranty.LastWarrantyTry,
tblWarranty.LastWarrantySuccess,
Case
When tblWarranty.Error Like '%parsing error%' Then
'Lansweeper was unable to read the HP warranty page. If rescanning warranties does not resolve this issue, a proxy server may be blocking access or HP may be pointing to a blank or error page' End As Error,
tsysAssetTypes.AssetTypeIcon10 As icon
From tblAssets
Left Join tblWarranty On tblAssets.AssetID = tblWarranty.AssetId
Left Join tblAssetCustom On tblAssets.AssetID = tblAssetCustom.AssetID
Inner Join tsysAssetTypes On tsysAssetTypes.AssetType = tblAssets.Assettype
Where (tblAssetCustom.Manufacturer Like '%hewlett-packard%') Or
(tblAssetCustom.Manufacturer Like '%hp%')
Order By tblAssets.Domain,
tblAssets.AssetName
‎02-02-2015 10:16 AM
‎01-22-2015 06:52 AM
‎01-21-2015 01:11 PM
‎01-20-2015 02:53 PM
‎01-12-2015 01:43 PM
Experience Lansweeper with your own data. Sign up now for a 14-day free trial.
Try Now