It depends a bit on what information is stored in WMI (and thus scanned) regarding the battery. We don't have any HP laptops in-house so we cannot verify this unfortunately. Testing with Dell laptops we can find some information that seems to match battery serial information in the tblPortableBattery.Name field.
According to the article you've linked batteries containing 6BZLU, 6CGFK, 6CGFQ, 6CZMB, 6DEMA, 6DEMH, 6DGAL or 6EBVA in their serial are eligible for recall.
I've added a report below that will list information about your HP laptops if their battery name matches one of the values above. I can't guarantee whether this is going to yield results though. I've also added a second report which will just list all the battery information that has been scanned for your HP laptops, should the first report not work you may find another field that may be used in the output of the second report.
Please let me know whether any useful information can be retrieved.
HP laptops attempting to filter on battery name: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%')
HP laptops and all their battery information: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%')