OR in Pivot command

jaracan · ‎07-12-2018

Hi Team,

How do we do "OR" in pivot command?
I wanted to have a result with either product ="IOS" OR product ="WLC"

Current search: Take note of FILTER product is "IOS"
| pivot Cisco_IOS_Event Cisco_IOS_Event count(Cisco_IOS_Event) AS "Count of Event" SPLITROW _time AS "_time" PERIOD auto SPLITCOL mnemonic FILTER product is "IOS" SORT 0 _time NUMCOLS 10

I tried FILTER product is "IOS" OR product is "WLC" but did not work.

What should I done differently? Thanks in advance.

FrankVl · ‎07-12-2018

Have you tried FILTER product in ("IOS","WLC")?

OR in Pivot command

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

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

Your Feedback. Our Roadmap. Visit the PX Feedback Booth at .conf26

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

Painting a Clearer Picture: Creating Cross-Domain Visibility with AI Canvas

Join the Conversation

OR in Pivot command

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

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

Your Feedback. Our Roadmap. Visit the PX Feedback Booth at .conf26

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

Painting a Clearer Picture: Creating Cross-Domain Visibility with AI Canvas