Fleet logo
Menu An icon indicating that interacting with this button will open the navigation menu.
Fleet logo An 'X' icon indicating that this can be interacted with to close the navigation menu.
Device management + MDM Orchestration + monitoring Software management + CVEs, usage, app library Integrations
Get started Guides Vitals Queries Policies Software Data tables API SUPPORT Chat Contribute Release notes "Why is Fleet on my computer?" Get your license
Stories
What people are saying News Ask around Take a tour Meetups COMPANY Origins   (Fleet & osquery) The handbook Logos/artwork Why open source?
Pricing Try it yourself
All platforms
Windows
Linux
macOS
ChromeOS
search

A menu icon Tables {{numberOfTablesDisplayed}}

right chevron down chevron

Tables{{numberOfTablesDisplayed}}

macOS logo Windows logo Linux logo macOS logo

battery

Provides information about the internal battery of a laptop. Note: On Windows, columns with Ah or mAh units assume that the battery is 12V.

Column Type Description
amperage integer The current amperage in/out of the battery in mA (positive means charging, negative means discharging)
charged integer 1 if the battery is currently completely charged. 0 otherwise
charging integer 1 if the battery is currently being charged by a power source. 0 otherwise
chemistry text The battery chemistry type (eg. LiP). Some possible values are documented in https://learn.microsoft.com/en-us/windows/win32/power/battery-information-str.
Not returned in SELECT * FROM battery.
Only available on Windows
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
Only available on macOS
current_capacity integer The battery's current capacity (level of charge) in mAh
cycle_count integer The number of charge/discharge cycles
designed_capacity integer The battery's designed capacity in mAh
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
Only available on macOS
manufacture_date integer The date the battery was manufactured UNIX Epoch
Only available on macOS
manufacturer text The battery manufacturer's name
max_capacity integer The battery's actual capacity when it is fully charged in mAh
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. On Windows this is calculated from the charge rate and capacity and may not agree with the number reported in "Power & Battery"
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
model text The battery's model number
percent_remaining integer The percentage of battery remaining before it is drained
serial_number text The battery's serial number
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
voltage integer The battery's current voltage in mV

Example

This table contains a lot of information about the health of batteries. This query shows how many cycles the battery of a device was used for, allowing you to identify users who put more wear on it and might need more frequent replacements.

SELECT cycle_count FROM battery;
Edit page

Need more help?

Slack logo Ask the community on Slack