Hi.
I would like to search and identify all entries that have been changed in a table through the admin interface vs. changes via apps. And preferably present the results in dashboard with constant monitoring.
I’ve got a tip from a Tulip engineer to possibly use automation for this purpose since there is no other way to monitor this. However, automations don’t support capturing change source metadata.
It would be a very valuable addition to automations if this was the case.
Thanks!
Hey @HCEH -
This is a new ask for me, and I’d love to dig into the details of what you’re looking to build.
Could you share a bit more about what you’re trying to use this logging for?
For instance:
Our automations are powerful, but as you noticed, they don’t currently capture that change source metadata. Understanding your specific end goal will help me see how we might better address this need.
Let me know your thoughts!
Pete
Thanks @Pete_Hartnett
As we are managing GxP data where there are certain regulatory requirements for being able to monitor the data change (audit trail), I would like to be notified if the critical data is changed without use of apps. This could be an unauthorised data-correction which we want to catch almost as it happens. It usually never is unauthorised, but we need a control in order to prove this.
User permissions can potentially solve this but still without prove. We would still need to perform a periodic check in order to confirm that no data-correction was performed without use of apps.
I hope it makes it more clear, otherwise please let me know.
@Pete_Hartnett Any thoughts about this?
Another case is that I would like to compare Date Updated (metadata) with a certain date for an entry (Review performed date). But since I cannot fetch metadata from Automations, this cannot be solved.