Hi
As you said for above logs grok filter will be perfect.But I will tell you my project scenario.i have a laravel Project, don't know what type of data i will get as a log message it will change dynamically so i have to create a filter which will read the log message and divide that log data into individual fields as a key value pair so that i can easily able to create dashboards.can you help how we can do this?? I am not able to find the way and below is the sample laravel log data.
Note : This message will change dynamically
laravel Log data::
2020-03-12 08:53:46] local.ERROR: SQLSTATE[HY000] [1045] Access denied for user 'pmauser'@'localhost' (using password: YES) (SQL: select count() as aggregate from users where email = gopipathshala@gmail.com) {"exception":"[object] (Illuminate\Database\QueryException(code: 1045): SQLSTATE[HY000] [1045] Access denied for user 'pmauser'@'localhost' (using password: YES) (SQL: select count() as aggregate from users where email = gopipathshala@gmail.com) at /var/www/user/vendor/laravel/framework/src/Illuminate/Database/Connection.php:664, PDOException(code: 1045): SQLSTATE[HY000] [1045] Access denied for user 'pmauser'@'localhost' (using password: YES) at /var/www/user/vendor/laravel/framework/src/Illuminate/Database/Connectors/Connector.php:70)