Dashboards & Visualizations

RegEx help in filtering values for splunk dashboard

jerinvarghese
Communicator

Hi all,

I have an output..

ISIS: Adjacency to IDCSO-WANRTC001 (FastEthernet0/0/0) Down, bfd neighbor down
ISIS: Adjacency to IDCSO-WANRTC001 (FastEthernet0/0/0) Up, new adjacency

COde currently am using.

index=nw_syslog "*CLNS-5-ADJCHANGE*"
| rename _time as Time_CST
| fieldformat Time_CST=strftime(Time_CST,"%x %X")
| dedup hostname, message
| table hostname, Time_CST, message

Output:

hostname    Time_CST    message
idpbv   03/31/20 06:24:32   ISIS: Adjacency to IDCSO (FastEthernet0/0/0) Down, bfd neighbor down
idpbv   03/31/20 06:24:33   ISIS: Adjacency to IDCSO (FastEthernet0/0/0) Up, new adjacency
idpbv   03/31/20 06:26:32   ISIS: Adjacency to IDCSO (FastEthernet0/2/0) Down, bfd neighbor down
idpbv   03/31/20 06:26:54   ISIS: Adjacency to IDCSO (FastEthernet0/2/0) Up, new adjacency

Expected output By using Regex.

hostname    Time_CST    Interface   Status  Count
idpbv   3/31/2020 6:24  FastEthernet0/0/0   UP  2
idpbv   3/31/2020 6:26  FastEthernet0/2/0   UP  2
Labels (1)
0 Karma
1 Solution

vnravikumar
Champion

Hi

Check this

| makeresults 
| eval temp="ISIS: Adjacency to IDCSO (FastEthernet0/0/0) Down, bfd neighbor down#ISIS: Adjacency to IDCSO (FastEthernet0/0/0) Up, new adjacency#ISIS: Adjacency to IDCSO (FastEthernet0/2/0) Down, bfd neighbor down#ISIS: Adjacency to IDCSO (FastEthernet0/2/0) Up, new adjacency" 
| eval message = split(temp,"#") 
| mvexpand message 
| rex field=message "\((?P<interface>[^)]+)\)\s+(?P<status>[^,]+)" |table message interface status

View solution in original post

0 Karma

vnravikumar
Champion

Hi

Check this

| makeresults 
| eval temp="ISIS: Adjacency to IDCSO (FastEthernet0/0/0) Down, bfd neighbor down#ISIS: Adjacency to IDCSO (FastEthernet0/0/0) Up, new adjacency#ISIS: Adjacency to IDCSO (FastEthernet0/2/0) Down, bfd neighbor down#ISIS: Adjacency to IDCSO (FastEthernet0/2/0) Up, new adjacency" 
| eval message = split(temp,"#") 
| mvexpand message 
| rex field=message "\((?P<interface>[^)]+)\)\s+(?P<status>[^,]+)" |table message interface status
0 Karma

jerinvarghese
Communicator

the regexworks

| rex field=message "((?P[^)]+))\s+(?P[^,]+)" |table message interface status

0 Karma
Get Updates on the Splunk Community!

The Splunk Success Framework: Your Guide to Successful Splunk Implementations

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

Splunk Training for All: Meet Aspiring Cybersecurity Analyst, Marc Alicea

Splunk Education believes in the value of training and certification in today’s rapidly-changing data-driven ...

Investigate Security and Threat Detection with VirusTotal and Splunk Integration

As security threats and their complexities surge, security analysts deal with increased challenges and ...