How to report on refresh errors

[cottrera]

Hi , does anyone know if there is a way that I can report on all the datasets across all my workspaces to see if the daily refresh was successful or weather there was a refresh error.  

thank you

Richard

[Strangers]

Try to use this query

SELECT *
FROM ExecutionLog3
WHERE [TimeStart] > DATEADD(day, DATEDIFF(day, 0, GETDATE()), 0)
and [Status] <> 'rsSuccess'

[cottrera]

Hi thank you for responding so quickly. It looks like I made a mistake and posted on Report Server and not on Service.  Appologies 

Richard 😀