Forum Discussion

suresh_klarna's avatar
suresh_klarna
New Contributor III
2 months ago
Solved

Audit report for Load

Hi experts, Is there any audit report, to see Who did the Load ? When did it happen? What XML file is used to Load? I could not find it in the Navigation center? //Suresh
Application Properties
Metadata
Security
User Interface
  • MarcusH's avatar
    MarcusH
    2 months ago

    There isn't a separate audit table for loading XML files. The information is saved to the TaskActivity table though (this is in the Framework database). You can retrieve it like this:

    SELECT Description, UserName, AppName, StartTime, EndTime
FROM   TaskActivity
WHERE (AppName = 'myappname') AND (TaskActivityType = 15000)

     

suresh_klarna's avatar
suresh_klarna
New Contributor III
2 months ago

Thankyou MarcusH

It helps. Its unfortunate, that we need to build and it is not available as standard report.
It is needed to be SOX complaint.

sameburn's avatar
sameburn
Icon for OneStream Employee rankOneStream Employee
2 months ago

Hi suresh_klarna​

Depending on the type of xml loaded you are going to be updating different elements in onestream e.g metadata xml affects metadata only, workflow xml only affects workflows, etc

So depending on what xml you are loading will impact what elements you are checking audit history for

There are audit tables in onestream that capture all of these changes depending on what has been updated through xml load

This is what you need for audit and the Standard Application Reports solution on Solution Exchange covers audit reports based on this logic

Hope this helps clarify 

Sam