Queries/

Get laptops with failing batteries

Zach Wasserman

Lists all laptops with under-performing or failing batteries.

To learn more about queries, check this guide.

Query PowerShellNEW BashNEW

SELECT * FROM battery WHERE health != 'Good' AND condition NOT IN ('', 'Normal');

h=$(system_profiler SPPowerDataType | awk -F": " '/Battery Health/{print $2; exit}'); c=$(system_profiler SPPowerDataType | awk -F": " '/Condition:/{print $2; exit}'); if [[ "$h" != "Good" && -n "$c" && "$c" != "Normal" ]]; then echo "Battery Health,Condition"; echo "$h,$c"; fi