In my group, we have various workflows running to maintain report and dashboards at different frequencies. I had the idea to create a system status page where everyone who creates a production workflow would append this workflow container at the end of their workflow with some general information like:
- Alteryx server link
- Tableau dashboard link (if used to push data to tableau report)
- Frequency of schedule (daily, weekly, monthly)
- If monthly, day of month is should be refreshed
- Primary contact, secondary contact name and emails
- Friendly Name
From there I planned to take all of this and develop some logic to tract up-time, cadence, auto-email about failed workflows and have a tableau dashboard where anyone in our group can go and check the health of a report/dashboard they are using.
Similar to this: https://www.intercomstatus.com/
I've attached the template I'm building, but my question is how would you go about this? One thing I need as a standard response is the schedule (daily, weekly, monthly) and date of monthly refresh (1,2,3, etc). Would a macro work for this? Do those work on Alteryx server? Would you approach this the same way or have any other ideas on how to achieve this?
