Getting Data In

Data Masking

muguniya
Explorer

Hi Team,

I need to mask multiple phrase in XML file. where in the complete XML file is in one single line. Please confirm will below setup will do the job

transforms.conf

[memberid-anonymizer]
DEST_KEY = _raw
FORMAT = $1memberID>XXXXX$2
REGEX = (?m)^(.*)memberID>\w+(\w{4}[\<"].*)$
SOURCE_KEY = _raw

[firstname-anonymizer]
DEST_KEY = _raw
FORMAT = $1memberFirstName>XXXXXXXXX$2
REGEX = (?m)^(.*)memberFirstName>\w+(\w{0}[\<"].*)$
SOURCE_KEY = _raw

[lastname-anonymizer]
DEST_KEY = _raw
FORMAT = $1memberLastName>XXXXXXXXX$2
REGEX = (?m)^(.*)memberLastName>\w+(\w{0}[\<"].*)$
SOURCE_KEY = _raw

props.conf

[testsandbox]
TRANSFORMS-anonymize = memberid-anonymizer, firstname-anonymizer, lastname-anonymizer

Sample Event:

2014-04-11 53:14:37,751 INFO  [WebContainer : 24] (UrgentCareController.java:) - InterPortletObjects from pp <com.sample.test.MytestObjects>
  <memberID>1234567</memberID>
  <memberlifeID>1294032</memberlifeID>
  <memberFirstName>Mugunthan</memberFirstName>
  <memberLastName>Gopala</memberLastName>
</com.sample.test.MytestObjects>  

Thanks
Mugunthan

Tags (1)
0 Karma

martin_mueller
SplunkTrust
SplunkTrust

That should work, though I recommend using props.conf SEDCMD-class instead - something like this:

[testsandbox]
SEDCMD-memberid = s/(<memberID>)\w+(\w{4}</memberID>)/\1XXXXX\2/g
SEDCMD-membername = s/(<member(?:First|Last)Name>)[^<]+(</member(?:First|Last)Name>)/\1XXXXXXXX\2/g

I personally prefer this for simplicity when all you need is a simple anonymizing replace.

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!

A Four-Part Event Series: Full Stack Observability For the AI Era

As AI reshapes applications, infrastructure, and the way teams operate, the traditional boundaries of ...

SOC4Kafka - New Kafka Connector Powered by OpenTelemetry

The new SOC4Kafka connector, built on OpenTelemetry, enables the collection of Kafka messages and forwards ...

Event Series: Level up your SOC: Advancing with Splunk Enterprise Security

AI has fundamentally raised the stakes for security operations, and this three-part series is your guide to ...