https://connect.hyland.com/t5/alfresco-forum/database-query-for-update-action-auditing/m-p/148123#M39181 <P>Hi All,</P><P>I have customized audit application according to our requirement and it is working fine and capturing necessary information. I have verified it through audit alfresco api. Now i have tried retrieving data from audit_entry and other prop_tables joining it. It is missing Date properties and some others and i can see it through PROP_Index values. Could anyone help me with SQL query to get all the entries related to audit entry</P><P>Thanks and Regards,</P><P>Piyush</P> Fri, 16 Jul 2021 06:16:37 GMT piyush48 2021-07-16T06:16:37Z https://connect.hyland.com/t5/alfresco-forum/database-query-for-update-action-auditing/m-p/148123#M39181 <P>Hi All,</P><P>I have customized audit application according to our requirement and it is working fine and capturing necessary information. I have verified it through audit alfresco api. Now i have tried retrieving data from audit_entry and other prop_tables joining it. It is missing Date properties and some others and i can see it through PROP_Index values. Could anyone help me with SQL query to get all the entries related to audit entry</P><P>Thanks and Regards,</P><P>Piyush</P> Fri, 16 Jul 2021 06:16:37 GMT https://connect.hyland.com/t5/alfresco-forum/database-query-for-update-action-auditing/m-p/148123#M39181 piyush48 2021-07-16T06:16:37Z