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.
Multi platform
Device management   (+ MDM) Orchestration   (+ monitoring) Software management   (+ CVEs) Integrations

Docs
Pricing
More
News Case studies Ask around Meetups Share your story The handbook Get your license Schedule a demo
Schedule a demo
Multi platform
Device management + MDM Orchestration + monitoring Software management + CVEs, usage, app library Integrations
Docs Pricing
More
News Case studies Ask around Meetups Share your story
The handbook Get your license Schedule a demo
Try it yourself

Tables

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

macOS Apple

Linux Linux

Windows Windows

Chrome ChromeOS

{{table.title}} evented table

keychain_items

click to open the table of contents
macOS logo

keychain​_items

Generic details about keychain items. NOTE: osquery limits frequent access to keychain files. This limit is controlled by keychain_access_interval flag.

Column Type Description
account text Optional item account
comment text Optional keychain comment
created text Date item was created
description text Optional item description
label text Generic item name
modified text Date of last modification
path text Path to keychain containing item
pk_hash text Hash of associated public key (SHA1 of subjectPublicKey, see RFC 8520 4.2.1.2)
type text Keychain item type (class)

Example

Identify Macs that contain certificates related to Apple application signing and notarization. (replace with your Apple Developer ID string)

SELECT * FROM keychain_items WHERE label LIKE '%8EHZ83LZNU%';

Notes

  • This table should be used sparingly as it uses an Apple API which occasionally corrupts the underlying certificate.
Edit page

Questions?

Ask us anything
{{table.title}} evented table
Fleet logo
Multi platform Device management Orchestration Software management Integrations Pricing
Documentation Support Docs API Release notes Get your license
Company About News Jobs Logos/artwork Why open source?
ISO 27001 coming soon a small checkmarkSOC2 Type 2 Creative Commons Licence CC BY-SA 4.0
© 2025 Fleet Inc. Privacy
Slack logo GitHub logo LinkedIn logo X (Twitter) logo Youtube logo Mastadon logo
Tried Fleet yet?

Get started with Fleet

Start
continue
×