Description
To deep dive into a specific modification.
Query :
To deep dive into a specific modification.
Query :
select A.ModId,TableName,PrimaryKey,ActionTypeId,B.ColumnName,B.OldValue,B.NewValue,ModifiedOn,ModifiedByUserId,* from Security_ModLogRecord A with (nolock) full outer join Security_ModLogRecordDetail B with (nolock) on A.ModId=B.ModId where TableName = 'Security_User' and (ModifiedByUserId IN (select UserId from Security_User where username = 'Matt@bodyarmor')) and ModifiedOn >= '2025-02-05' --or (PrimaryKey = '52987' and ModifiedOn = '2022-01-31 19:12:00.290') --------------------------------------------------