Forum Discussion

MarcR's avatar
MarcR
VIP
3 years ago

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 tim...
Methodology
Security
  • ckattookaran's avatar
    ckattookaran
    3 years ago

    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.

ckattookaran's avatar
ckattookaran
VIP
3 years ago

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.

  • NidhiMangtani's avatar
    NidhiMangtani
    Contributor III
    2 years ago

    Hi,

    How is user information being pulled here?

    • ckattookaran's avatar
      ckattookaran
      VIP
      2 years ago

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