I'm assuming you could use the MaxBatteryError or another field in tblPortableBattery to report on bad batteries. I've included a sample report below listing tblPortableBattery data, which you can add to your installation by following
these instructions.
Select Top 1000000 tsysOS.Image As icon,
tblAssets.AssetID,
tblAssets.AssetName,
tblAssets.Domain,
tblAssets.Username,
tblAssets.Userdomain,
tblAssets.IPAddress,
tblAssets.Firstseen,
tblAssets.Lastseen,
tblAssets.Lasttried,
tblPortableBattery.Name As Battery,
tblPortableBattery.Manufacturer,
tblPortableBattery.ManufactureDate,
tblPortableBattery.CapacityMultiplier,
tblPortableBattery.Chemistry,
tblPortableBattery.DesignCapacity,
tblPortableBattery.DesignVoltage,
tblPortableBattery.MaxBatteryError,
tblPortableBattery.SmartBatteryVersion,
tblPortableBattery.Lastchanged
From tblAssets
Inner Join tblAssetCustom On tblAssets.AssetID = tblAssetCustom.AssetID
Inner Join tblPortableBattery
On tblAssets.AssetID = tblPortableBattery.AssetID
Inner Join tsysOS On tsysOS.OScode = tblAssets.OScode
Where tblAssetCustom.State = 1
Order By tblAssets.Domain,
tblAssets.AssetName