.XEL file format masking

[Premlal Digarse]

Dear Team,

We have a requirement to mask file with .XEL type.

This file is basically the Microsoft SQL Server Extended Event Log File where there are some account numbers which needs to be masked.

Please suggest if anyone has done such masking and does TDM tool support this kind of masking.

Regards

Prem

-------------------------------------------

[Rafael Cintra]

Hey Premlal,

I have not personally done .XEL file based masking before but it should be possible as long as you can read the file using SQL so you get XML content.

Once you get it to XML on a table some where you should be able to proceed with regular masking. You should also be able to use XML xpath to filter out your account numbers and mask them specifically as long as the structure allows it.

I don't have one file to test it right now but the SQL query to read it should be similar to:

SELECT object_name as EventName, CAST(event_data AS XML) as EventDataXML, timestamp_utc FROM sys.fn_xe_file_target_read_file('C:\Path\To\YourFiles\*.xel', null, null, null);

Thanks,

-------------------------------------------