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. |