I would like to display the time taken for a page to load in Splunk. Here is my query:
splunk_server=* index="myindex1" host=NA*P* host=COSERVER313 | convert num(time_taken) | sort 100 -time_taken
Here is the result:
splunk_server=* index="myindex1" host=NA*P* host=COSERVER313 | convert num(time_taken) | sort 100 -time_taken
2/28/19
1:59:28.000 AM
2019-02-28 06:59:28 W3SVC21 10.121.3.95 GET /en/mypage1/publications/documents/2016-documents/w112-document1.aspx - 443 - 10.121.3.101 Mozilla/5.0+(compatible;+search-crawler-EXTERNAL;++null;+SYS.COM.Search.Team@company.org) - 200 0 64 0 555 265525 54.88.115.238
host = COSERVER313 source = E:\ywlogs\company\IIS\W3SVC21\u_ex190228_x.log sourcetype = iis
2/28/19
@jdhavo,
Where is the problem now ? Are you not getting time_taken value? is that a field?