I am new to Retool and website building. I recently subscribed to the "Business License" and noticed the audit logs feature that provides summaries of licensed user actions in Retool (like logins, app views, query runs in apps and workflows).
But, I have a few questions about this feature:
Can audit logs show failed execution records? If yes, how can I view them?
Is it possible to create custom audit logs with custom messages? Can these audit logs show more detailed information about triggers, such as:
Failure reasons
Execution time
Other relevant details
If audit logs can't provide this level of monitoring, what other features would you recommend for monitoring daily operations?
Many thanks!
There are a bunch of ways to do this and its depending on your set up. Are you all on-prem or cloud?
On-prem allows you to pull out audit_trail_events and query the sql table directly. (You can even make a little Retool app around this!)
You can use their default Audit log section and go through the queries for failed executions. (this is a bit tedious since Retool doesn't allow you to filter things deeply)
You could make some type of table that logs a failed query when it happens using the on failure event handler (pretty bad practice but might suffice for your usecase)
Hi @JoeyKarczewski
Thanks for your help! I'm using on-prem with MySQL, I'm interested in the audit trail events setup you mentioned (point 1& 3)
Could you please share me more details or documentation references about how to implement audit trail messages for button clicks and event handlers? I'd like to understand the specific steps to set this up.
Hi @JoeyKarczewski , would definitely be useful if you can send me your article, just been looking into exactly this. If it's live on the blog now, let me know and I'll have look there instead, cheers.
