Join the Conversation
- Find Answers
- :
- Using Splunk
- :
- Splunk Search
- :
- does not appear in the field
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark Topic
- Subscribe to Topic
- Mute Topic
- Printer Friendly Page
- Mark as New
- Bookmark Message
- Subscribe to Message
- Mute Message
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Hi all
I have event like that.
2019-10-26 15:00:09.158, servicename="ROOT2", area="SCP", place="tokyo", path="AAA12345", Default="B", Sn="B", SC="B", update="person"
"path" "place" "area" "servicename" and "Sn" are automatically appear in the field.
When a field is specified, a value such as B appears.
But "SC" did not appear automatically. I think it is few.
I need value like B.
I want to make table.
index=main |table path, area, Sn, SC
path,area,Sn,SC
AAA12345,tokyo,B,B
AAA23456,osaka,A,A
AAA34567,nagoya,C,A
What should I do?
Thank you for helping.
- Mark as New
- Bookmark Message
- Subscribe to Message
- Mute Message
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
You can use regex in the query for extracting 'SC' value.
ex:
SC=\"(?<sc>\w*)\"
- Mark as New
- Bookmark Message
- Subscribe to Message
- Mute Message
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Add this as the first pipe in your SPL:
... | rex "SC=\"(?<SC>[^\"]+)\" ...
- Mark as New
- Bookmark Message
- Subscribe to Message
- Mute Message
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
You can use regex in the query for extracting 'SC' value.
ex:
SC=\"(?<sc>\w*)\"
- Mark as New
- Bookmark Message
- Subscribe to Message
- Mute Message
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Thank you for helping.
but, it does not work well.
- Mark as New
- Bookmark Message
- Subscribe to Message
- Mute Message
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
when I used |rex field=_raw
It work well.
Thank you.
Join the Splunk Community Slack to learn, troubleshoot, and make connections with fellow Splunk practitioners in real time!
Join Splunk User Groups to connect and learn in-person by region or remotely by topic or industry.
Announcing Modern Navigation: A New Era of Splunk User Experience
Modernize your Splunk Apps – Introducing Python 3.13 in Splunk
Step into “Hunt the Insider: An Splunk ES Premier Mystery” to catch a cybercriminal ...
