Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

Audit Table Report - Using SQL Editor Instead


I'm trying to create a few quick adhocs to run in any of our models in BPC v10 MS, but I know the results are going to span several thousand records and the standard Web Console audit reports for Data are limited in the number of rows it will output.

Can someone tell me what the SQL would be to manually query the audit tables from BPC 10 MS, that would give user id, template submitted from and several other intersections of data like Category, Time, etc...

Thank you in advance,


Former Member

Hi Brian,

For the audit batch: [EnvironmentExtra].[dbo].[AuditHdrModel]

For the audit data: [EnvironmentExtra].[dbo].[AuditDataModel]


1 View this answer in context

Helpful Answer

Not what you were looking for? View more on this topic or Ask a question