Tables

Fleet uses osquery tables to query operating system, hardware, and software data. Each table provides specific data for analysis and filtering.

Apple

Linux

Windows

ChromeOS

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.