Examples Library

This collection provides example LogScale queries, with each query described, line by line, to demonstrate not only the syntax of the queries, but also why the different syntax and expressions have been used to search the query data.

Search LogScale Query Examples

Search by query type, title, or function, package name, widget type, or vendor. Filters can be combined; selecting more filters will result in fewer examples.

Recent Query Examples

Format Timestamp as ISO 8601 Using Shorthand Notation
Convert Unix epoch timestamp to ISO 8601 format using the formatTime() function with shorthand notation
Remove Trailing Whitespace From Log Messages
Clean up log messages using the text:trim() function
Remove Leading Whitespace From Log Messages
Clean up log messages using the text:trim() function
Remove Both Leading And Trailing Whitespace From Log Messages
Clean up log messages using text:trim() function
Profile Query Performance
Analyze query execution steps and their performance metrics using the explain:asTable() function
Profile Performance of Join Operations
Analyze query performance of join operations with filtering using the explain:asTable() function with join()
Profile Performance of Lookup Operations
Analyze query performance when using the explain:asTable() with defineTable() and match() for data enrichment
Group User Activity by Service Name
Visualize user activity distribution across different services in a bar chart
Count Total Policy Events
Track the total number of policy-related events
Display Count of Medium Severity CVEs
Track total number of medium severity vulnerabilities

Versions of this Page

Examples Library

Examples Library

Recent Query Examples

Enter search term