queries-google-logs-cloudwatch-insights.txt

fields @timestamp, @message
| sort @userAgent desc
| parse '* (*) - * [*] "* * *" * * "*" "*"' as localIp, realIp, identity, dateTimeString, httpVerb, url, protocol, statusCode, bytes, referer, userAgent
| filter @message like /Googlebot/ and @realIp = '66.249.69.166'


fields @timestamp, @message
| sort @timestamp desc
| parse '* (*) - * [*] "* * *" * * "*" "*"' as localIp, realIp, identity, dateTimeString, httpVerb, url, protocol, statusCode, bytes, referer, userAgent
| filter @message like /Googlebot/ 


fields @timestamp, @message
| sort @timestamp desc
| parse '* (*) - * [*] "* * *" * * "*" "*"' as localIp, realIp, identity, dateTimeString, httpVerb, url, protocol, statusCode, bytes, referer, userAgent
| filter @message like /Googlebot/ 



stats count(*) as numRequests by url
| sort @timestamp desc
| parse '* (*) - * [*] "* * *" * * "*" "*"' as localIp, realIp, identity, dateTimeString, httpVerb, url, protocol, statusCode, bytes, referer, userAgent
| filter @message like /Googlebot/ 

fields @timestamp, @message
| sort @timestamp desc
| parse '* (*) - * [*] "* * *" * * "*" "*"' as localIp, realIp, identity, dateTimeString, httpVerb, url, protocol, statusCode, bytes, referer, userAgent
| filter @message like /Googlebot/ and @message not like /\.(js|css|jpg|png|jpeg|gif|ico|svg)/