Geoffrey Cleaves gcleaves
gcleaves
/ mysql_date_trunc
Last active
August 26, 2015 16:12
— forked from mtrbean/mysql_date_trunc
MySQL date_trunc equivalent
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| DATE_TRUNC('week', now()) === STR_TO_DATE(CONCAT(YEARWEEK(now(), 2), ' Sunday'), '%X%V %W') | |
| DATE_TRUNC('month', now()) === DATE_FORMAT(now(), '%Y-%m-01') |
gcleaves
/ Create_Laravel_Pipeline.txt
Last active
January 8, 2022 11:40
— forked from omaryoussef/Create_Laravel_Pipeline.txt
Creates a Filebeat pipeline to ingest Laravel Monolog/log lines.
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| PUT _ingest/pipeline/laravel | |
| { | |
| "description": "Parses Laravel log files.", | |
| "processors": [ | |
| { | |
| "rename": { | |
| "field": "message", | |
| "target_field": "event.original" | |
| } | |
| }, |