battery

Provides information about the internal battery of a Macbook.

Platform support

Please be aware that some queries can only be run against certain platforms. Below is a list of the supported platforms that this query supports. Zercurity will automatically pause queries from running if errors are detected. Running a query against an unsupported platform will result in the following error: no such table: battery

  • Mac OSX

Table schema

Name Type Description
manufacturer TEXT The battery manufacturer’s name
manufacture_date INTEGER The date the battery was manufactured UNIX Epoch
model TEXT The battery’s model number
serial_number TEXT The battery’s unique serial number
cycle_count INTEGER The number of charge/discharge cycles
health TEXT One of the following: “Good” describes a well-performing battery, “Fair” describes a functional battery with limited capacity, or “Poor” describes a battery that’s not capable of providing power
condition TEXT One of the following: “Normal” indicates the condition of the battery is within normal tolerances, “Service Needed” indicates that the battery should be checked out by a licensed Mac repair service, “Permanent Failure” indicates the battery needs replacement
state TEXT One of the following: “AC Power” indicates the battery is connected to an external power source, “Battery Power” indicates that the battery is drawing internal power, “Off Line” indicates the battery is off-line or no longer connected
charging INTEGER 1 if the battery is currently being charged by a power source. 0 otherwise
charged INTEGER 1 if the battery is currently completely charged. 0 otherwise
designed_capacity INTEGER The battery’s designed capacity in mAh
max_capacity INTEGER The battery’s actual capacity when it is fully charged in mAh
current_capacity INTEGER The battery’s current charged capacity in mAh
percent_remaining INTEGER The percentage of battery remaining before it is drained
amperage INTEGER The battery’s current amperage in mA
voltage INTEGER The battery’s current voltage in mV
minutes_until_empty INTEGER The number of minutes until the battery is fully depleted. This value is -1 if this time is still being calculated
minutes_to_full_charge INTEGER The number of minutes until the battery is fully charged. This value is -1 if this time is still being calculated

Query examples

Select all the results for the given table.

SELECT * FROM battery;