HI Team, Need one help, I want to run a schedule for the below search events every 1 hr and capture the inportant fields like responseStatus, requestMethod, requestURL, servicePath, Total request,...
See more...
HI Team, Need one help, I want to run a schedule for the below search events every 1 hr and capture the inportant fields like responseStatus, requestMethod, requestURL, servicePath, Total request, hour, day, etc. and write to outputfile in csv. So that I can use this report for my dashboards. The idea behind this is becase, our application logs millions of events per day and if we want to look for the historical data for reports, it takes long time to run and load the dashboard. I want to run this every hour and append the data it in the existing csv file. I tried the lookup but didn't work for me. Any solutions welcome time=2021-04-14T17:57:07+00:00 requestId=751411798490203 traceId=751411798490203 servicePath="/ecp/" remoteAddr=71.74.45.8 clientIp=24.161.128.196 clientAppVersion=NOT_AVAILABLE app_version=- apiKey=72c07648-ea14-34f2-abed-e38263580b5c oauth_leg=2-legged authMethod=oauth apiAuth=true apiAuthPath=/ecp/ oauth_version=1.0 target_bg=default requestHost=api.spectrum.net requestPort=8080 requestMethod=GET requestURL="/ecp/entitlements/v2/entitlements?divisionId=NEW.004&accountNumber=28290420" requestSize=560 responseStatus=200 responseSize=8422 responseTime=0.025 userAgent="IPVS" mapTEnabled="F" charterClientIp="V-1|IP-24.161.128.196|SourcePort-|TrafficOriginID-24.161.128.196" sourcePort="" oauth_consumer_key="72c27648-ea14-44f2-abed-e38263580b5c" x_pi_auth_failure="-" pi_log="pi_ngxgw_access"