Solved

Cleanup dbo.use_log_usr_action in IAM

  • 2 April 2024
  • 1 reply
  • 32 views

Userlevel 2
Badge +12

In our IAM database the table use_log_usr_action has grown to 12GB. Information in the table dates back to 2014 in our case. Models and branches in de log are long gone. So it would be great if there was a way to clean things up and create some free space.

The same question goes for table use_log_session. That one even goes back to 2012… 

I would like to see a cleanup flow in IAM or instructions here how te clean it up… I know Thinkwise uses these tables as well to determine the amount of users to calculate the license fee each year. But we don't need the information older then for instance two or three years.

icon

Best answer by Mark Jongeling 2 April 2024, 17:29

View original

1 reply

Userlevel 7
Badge +23

Hey Henri,

We happened to have written some Documentation about this here: IAM maintenance | Thinkwise Documentation (thinkwisesoftware.com).

The license fee calculation does not use these tables (anymore) so you don't have to worry about that. Hope this helps! 

Reply