Hello, I am trying to find a way to report on or export Discovery errors and their message, separated by schedule. I know I can view automation_error_msg to get the error information I need, but this table does not show the schedule. I need the errors to be separable by schedule like how you can view them in Discovery Admin Workspace > Diagnostics > select a schedule to view Discovery Errors > click into the type of error. The issue with the Discovery Admin Workspace, like other workspaces, is that there is no way to export any of the information.
I tried doing a database view to join automation_error_msg and discovery_device_history by the IP address that the error is occurring on so that I could get the schedule information, but this is really too large of a table and a mess. There are too many instances of each IP address on the Device table so there are tons of duplicates on the database view even after filtering on a specific error message.
Am I missing something? Is there an easier table to join with Automation Error Messages?
