Find detailed information like device ID, smart battery version and more. Lansweeper will automatically retrieve battery information from Windows laptops during a scan. Along with basic information from the device like name and operating system details. This report will also show the device ID and smart battery version. Additional fields can also be added to the report like battery status, the material it is made from, capacity and more. Finding these details can often be a very tedious task but with this report you can get a complete overview of your environment in seconds. Next time a manufacturer issues a battery recall, you won’t need to spend your valuable time finding every single one of them.
Battery Information Query
Select Top 1000000 tblAssets.AssetID,
tblAssets.AssetUnique,
tblAssets.Domain,
tsysOS.OSname,
tblBattery.DeviceID,
tsysOS.Image As icon,
tblBattery.SmartBatteryVersion,
tblBattery.Lastchanged
From tblAssets
Inner Join tblBattery On tblAssets.AssetID = tblBattery.AssetID
Inner Join tblAssetCustom On tblAssets.AssetID = tblAssetCustom.AssetID
Inner Join tsysOS On tblAssets.OScode = tsysOS.OScode
Where tblAssetCustom.State = 1
Order By tblAssets.AssetName
