[Notification banner with admin inputtable text from Admins to users]

This is an quick and dirty fix but add this to "System Settings" -> Usage Tracking"

 

<script>

$(document).ready(function () {
    
    $("#BuildLabel").html( "My message" );

});

</script>

[Audit log not getting archived]

Hi,

 

Managed to solve it.

If the archiving service crashes while copyting data from audit to auditarchive tables it creates conflicts and the process crashes.

 

After removing the primarykey from auditarchive the archiving works as expected but I am getting duplicates.

The running:

 

WITH cte AS (SELECT[AuditID], [UserID], 2 row_number() OVER(PARTITION BY AuditID, UserID ORDER BY AuditID) AS [rn] 3 FROM [passwordstate].[dbo].[AuditingArchive] 4 )DELETE cte WHERE [rn] > 1

 

Cleans the table and I could re-enable the primary key in the archiving table.

 

 

 

[Audit log not getting archived]

Hi,

 

We have an problem that our audit log isn't getting archived:

 

Our setting is defined so it should archive after 2 million rows.

 

I havn't seen anything in the logs regarding this.

Any pointers of where to look?