Splunk Search

Combining details from two log entries into one table under common ID

pitaszek
New Member

Hello Comminity,

Here goes the more detailed descrition

2019-07-12 11:19:55.519 [VDI111][Process1][Info] msg=report;rpt_comment=Installation;rpt_Case_Id=6547456
2019-07-12 11:19:55.519 [VDI111][Process1][Info] msg=report;rpt_comment=Deinstallation;rpt_Case_Id=6547456

I want to create one row i a table where I have:

6547456 | Installation | Deinstallation

I tried search like:

VDI="VDI1" Process="Process1" rpt_comment* | table _time, rpt_Case_Id, rpt_comment

But it does split the rows for the ID

Hope you can come up with some idea.

Cheers,
W

Tags (1)
0 Karma

richgalloway
SplunkTrust
SplunkTrust

This search will create a single row for each ID, but you will have multiple values in each cell.

VDI="VDI1" Process="Process1" rpt_comment* 
| stats values(_time) as _time, values(rpt_comment) as rpt_comment by rpt_Case_Id 
| table _time, rpt_Case_Id, rpt_comment
---
If this reply helps you, Karma would be appreciated.
0 Karma
Get Updates on the Splunk Community!

Index This | I am a number, but when you add ‘G’ to me, I go away. What number am I?

March 2024 Edition Hayyy Splunk Education Enthusiasts and the Eternally Curious!  We’re back with another ...

What’s New in Splunk App for PCI Compliance 5.3.1?

The Splunk App for PCI Compliance allows customers to extend the power of their existing Splunk solution with ...

Extending Observability Content to Splunk Cloud

Register to join us !   In this Extending Observability Content to Splunk Cloud Tech Talk, you'll see how to ...