Tuesday, November 12, 2013

Powershell with TM1Server.log

The tm1server.log is not the easiest thing to extract information from but contains golden nuggets of information.

Ideally you want to timestamp the tm1server.log after any restarts and then you can analyze a clean single session of information.

One of the easiest things you can do is use Windows powershell to then extract just the messages you want.

e.g. if i just want to explore the cube dependencies the server is producing then I just the following line within powershell

Get-Content .\tm1server.log | Where-Object {$_ -match 'TM1.Cube.Dependency'} | Set-Content tm1server.log-out.txt

You can alter the above statement to do any filtering you need