Description field in activity log

ColemenWilson
ColemenWilson Coach
in Governance & Security

I need the information from the Description field in the activity log surfaced in a dataset. It isn't in the Domostats Activity Log. Anyone know where I can get this?

Screenshot 2025-06-04 at 1.22.34 PM.png

If I solved your problem, please select "yes" above

Tagged:

Best Answer

  • ArborRose
    ArborRose Coach
    Answer ✓

    There's also an API for audit. I tried using Python to connect but received an unauthorized response from the API. I'm checking with our rep to see if it needs to be exposed for use.

    ** Was this post helpful? Click Agree or Like below. **
    ** Did this solve your problem? Accept it as a solution! **

Answers

  • ArborRose
    ArborRose Coach

    Is it available in the Domo Governance Connector?

    ** Was this post helpful? Click Agree or Like below. **
    ** Did this solve your problem? Accept it as a solution! **

  • ColemenWilson
    ColemenWilson Coach

    @ArborRose Is this what you mean? If so, no Activity Log is not an available report.

    Screenshot 2025-06-04 at 2.34.32 PM.png

    If I solved your problem, please select "yes" above

  • ArborRose
    ArborRose Coach

    Yes, that's what I was thinking. Maybe its something Domo has to turn on for your instance?

    ** Was this post helpful? Click Agree or Like below. **
    ** Did this solve your problem? Accept it as a solution! **

  • ColemenWilson
    ColemenWilson Coach

    Do you have an activity log report using the Domo Governance Datasets Connector in your instance?

    If I solved your problem, please select "yes" above

  • ArborRose
    ArborRose Coach

    I did not see it but I'm not very familiar with it. Which is why I asked it as a question. I saw a web reference that said it might be there, but may need to be requested. I'm assuming you need to automate something vs export it to a csv.

    ** Was this post helpful? Click Agree or Like below. **
    ** Did this solve your problem? Accept it as a solution! **

  • DavidChurchman
    DavidChurchman Coach
    edited June 5

    In the "Activity Log" report from DomoStats, I don't get that exact field, but all of the information contained in that field are in it, split across columns. You could probably recreate that field without too much trouble:

    image.png image.png

    CONCAT(`Name`, ' ' , lower(`Action`), ' ',

    case

    when Object_Type = 'DATA_APP_VIEW' then 'app'

    …

    end,

    Object_Name, ' with id ', Object_ID, '.'

    )

    Please 💡/💖/👍/😊 this post if you read it and found it helpful.

    Please accept the answer if it solved your problem.

  • ArborRose
    ArborRose Coach
    Answer ✓

    There's also an API for audit. I tried using Python to connect but received an unauthorized response from the API. I'm checking with our rep to see if it needs to be exposed for use.

    ** Was this post helpful? Click Agree or Like below. **
    ** Did this solve your problem? Accept it as a solution! **

  • ColemenWilson
    ColemenWilson Coach

    @ArborRose thank you and yes please let me know!

    @DavidChurchman you won't be able to concat and recreate the field for user role changes, which is my need. In the Admin section Activity Log, I can see "Colemen Wilson changed John Does role from Social to Admin" That is the data I need to surface in a dataset.

    If I solved your problem, please select "yes" above

  • DavidChurchman
    DavidChurchman Coach

    Ah, I didn't test role changes.

    In the DomoStats Activity log, you can see "CHANGED_ROLE" and the "Object_ID" corresponds to the person whose role was changed. You can join that to the People DomoStats to see the person and their current role, but not what the role was changed from, which I'm guess is what you're after?

    If you can't figure anything else out, you could create a recursive ETL of the People DomoStats to figure out when roles change going into the future.

    Please 💡/💖/👍/😊 this post if you read it and found it helpful.

    Please accept the answer if it solved your problem.

Categories