Getting Data In

How can I use regex to list a table?

jacknguyen
Path Finder

I have a event like this:
image.png

I want to list a table following CLIENT_LIST. For example:

ip_vpn            name_vpn       time_vpn

10.10.0.20    louis_tran        Tue Apr 4 9:21:41 2023

10.0.0.21       wanki_trinh    Tue Apr 4 9:15:02 2023

---------------------

Anyone have any idea

0 Karma
1 Solution

ITWhisperer
SplunkTrust
SplunkTrust
0 Karma

jacknguyen
Path Finder

the table show nothing image.png

bowesmana
SplunkTrust
SplunkTrust

You have a space in your rex statement after CLIENT_LIST,

You should have

CLIENT_LIST,(?<

you have

CLIENT_LIST, (?<
0 Karma

jacknguyen
Path Finder

it works. thank you. How ever the table like this: 

image.png

And I just want splunk show the latest event and mvexpand it like this:

I try to use ||stats latest but its not working. Do you know how to do this

image.png

0 Karma

ITWhisperer
SplunkTrust
SplunkTrust

ITWhisperer_0-1680594933653.png

 

0 Karma
Get Updates on the Splunk Community!

Database Performance Sidebar Panel Now on APM Database Query Performance & Service ...

We’ve streamlined the troubleshooting experience for database-related service issues by adding a database ...

IM Landing Page Filter - Now Available

We’ve added the capability for you to filter across the summary details on the main Infrastructure Monitoring ...

Dynamic Links from Alerts to IM Navigators - New in Observability Cloud

Splunk continues to improve the troubleshooting experience in Observability Cloud with this latest enhancement ...