activity_dashboard_bad_request_countactivity_dashboard_error_countactivity_dashboard_redirect_countactivity_dashboard_requests_by_dayactivity_dashboard_requests_by_errorsactivity_dashboard_requests_by_http_methodactivity_dashboard_requests_by_status_codeactivity_dashboard_requests_by_successful_requestsactivity_dashboard_requests_by_user_agentactivity_dashboard_success_countactivity_dashboard_top_10_clientsactivity_dashboard_top_10_urlsactivity_dashboard_total_logscross_site_scripting_angular_templatecross_site_scripting_attribute_injectioncross_site_scripting_common_patternscross_site_scripting_dom_basedcross_site_scripting_encodingcross_site_scripting_html_injectioncross_site_scripting_javascript_methodscross_site_scripting_javascript_uricross_site_scripting_script_tagencoded_path_traversalheader_based_local_file_inclusionhidden_file_accesslog4shell_vulnerabilityos_file_accesspath_traversalrestricted_file_accessspring4shell_vulnerabilitysql_injection_blind_basedsql_injection_common_patternssql_injection_error_basedsql_injection_time_basedsql_injection_union_basedsql_injection_user_agent_based
Query: Requests by Day
Description
Count of requests grouped by day.
Usage
powerpipe query apache_access_log_detections.query.activity_dashboard_requests_by_dayTailpipe Tables
SQL
select strftime(tp_timestamp, '%Y-%m-%d') as "Date", count(*) as "Request Count"from apache_access_loggroup by strftime(tp_timestamp, '%Y-%m-%d')order by strftime(tp_timestamp, '%Y-%m-%d');
Dashboards
The query is used in the dashboards: