Table Of Contents Logpresso Query Reference Download Overview Before You Start Running Queries in the Web Console Query Types Query Syntax General Commands Parameters Data Source Data Processing Data Mapping Data Loading Data Merging Complex Event Processing Machine Learning Procedure External System Integration Sonar Commands Events Assets Datasets Threat Intelligence Behavior Profiles Address Groups Subnet Groups Port Groups Pattern Groups Forensic Commands Windows Artifacts Linux Artifacts Web Browser Artifacts System Commands System Configuration Log Collectors Table and Data Lookup Queries PCAP Devices Sentries Threads Federation Nodes License Functions Reference Functions Aggregate Functions Type Conversion Functions Type Checking Functions Conditional Functions String Functions Numeric Functions Time Functions IP Address Functions Encryption and Encoding Functions CEP Functions Object Group Functions