Log analytics: importing load time


Hey I have spent a lot of time looking for similar solutions. If I have overlooked some obvious solution let me know.

I am currently importing some apache logs. The logs import successfully without me specify the log format. However I need to craft some regex to capture the %D from my apache logs.

The format for my log is as follows:
LogFormat “%h %l %u %t %D “%r” %>s %b “%{Referer}i” “%{User-agent}i”“
It similar to the NCSA which is:
”%h %l %u %t “%r” %>s %b “%{Referer}i” “%{User-agent}i”“
The regex for NCSA is:
’(?P\S+) \S+ \S+ [(?P.?) (?P.?)] ’ '”\S+ (?P.?) \S+" (?P\S+) (?P\S+) "(?P.?)” “(?P<user_agent>.*?)” '
The piwik site says I ought to be able to include generation_time_milli regex group to capture this. I know that I am close. I am sorry if it seem like I’m lazy. My regex skills are weak :stuck_out_tongue: . Thanks for your time. I would be willing to provide additional information (example log lines etcetera).