Splunk Enterprise Security

Create investigation in ES using SPL outputlookup command?

samlinsongguo
Communicator

Hi Everyone 

I am trying to create an investigation in ES using SPL.

Since ES is most work as lookup/kvstore, so I try to run the following SPL

| makeresults
| eval class_name="investigation",
    collaborators="[{\"name\": \"AAAAAA\", \"write\": true}, {\"name\": \"BBBBBB\", \"write\": true}]",
    create_time=1668731443,
    creator="CCCCCC",
    description="DDDDDDD",
    mod_time=1668731608,
    status="[{\"name\": \"In Progress\", \"time\": 1668739809, \"id\": \"investigation:2\"}]",
    title="EEEEEEE",
    version=1,
    comments="[]",
    tags="[]"
| table class_name, collaborators, create_time, creator, description, mod_time, status, title, version, comments, tags | outputlookup append=true investigation

I am able to add an entry in the KV store, but when I load the investigation tab in ES is breaks and appear Error as "Expect an array" and not able to load the page
 
Has anyone done this before?
 
Is that the right way, or is there another way to use SPL to create an investigation? 
 
 
 
 
 
Labels (2)
0 Karma
Get Updates on the Splunk Community!

🌟 From Audit Chaos to Clarity: Welcoming Audit Trail v2

🗣 You Spoke, We Listened  Audit Trail v2 wasn’t written in isolation—it was shaped by your voices.  In ...

What's New in Splunk Observability - October 2025

What’s New?    We’re excited to announce the latest enhancements to Splunk Observability Cloud and share ...

Splunk Enterprise Security 8.x: The Essential Upgrade for Threat Detection, ...

 Prepare to elevate your security operations with the powerful upgrade to Splunk Enterprise Security 8.x! This ...