Dashboards & Visualizations

How can I create a table with different fields from different events?

naveenchappa
New Member

After we process a client file, we get event in splunk as shown in below snapshot.

alt text

From these events I want to build a table something like below.

alt text

Can someone please help?

Regards,
Naveen

Tags (1)
0 Karma
1 Solution

cmerriman
Super Champion
....|stats values(ERP_WP_PAYSTATEMENTS) as ERP_WP_PAYSTATEMENTS values(CDM_WP_PAYSTATEMENTS) as CDM_WP_PAYSTATEMENTS values(CDM_EE_LIEN_COUNT) as CDM_EE_LIEN_COUNT values(ARFF_WP_PAYSTATEMENTS) as ARFF_WP_PAYSTATEMENTS values(ARFF_EE_LIEN_COUNT) as  ARFF_EE_LIEN_COUNT by TransactionId CLIENT_ID

This should work if the paystatement values are fields. otherwise we might have to create some regex statements.

View solution in original post

0 Karma

cmerriman
Super Champion
....|stats values(ERP_WP_PAYSTATEMENTS) as ERP_WP_PAYSTATEMENTS values(CDM_WP_PAYSTATEMENTS) as CDM_WP_PAYSTATEMENTS values(CDM_EE_LIEN_COUNT) as CDM_EE_LIEN_COUNT values(ARFF_WP_PAYSTATEMENTS) as ARFF_WP_PAYSTATEMENTS values(ARFF_EE_LIEN_COUNT) as  ARFF_EE_LIEN_COUNT by TransactionId CLIENT_ID

This should work if the paystatement values are fields. otherwise we might have to create some regex statements.

0 Karma

naveenchappa
New Member

Thank you @cmerriman it worked.

0 Karma
Get Updates on the Splunk Community!

Accelerate Service Onboarding, Decomposition, Troubleshooting - and more with ITSI’s ...

Accelerate Service Onboarding, Decomposition, Troubleshooting - and more! Faster Time to ValueManaging and ...

New Release | Splunk Enterprise 9.3

Admins and Analyst can benefit from:  Seamlessly route data to your local file system to save on storage ...

2024 Splunk Career Impact Survey | Earn a $20 gift card for participating!

Hear ye, hear ye! The time has come again for Splunk's annual Career Impact Survey!  We need your help by ...