Splunk Search

Log4j matching

Papemalik1
New Member

Hello,

I have 2 lookups, L0011 which contains all (Known) products with the vulnerability Log4shell and L0012 with all the products and assets that I have in house.

I would like to join these 2 lookups to have at the end: all vulnerable products that I have and the assets for each products.

But so far the joining is not working. I have used the command join and lookup, i have added wildcard on the lookup definition  also, but it's not working either. (the results is not exhaustive, i have very few matches)

the main issue is that the names of the products don't match identically (even with wildcard).

Do you guys have any idea on how could I do matching with my two lookups?

do not hesiate to ask if I need to clarify more.

Thanks a lot in advance

Labels (2)
0 Karma

johnhuang
Motivator

I would consider the approach of normalizing your data -- either clean up the source or lookup products field to match the other.

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!

Agentic SOC Triage: Investigating Splunk ES Notables with MCP Server and a Local LLM

The Problem: Too Many Alerts, Too Little Context Security operations teams running Splunk Enterprise Security ...

All Work and No Play? Not at .conf26! Unwind at These Evening Events

Between hands-on technical sessions, keynote reveals, and diving into live architectures, .conf26 is packed ...

Join the Hackathon at .conf26 and build a No-Code AI agent

Join us for the AI Agent Buildathon, an in-person, three-hour hands-on Hackathon where you’ll use Splunk Agent ...