Skip to main content
Solved

Cleanup dbo.use_log_usr_action in IAM

  • April 2, 2024
  • 1 reply
  • 48 views

htimmermans
Captain
Forum|alt.badge.img+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.

Best answer by Mark Jongeling

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! 

View original
Did this topic help you find an answer to your question?
This topic has been closed for comments

1 reply

Mark Jongeling
Administrator
Forum|alt.badge.img+23
  • Administrator
  • 3921 replies
  • Answer
  • April 2, 2024

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! 


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings