Script to Select Audit Data from Database

Hi Everyone

Have you seen this when you select data from Audit table in Acumatica?

Acumatica stores all audit in one table Audit History. Keys and Changed fields are saved to database in combined mode. Data is concatenated with symbol , thats why you are not able to read this fields with just normal SQL server management studio.

To resolve it, you can replace special symbol just with normal colon. Use this script:

1 Reply to “Script to Select Audit Data from Database”

Leave a Reply

Your email address will not be published. Required fields are marked *