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;