How to: Search your logs using query language in AppLogs
Collect, consolidate, index, and search logs to gain actionable insights using Site24x7 AppLogs. Add a log profile and log type to start managing your logs. Run an easy-to-understand query language search to filter out invalid values and obtain actionable results quickly. Learn more about query syntax, structure, and types from the help docs below.
0:00 - Introduction
0:42 - AppLogs query language: Supported keywords
0:49 - or query: Compare the success vs. failure requests in your IIS Access logs
1:04 - avg, min, max, sum queries: Find the performance of your requests using the time taken fields
1:21 - timeslice query : Identify the number of failed requests with a 500 status code every day:
1:32 - group by -timeslice query : Identify the different request statuses each day grouped by the status code.
1:43 - before query: Compare the total success request count this week with last week.
2:00 - before-timeslice: Compare this week's overall success request count with last week's by each day.
2:16 - Groupby - Having - Sort: Find which requests mostly take more than 1 second to complete.
2:35 - Percents-Percentile: Identify the TimeTaken for 95% of the requests.
2:46 - histo-range: Identify the number of requests at various time intervals.
Other videos:
https://www.youtube.com/watch
https://www.youtube.com/watch
Related links:
https://www.site24x7.com/log-management.html
Help doc links:
https://www.site24x7.com/help/log-management/
https://www.site24x7.com/help/log-management/query-language.html
https://www.site24x7.com/help/log-management/add-log-type.html
https://www.site24x7.com/help/log-management/alerts.html
https://www.site24x7.com/help/log-management/supported-log-types.html
Related blogs:
https://www.site24x7.com/blog/debug-iis-failures-using-logs
https://www.site24x7.com/blog/10-filter-patterns-for-logs