We are working to implement audit and SOX controls in our TM1 v10.1 system via existing TM1 log files, but we are encountering several challenges - as follows:
Generating Log Reports:
- Audit Log: Unable to export more than 100 lines of data at a time (unacceptable)
- Transaction Log: Unable to copy/paste more than two days of transactions without crashing Excel (due to large volume of data)
Other Issues:
- TM1 Service must be stopped to access tm1s.log - is there an alternate method to get this file/data?
- Analysis of large volume of data is very challenging - need to identify certain types of events, such as security updates, data updates, outages, Admin activity, etc
- Ability to auto-generate log files via TI Process?
Any assistance/advice from someone addressing with similar issues is appreciated!
Thanks in advance!