‎01-05-2018 11:24 AM
‎01-05-2018 04:59 PM
HP has put in place a Bulk Validation and Replacement Order process to assist our customers who have 5 or more potentially affected batteries to validate.
For information please contact the relevant regional Bulk Process team at one of the following email addresses:
I. For North America: NABulkBatteryRecall@hp.com
II. For Latin America: LABulkBatteryRecall@hp.com
III. For Europe, Middle East, and Africa: EMEABulkBatteryRecall@hp.com
IV. For Asia Pacific: APJBulkBatteryRecall@hp.com
‎01-05-2018 02:07 PM
Select Top 1000000 tblAssets.AssetID,
tblAssets.AssetName,
tblAssets.Domain,
tblAssets.Username,
tsysAssetTypes.AssetTypeIcon10 As icon,
tblAssets.IPAddress,
tblAssetCustom.Manufacturer,
tblAssetCustom.Model,
tblAssetCustom.Serialnumber As [Laptop Serial],
tblAssets.Lastseen,
tblAssets.Lasttried,
tblPortableBattery.DeviceID,
tblPortableBattery.Location,
tblPortableBattery.ManufactureDate,
tblPortableBattery.Manufacturer As BatteryManufacturer,
tblPortableBattery.MaxBatteryError,
tblPortableBattery.Name
From tblAssets
Inner Join tblAssetCustom On tblAssets.AssetID = tblAssetCustom.AssetID
Inner Join tsysAssetTypes On tsysAssetTypes.AssetType = tblAssets.Assettype
Inner Join tblPortableBattery
On tblAssets.AssetID = tblPortableBattery.AssetID
Where (tblAssetCustom.Manufacturer Like '%Hewlett-Packard%' Or tblAssetCustom.Manufacturer Like '%HP%') And
(tblPortableBattery.Name Like '%6BZLU%' Or tblPortableBattery.Name Like
'%6CGFK%' Or tblPortableBattery.Name Like '%6CGFQ%' Or
tblPortableBattery.Name Like '%6CZMB%' Or tblPortableBattery.Name Like
'%6DEMA%' Or tblPortableBattery.Name Like '%6DEMH%' Or
tblPortableBattery.Name Like '%6DGAL%' Or tblPortableBattery.Name Like
'%6EBVA%')
Select Top 1000000 tblAssets.AssetID,
tblAssets.AssetName,
tblAssets.Domain,
tblAssets.Username,
tsysAssetTypes.AssetTypeIcon10 As icon,
tblAssets.IPAddress,
tblAssetCustom.Manufacturer,
tblAssetCustom.Model,
tblAssetCustom.Serialnumber As [Laptop Serial],
tblAssets.Lastseen,
tblAssets.Lasttried,
tblPortableBattery.CapacityMultiplier,
tblPortableBattery.Chemistry,
tblPortableBattery.DesignCapacity,
tblPortableBattery.DesignVoltage,
tblPortableBattery.DeviceID,
tblPortableBattery.Location,
tblPortableBattery.ManufactureDate,
tblPortableBattery.Manufacturer As [Battery Manufacturer],
tblPortableBattery.MaxBatteryError,
tblPortableBattery.Name,
tblPortableBattery.SmartBatteryVersion
From tblAssets
Inner Join tblAssetCustom On tblAssets.AssetID = tblAssetCustom.AssetID
Inner Join tsysAssetTypes On tsysAssetTypes.AssetType = tblAssets.Assettype
Inner Join tblPortableBattery
On tblAssets.AssetID = tblPortableBattery.AssetID
Where (tblAssetCustom.Manufacturer Like '%Hewlett-Packard%') Or
(tblAssetCustom.Manufacturer Like '%HP%')
‎01-05-2018 01:43 PM
Experience Lansweeper with your own data. Sign up now for a 14-day free trial.
Try Now