Forum Discussion

ErickTr's avatar
ErickTr
New Contributor
9 months ago
Solved

Is that posible to export Task Activity or Error Logs with business rule?

Hi Team, I am wondering is that posible to export Error Logs or Task Activity with business rule?  I know we can extract data from cubes or dimensions using BRApi methods, but is there a similar ...
System
  • VRoig's avatar
    VRoig
    9 months ago

    Hi!

    You can do a query directly to the system database tables to get the information. They are called "ErrorLog" and "TaskActivity". Something like: Select * from ErrorLog.

    If you need some exemple let me know.

Henning's avatar
Henning
Valued Contributor II
9 months ago

Hi, I am not aware of an existing Api function that allows you to do that. If no one else knows one, you will have to pull the information from the corresponding tables and join them together.

Alternatively, you can extract both from the Systems tab if that suffices:

Solved: Extract_Data_System - OneStream Community (onestreamsoftware.com)

Depending on what you want to do with it, one can e.g. load the XML into Excel to filter the information in there. 
In Excel: Data >> Get Data >> From File >> From XML