I've been given the task of creating a dashboard that includes the success rate of jobs submitted to WFA and a breakout of failures by job type. It appears there isn't a pre-made command to achieve this and the wfa user doesn't have enough access to the WFA database to pull out this information.
Can I get the root password to the WFA database to pull this out of the right tables? Or is there another method to get this information?
I saw somebody post that they backed up the database and then restored to a SQL database they had root privileges for, but that doesn't really sound like a repeatable process on a weekly basis.