topic change sourcetype for sourcetype not starting with specific word in Splunk Search

change sourcetype for sourcetype not starting with specific word

ss026381 — Wed, 23 Oct 2019 19:02:26 GMT

I want to change the sourcetype for all incoming logs with sourcetypes not starting with abc. I have following setting but it would change it for all the sourcetypes

  #Transforms.conf on indexer

  [noncerner:setnull]
  SOURCE_KEY = MetaData:Sourcetype
  REGEX = (?::){0}^(?!ABC).*
  #REGEX = ^(?!ABC).* tried it
  #REGEX = sourcetype::^(?!ABC).* tried it
  #REGEX = sourcetype::(?::)^(?!ABC).* tried it
  DEST_KEY = MetaData:Sourcetype
  FORMAT = sourcetype::ABC:temp:logs

Any hep is appreciated.

Re: change sourcetype for sourcetype not starting with specific word

tiagofbmm — Wed, 23 Oct 2019 21:26:03 GMT

^((?!abc).)*

This regex shall negate the string exists.

Re: change sourcetype for sourcetype not starting with specific word

ss026381 — Thu, 24 Oct 2019 13:22:31 GMT

there is no problem with the regex. it works when I put it in regex101. I think the problem is that we cannot use regex with sourcetype.

Re: change sourcetype for sourcetype not starting with specific word

tiagofbmm — Thu, 24 Oct 2019 14:44:11 GMT

This is the syntax for what you want to do. Let me know

[noncerner:setnull]
FORMAT = sourcetype::ABC:temp:logs
DEST_KEY = MetaData:Sourcetype
SOURCE_KEY = MetaData:Sourcetype
REGEX = sourcetype::(((?!abc)).*)

Re: change sourcetype for sourcetype not starting with specific word

ss026381 — Thu, 24 Oct 2019 15:59:54 GMT

Very big thumps up, it worked, thanks. I am testing few more scenarios and will comment later today.