Skip to main content
MarcR
Contributor
Mar 29, 2022 6:55 AM UTC
Solved

Data Audit

Hi All, 

In OneStream there are many audit tables containing specific sections that can be audited. I'm looking for a detailed overall data audit showing which user changed which number at what time. Preferably combining loads with (Excel) input. Does anybody know which tables to join to get the good old HFM data audit table?

 

Thanks in advance, 

Marc

Member
Mar 30, 2022 4:01 PM UTC

Marc

I think two tables hold this information. Forms one is stored under DataEntryAuditCell, Workflow ones are under TaskflowStepLog (you need to query for the ones that got InstanceStatus of 2, and the StepKey is TaskflowStepDataItem.LoadCube.UniqueID.ToString. 

You might have to use the DataEntryAuditSource to get the user information.

3 replies

Member
Mar 30, 2022 4:01 PM UTC

Marc

I think two tables hold this information. Forms one is stored under DataEntryAuditCell, Workflow ones are under TaskflowStepLog (you need to query for the ones that got InstanceStatus of 2, and the StepKey is TaskflowStepDataItem.LoadCube.UniqueID.ToString. 

You might have to use the DataEntryAuditSource to get the user information.

Veteran
Mar 9, 2023 12:29 PM UTC

Hi,

How is user information being pulled here?

Member
Mar 14, 2023 5:22 PM UTC

you can join to DataEntryAuditSource  on AuditSourceID, that should get you user name and timestamp