Monitoring Splunk

lookup table field update

raomu
Explorer

Hello,

I have a lookup with 3 fields "Hostname" "IP" "Status" ( Status is by default set with the value "Non-Active")

Hostname IP Status
AA 10.x.x.x Non-Active

BB 10.x.x.x Non-Active

CC 10.x.x.x Non-Active

Now I did a search using lookup to find what all servers are currently reporting to Splunk :

Result :

Host reporting to Spunk

AA

CC

Based on the result I want to update the value of field (Status as "Active") in existing lookup

So the result I am expecting :

lookup table looks now :

Hostname IP Status
AA 10.x.x.x Active

BB 10.x.x.x Non-Active

CC 10.x.x.x Active

Tags (1)
0 Karma

valiquet
Contributor

|eval Status=Active | join type=left [|inputlookup table] |outputlookup

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!

Splunk Auto Ingestion Parallel Pipeline Scaling

Why this feature matters Many Splunk environments experience ingestion pressure long before the host is fully ...

Best Practices: Splunk auto adjust pipeline queue

When you enable autoAdjustQueue in Splunk, maxSize should be understood as the queue size Splunk starts with ...

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 ...