Tables in FleetDM

The fleetdm plugin includes 15 tables:

Name	Description	Queries
fleetdm_activity	Audit log activities in FleetDM.	6
fleetdm_app_store_app	Apple App Store apps (VPP) from FleetDM. Lists apps available for install on teams. The API requires a team_id, so the plugin auto-discovers all teams and queries each one. Uses the /software/app_store_apps endpoint.	5
fleetdm_carve	Information about file carving sessions in FleetDM.	3
fleetdm_fleet_maintained_app	Fleet-maintained apps available in FleetDM. These are pre-packaged software installers maintained by Fleet. Uses the /software/fleet_maintained_apps endpoint.	4
fleetdm_host	Information about hosts managed by FleetDM.	7
fleetdm_host_detail	Provides fully detailed information for each host by fetching details individually.	4
fleetdm_label	Labels used for grouping hosts in FleetDM.	5
fleetdm_os_version	Operating system versions from FleetDM. Lists all OS versions across managed hosts with vulnerability information. Uses the /os_versions endpoint.	5
fleetdm_pack	Query packs in FleetDM.	4
fleetdm_policy	Information about policies in FleetDM.	6
fleetdm_query	Saved queries in FleetDM.	5
fleetdm_software_title	Software titles from FleetDM. A software title groups multiple versions of the same software. Uses the /software/titles endpoint.	9
fleetdm_software_version	Software versions inventory from FleetDM. Uses the /software/versions endpoint.	7
fleetdm_team	Information about teams in FleetDM.	4
fleetdm_user	Information about users in FleetDM.	6