Skip to content

Instantly share code, notes, and snippets.

Embed
What would you like to do?
LogParserRedactionSQL
SELECT
EventLog,
RecordNumber,
TimeGenerated,
TimeWritten,
EventID,
EventType,
EventTypeName,
EventCategory,
EventCategoryName,
SourceName,
REPLACE_STR(REPLACE_STR(REPLACE_STR(Strings,'OHOLICS','XXXXXXX'),'192.168.','X.X.'),'blog.oholics.net','blog.XXXXXXX.net'),
REPLACE_STR(REPLACE_STR(ComputerName,'OHOLICS','XXXXXXX'),'blog.oholics.net','blog.XXXXXXX.net'),
SID,
REPLACE_STR(REPLACE_STR(REPLACE_STR(Message,'OHOLICS','XXXXXXX'),'192.168.','X.X.'),'blog.oholics.net','blog.XXXXXXX.net'),
REPLACE_STR(REPLACE_STR(REPLACE_STR(Data,'OHOLICS','XXXXXXX'),'192.168.','X.X.'),'blog.oholics.net','blog.XXXXXXX.net')
INTO C:\TEMP\Output\OUTPUT.CSV
FROM C:\TEMP\Logs\*
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
You can’t perform that action at this time.