Splunk Search

No results without using wildcard in messagetype in my search

mwinkel
New Member

Hi,
It seems I cannot get any search results without including a wildcard in messagetype.
More specifically:
After searching for messagetype="proposal", no events are shown.
Searching for messagetype="*proposal", events are shown.
Further research also showed that there aren't any special characters involved in the problem.

This is the complete query:

index="*-closecl-*" application="closecl" component="closecl-bfl-ws" 
environment=*
transactionType="notifyParty" messageType="*proposal" | dedup TranID sortby +_time| lookup CloseCLDossierMetaData uid as TranID OUTPUTNEW uid CustomerCode, ProductType, GrossCreditAmount, LabelCode, ProductCode, SourceSystem  | timechart minspan=1d bins=60  dc(TranID) as count | fillnull

Thanks in advance!


updated by dmj to mark code

0 Karma

sbbadri
Motivator

index="-closecl-" application="closecl" component="closecl-bfl-ws" environment=* transactionType="notifyParty" messageType="proposal" | eval messageType=trim(messageType) | rest of your query

0 Karma

DalJeanis
Legend

@sbbadri - be sure to mark your code, please.

0 Karma

DalJeanis
Legend

Run this and post the results, please...

  index="*-closecl-*" application="closecl" component="closecl-bfl-ws"  environment=*
  transactionType="notifyParty" messageType="*proposal"
 | eval myproposal="---".messageType."---"
 | stats count by myproposal
0 Karma

richgalloway
SplunkTrust
SplunkTrust

Can you share some sample data?

---
If this reply helps you, Karma would be appreciated.
0 Karma
Get Updates on the Splunk Community!

Data Management Digest – December 2025

Welcome to the December edition of Data Management Digest! As we continue our journey of data innovation, the ...

Index This | What is broken 80% of the time by February?

December 2025 Edition   Hayyy Splunk Education Enthusiasts and the Eternally Curious!    We’re back with this ...

Unlock Faster Time-to-Value on Edge and Ingest Processor with New SPL2 Pipeline ...

Hello Splunk Community,   We're thrilled to share an exciting update that will help you manage your data more ...