Solutions
Device management
Remotely manage, and protect laptops and mobile devices.
Orchestration
Automate tasks across devices, from app installs to scripts.
Software management
Inventory, patch, and manage installed software.
Extend Fleet
Integrate your favorite tools with Fleet.
Customers
Stripe + Fleet
Stripe consolidates multiple tools with Fleet.
Foursquare + Fleet
Foursquare quickly migrates to Fleet for device management.
What people are saying
Stories from the Fleet community.
More
Fleet uses osquery tables to query operating system, hardware, and software data. Each table provides specific data for analysis and filtering.
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 Not returned in SELECT * FROM battery .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 Not returned in SELECT * FROM battery .Only available on macOS |
manufacture_date | integer | The date the battery was manufactured UNIX Epoch Not returned in SELECT * FROM battery .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 |
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;