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?
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.
Is it available in the Domo Governance Connector?
@ArborRose Is this what you mean? If so, no Activity Log is not an available report.
Yes, that's what I was thinking. Maybe its something Domo has to turn on for your instance?
Do you have an activity log report using the Domo Governance Datasets Connector in your instance?
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.
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:
CONCAT(`Name`, ' ' , lower(`Action`), ' ',
case
when Object_Type = 'DATA_APP_VIEW' then 'app'
Object_Type
…
end,
Object_Name, ' with id ', Object_ID, '.'
Object_Name
Object_ID
)
@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.
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.