Splunk Search

field extractions are not working

kml_uvce
Builder

my field extractions are not working

tranforms.conf file is
[tms_iisfields]
FIELDS = "date","time","s-ip","cs-method","cs-uri-stem","cs-uri-query","s-port","cs-username","c-ip","cs(User-Agent)","sc-status","sc-substatus","sc-win32-status","time-taken"

props.conf file is

[iis-2]
rename=tms-iis

[tms-iis]
CHECK_FOR_HEADER = False
MAX_TIMESTAMP_LOOKAHEAD = 128
TIME_FORMAT = %Y-%m-%d %H:%M:%S
REPORT-tms_iisfields = tms_iisfields

and search output is
2011-12-19 13:35:56 172.27.70.10 GET /OTPAuthentication/Service.asmx - 443 - 72.246.50.40 Python-urllib/1.17 200 0 0 62
2011-12-19 13:35:56 172.27.70.10 GET /OTPAuthentication/Service.asmx - 443 - 72.247.36.53 Python-urllib/1.17 200 0 0 78

but not showing fields "date","time","s-ip","cs-method","cs-uri-stem","cs-uri-query","s-port","cs-username","c-ip","cs(User-Agent)","sc-status","sc-substatus","sc-win32-status","time-taken" in output

kamal singh bisht
Tags (1)
0 Karma
1 Solution

kml_uvce
Builder

looks like this was the issue with the apps permission , now its working...

kamal singh bisht

View solution in original post

0 Karma

kml_uvce
Builder

looks like this was the issue with the apps permission , now its working...

kamal singh bisht
0 Karma

kml_uvce
Builder

still its not working after writing DELIMS = " " in transforms.conf

kamal singh bisht
0 Karma

Ledion_Bitincka
Splunk Employee
Splunk Employee

it seems like you have forgotten to specify the delimiter in transforms.conf - try the following

[tms_iisfields] 
FIELDS = "date","time","s-ip","cs-method","cs-uri-stem","cs-uri-query","s-port","cs-username","c-ip","cs(User-Agent)","sc-status","sc-substatus","sc-win32-status","time-taken"
DELIMS = " "
Get Updates on the Splunk Community!

Enter the Agentic Era with Splunk AI Assistant for SPL 1.4

  🚀 Your data just got a serious AI upgrade — are you ready? Say hello to the Agentic Era with the ...

Stronger Security with Federated Search for S3, GCP SQL & Australian Threat ...

Splunk Lantern is a Splunk customer success center that provides advice from Splunk experts on valuable data ...

Accelerating Observability as Code with the Splunk AI Assistant

We’ve seen in previous posts what Observability as Code (OaC) is and how it’s now essential for managing ...