Splunk Search

data masking via transforms.conf and props.conf wont work?

patricianaguit
Explorer

After indexing the data, i've done some transforms.conf and props.conf configuration. The configuration masks the first 8 digits of the account number. Someone help me why its not working?

props.conf:
[transforms_vendor]
DATETIME_CONFIG =
NO_BINARY_CHECK = true
category = Custom
disabled = false
pulldown_type = true
TRANSFORMS-sample = anon_data

transforms.conf:
[anon_data]
REGEX = AcctID=\d{8}(\d{8})
FORMAT = $1AcctID=XXXXXXXX$2
DEST_KEY = _raw

0 Karma
1 Solution

cpetterborg
SplunkTrust
SplunkTrust

At the very least your FORMAT has a problem. You only have one capture group in the text that I can see (though you may have put in more, and it has been formatted out because you didn't use the code formatting). It should be:

FORMAT = AcctID=XXXXXXXX$1

I would also use the suggestion from @MuS of the SEDCMDin props.conf:

SEDCMD-acctid = s/AcctID=\d{8}/AcctID=XXXXXXXX/g

View solution in original post

0 Karma

cpetterborg
SplunkTrust
SplunkTrust

At the very least your FORMAT has a problem. You only have one capture group in the text that I can see (though you may have put in more, and it has been formatted out because you didn't use the code formatting). It should be:

FORMAT = AcctID=XXXXXXXX$1

I would also use the suggestion from @MuS of the SEDCMDin props.conf:

SEDCMD-acctid = s/AcctID=\d{8}/AcctID=XXXXXXXX/g
0 Karma

MuS
Legend

Hi there,

as in the previous answer, while SEDCMD and the props/transforms approach can do the same at index time, the props/transforms way can also be used at search time. You write after indexing the data so this would be search time and therefore the props.conf should be REPORT-sample = anon_data instead of TRANSFORMS-sample = anon_data.

cheers, MuS

0 Karma

patricianaguit
Explorer

Thank you 🙂

0 Karma
Career Survey
First 500 qualified respondents will receive a $20 gift card! Tell us about your professional Splunk journey.

Can’t make it to .conf25? Join us online!

Get Updates on the Splunk Community!

Take Action Automatically on Splunk Alerts with Red Hat Ansible Automation Platform

 Are you ready to revolutionize your IT operations? As digital transformation accelerates, the demand for ...

Calling All Security Pros: Ready to Race Through Boston?

Hey Splunkers, .conf25 is heading to Boston and we’re kicking things off with something bold, competitive, and ...

Beyond Detection: How Splunk and Cisco Integrated Security Platforms Transform ...

Financial services organizations face an impossible equation: maintain 99.9% uptime for mission-critical ...