Integration Server 10.3 | Integration Server Administrator's Guide | Removing User Data from Integration Server | Removing Personal Data from Log Files | Removing Personally Identifiable Information from the Session Log
 
Removing Personally Identifiable Information from the Session Log
In the session log, the session audit record includes the user name and client IP address of the user making the connection to Integration Server. Where that data is located and how to remove it depends on whether the session log destination is a file or a database.
If the session log is a
Use the following to locate and delete user data
File
File Location: Software AG_directory \ Integration Server_directory \instances\instance_name\logs
File Name: WMSESSION_serverStartupTimestamp.log
userid is 64-characters long. It is logged from column 528.
ip-address from which the user made the connection is 128 characters. It is logged from column 593.
Use a text editor to perform a search and replace for the userid and client IP address. For example, you could search the session log files for the user name and replace the user name with an anonymous string or a blank string.
Database
If the Session audit logger is configured to log to an external database identified by the ISCoreAudit functional alias, Integration Server writes the log message into the WMSESSION table of the ISCoreAudit database.
The USERID column contains the userid.
The SESSIONNAME column contains the ip-address from which the user made the connection.
Use the following SQL statements to remove the data:
DELETE FROM WMSESSION WHERE USERID = 'username'
Where username is the user account to delete from the log.
DELETE FROM WMSESSION WHERE SESSIONNAME = 'ipAddress'
Where ipAddress is the client IP address to delete from the log.