Forum Discussion

2 Replies

  • suresh_klarna's avatar
    suresh_klarna
    New Contributor II

    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.

  • MarcusH's avatar
    MarcusH
    Valued Contributor

    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)