ModLog Table

select A.ModId,TableName,PrimaryKey,ActionTypeId,B.ColumnName,B.OldValue,B.NewValue,A.ModifiedOn,A.ModifiedByUserId,C.Username
from Security_ModLogRecord A with (nolock)
full outer join Security_ModLogRecordDetail B with (nolock) on A.ModId=B.ModId 
inner join Security_User C with (nolock) on C.UserId = A.ModifiedByUserId
where TableName = 'SceneType' and PrimaryKey in ('8537','8536','8548','8547') and ColumnName = 'SceneTypeCategory'


SELECT Scenetypeid,SceneTypeCategory,SceneTypeName,A.CreatedOn,A.CreatedByUserId,C.Username
FROM SceneType A
inner join Security_User C with (nolock) on C.UserId = A.CreatedByUserId
WHERE A.ClientId = 228 and SceneTypeId in ('8537','8536','8548','8547')
order by A.SceneTypeCode asc, A.SceneSubTypeCode



select A.ModId,TableName,PrimaryKey,ActionTypeId,B.ColumnName,B.OldValue,B.NewValue,
LEN(CONVERT(VARCHAR(MAX), B.NewValue)) AS NewValue_Len,A.ModifiedOn,A.ModifiedByUserId,C.Username
from Security_ModLogRecord A with (nolock)
full outer join Security_ModLogRecordDetail B with (nolock) on A.ModId=B.ModId 
inner join Security_User C with (nolock) on C.UserId = A.ModifiedByUserId
where TableName = 'Product' and PrimaryKey in ('1952464') and ColumnName = 'UPC'

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