Gathering Transaction Data Statistics done by Employee/Manager/HR
SummaryWe need to get a report to quantify the number transaction done by Employee, Manager, HR.
We are trying to figure out the number of transactions done by Employee, Manager, HR in a given time period. We do not have audit enabled for all the transactions. By referring the individual table last update by will lead to incorrect results since it will always be overridden by the last transaction.
Is there a better way to address this requirement?