Getting Data In

Missing fields on Splunk data export & import

CSReviews
Loves-to-Learn

I have one Splunk instance where I ran a search and exported the data in a csv file, xml file, and a raw file. The data contained is mostly Windows event logs, "process command line", "creator process", ect.

I am trying to import this data into another Splunk instance. When the data is imported, I noticed some fields are missing, like "process command line". I tried each file type and had no success. I also reviewed the data in the fields and all of the fields and values are present. 

 

Essentially, I am trying to import data similar to Splunk BOTS 

GitHub - splunk/botsv3: Splunk Boss of the SOC version 3 dataset.

Labels (1)
0 Karma

gcusello
SplunkTrust
SplunkTrust

Hi @CSReviews ,

as @marnall said, running a search, yu probably modify the raw data.

to export data. the best approach is to run a search without table command, only the main search and then export data in raw format.

There's only one issue: you have to run this search separating events fo index, sourcetype and host, and then import data assigning the correct values, otherwise you cannot assign the correct values to these fields.

Ciao.

Giuseppe

marnall
Motivator

If I understand you correctly, you are exporting the results of a search, then importing it in another Splunk instance as new data? This would definitely alter the fields. The exporting of search results is not intended as a method to move data unchanged from one Splunk instance to another.

Are you trying to import BOTS data or to package indexed data in a manner similar to the BOTS data?

0 Karma
Got questions? Get answers!

Join the Splunk Community Slack to learn, troubleshoot, and make connections with fellow Splunk practitioners in real time!

Meet up IRL or virtually!

Join Splunk User Groups to connect and learn in-person by region or remotely by topic or industry.

Get Updates on the Splunk Community!

Deep Dive: Accelerate threat investigation with Splunk’s AI Assistant in Security

AI is one of the biggest topics in the market today, and for security teams, its value goes far beyond the ...

Announcing Modern Navigation: A New Era of Splunk User Experience

We are excited to introduce the Modern Navigation feature in the Splunk Platform, available to both cloud and ...

Detection Engineering Office Hours: Real-World Troubleshooting & Q&A

[REGISTER HERE] This thread is for the Community Office Hours session on Detection Engineering Office Hours: ...