Splunk Search

Search for field with '*'

Jiten009
Explorer

Hi,
I need to search for logs with only query="*" but when I am putting in my search its fetching all the logs with query="*", query="logo", query="link", since Spluk is treating * as wildcard. So what should be the query ? My logs below :

INFO 2013-03-13 14:03:15 endPoint=search,host=168.94.64.138,remoteAdress=167.209.125.121,query="*",brand_facet=All Chairs,status="Success"

INFO 2013-03-13 14:07:35 endPoint=search,host=168.94.64.138,remoteAdress=167.209.125.121,query="logo",brand_facet=Logo Chairs,status="Success"

INFO 2013-03-13 14:09:41 endPoint=search,host=168.94.64.138,remoteAdress=167.209.125.121,query="link",brand_facet=Link Chairs,status="Success"

Thanks in advance for any help.

Tags (4)
0 Karma

martin_mueller
SplunkTrust
SplunkTrust

I'm not sure how efficient this will be, but it's worth a try:

query>="*" query<="*"
0 Karma

jeff
Contributor

Something like this should work:

"query" | regex _raw="(?i)query=\"*\""

but that'll be awful inefficient since it will return all lines with "query" (presumably every record in your index for this sourcetype) then filter based on the regex. You'll be better off if you can add additional criteria to filter it, or replace the * character at index time using SEDCMD, for instance...

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!

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

Think Like an Architect: Introducing the Splunk Certified Cybersecurity Defense ...

In cybersecurity, defenders respond to threats. Architects design the systems that stop them.    As ...

Best Practices: Splunk auto adjust pipeline queue

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