We have a requirement to fetch the faulted task details every 15 minutes and send out an email notification to the team with faulted task details. Do we have a sql query available to fetch the faulted task details?
Here is a helpful link - ActiveVOS Database Table Descriptions
Please refer the KB article #527410
Please check AeProcess table, 4 is the values for Faulted Tasks.
Retrieving data ...