Deleting entries where last connection older 365 days

wow! v8.4.3 !?!?! and your first post!

We can cook up a script that uses the logs. Obviously we recommend a good backup before you run that script.

We will need time to identify your DB schema version and to create a DB of that version.

We have our quarterly meeting this morning, I hope we can respond tomorrow.

Best regards,

Thnx for answer.
Check this, please:
DELETE FROM [RDM].[dbo].[Connections]
WHERE ID IN
(SELECT DISTINCT ConnectionID FROM [RDM].[dbo].[ConnectionLog] WHERE CreationDate<'2019-04-15 23:59:59.999');

Hi,

Well this sub-select returns ALL logs, so for a connection you will have entries after AND before that date. You would need to select TOP 1 sorted by date...

Erica will provide the good script via private message

Hello,

I have sent you a private message that contains the SQL statement for your request.

Best regards,