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
Docs
Stories
News Ask around Schedule a demo Share your story COMPANY The handbook What people are saying
Pricing 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

powershell_events

click to open the table of contents
Windows logo

powershell_events EVENTED TABLE

Powershell script blocks reconstructed to their full script content, this table requires script block logging to be enabled.

Column Type Description
cosine_similarity double How similar the Powershell script is to a provided 'normal' character frequency
datetime text System time at which the Powershell script event occurred
script_block_count integer The total number of script blocks for this script
script_block_id text The unique GUID of the powershell script to which this block belongs
script_name text The name of the Powershell script
script_path text The path for the Powershell script
script_text text The text content of the Powershell script
time bigint Timestamp the event was received by the osquery event publisher

Example

select * from powershell_events where cosine_similarity < 0.25;
Edit page

Questions?

Ask us anything
{{table.title}} evented table