delete log entries older than 30 days

delete log entries older than 30 days

avatar

Hi

Is there a possibility to remove log entries (usage log) older than 30 days automaticaly, for example? Do I need to create the delete job in RDM or in the database?

In case of RDM: Could you tell me the way, how and where I can create the job?

In case of database: Could you give me the name of the log-table? We have a MSSQL server in use.

Thank you in advance.

regards,

Aysun

All Comments (18)

avatar

Hello,

Please have a look at the following blog on the subject

http://blog.devolutions.net/2015/09/clean-up-time.html

Best regards,

Jeff Dagenais

avatar

Hello Jean,

is it possibile to delete the older log entries automatically in regular time? A Job in RDM or in the database, perhaps?

The blog describes the manual way to delete the log entries.

Thank you.

regards,

Aysun

avatar

For now it's not possible but that something we could add. I will enter a feature request.

Regards

David Hervieux

avatar

Hello,

any news regarding this feature?

regards,

Aysun

avatar

Hi,

This is not automated yet but that's something you could with a SQL Server SQL query executed on the server.

David Hervieux

avatar

Hello,

could you give me the correct Name of the database table (Usage Log)? I would delete the logs with a SQL query and I have to know the correct Name of tha database table. We use a SQL Server.

thank you.

regards,

Aysun

avatar

Hello Aysun,

It's possible to do this via the application directly by clicking on the Administration tab

You can also consult our blog on the subject

https://blog.devolutions.net/2015/09/clean-up-time.html

Best regards,

Jeff Dagenais

avatar

The delete logs function doesn't delete Activity Logs. I need a way to clear Activity Logs as well.

--------------------------------------------------------------------------------------------------------------------

I'm always using the latest beta RDM x64 version.

Local data source.

avatar

@Ricky,

As per the code, the logs should be deleted when you go in the Activity Logs and delete them.

What are you trying to delete exactly? Could you post some print screens.

Best regards,

Jeff Dagenais

avatar

Hi Jeff,

Sorry, but I'm not sure what you mean by "as per the code". I don't have access to your source code and do not work for your company, so I can't verify what the code is or what it's doing.

If I go into View -> Activity Logs, I see a bunch of entries (not shown below for privacy reasons):

There isn't a delete log or delete entry button under the Activity Logs tab. If I go into Administration -> Cleanup Logs, it doesn't delete the Activity Logs:

--------------------------------------------------------------------------------------------------------------------

I'm always using the latest beta RDM x64 version.

Local data source.

avatar

Hello,

In Administration - Cleanup Logs, you can delete the Activity logs but cannot delete the last 30 days of the activity.

Best regards,

Érica Poirier

avatar

As I have mentioned in my previous reply, If I go into Administration -> Cleanup Logs, it doesn't delete the Activity Logs. I can still see logs on February 5th 2018. I have set the "delete everything prior to this date" to today's date.

Also, why can't it delete anything past 30 days? I need to clear everything completely.

--------------------------------------------------------------------------------------------------------------------

I'm always using the latest beta RDM x64 version.

Local data source.

avatar

Hello Ricky,

I will check if I can find why it's limited. I don't think it's required and I think that we did that just as a safety.

Regards

David Hervieux

avatar

Have updated to the latest beta, which mentioned a change related to the cleanup logs. I thought that would have fixed my issue, but it hasn't. I'm cleaning up the logs as per my previous reply (and Erica's), yet I can still see log entries under Activity Logs.

--------------------------------------------------------------------------------------------------------------------

I'm always using the latest beta RDM x64 version.

Local data source.