Post reply

Ideas

  • January 26, 2015 at 9:11 am

    #294737

    Has anyone implemented a dashboard that checks on other dashboards or reports and flags accordingly.So we can fix our own reports before anyone else points out....

    If Yes. What should we typically look for in such cases.

  • January 26, 2015 at 5:15 pm

    #1773268

    In my office I've written an AJAX webpage that updates every 60 seconds, and checks the ReportServer database tabless of our report servers for report executions (automated report subscriptions and manual report executions) that have failed within the last 24 hours, showing at the top of the list in large font, red, and moving to 11pt normal as time goes on. This is displayed on a monitor in my office, and makes it very easy to see when a report has failed.

    This has allowed me to see that a report failure has occurred before I receive a helpdesk ticket, often before a user notices (in the case of missing nightly subscriptions).

    The bottom is kindof irrelevant - this has a table of tasks that are expected on a routine basis, and a table of task completion notifications, and the dashboard identifies from the expected details whether a task was logged as completed before it was expected.

    I also have a couple of reports I check if an issue has occurred, one showing report executions by report, and the other by username - these are usually more help when someone asks for the "report they run on the first of the month" when there's more than 400 reports in our reporting system, or evaluating a report's value to the business:

    If you're looking for a system to automatically go through and test your reports on routine, I'm not sure of any, and that would be quite a bit harder to maintain.

    To directly answer your question - watch the ReportServer.dbo.ExecutionLogStorage table for entries that have a Status as not "rsSuccess". If you thought it was worth it, you could also check the ReportServer.dbo.DataSource table for any entries where ItemID = ReportServer.dbo.Catalog.ItemID and DataSource.Link IS NULL. Any matching entries would likely tell you the relevant report has an invalid data source (e.g. a shared data source has been deleted).

  • January 27, 2015 at 1:42 pm

    #1773505

    Thank you so much for your valuable input.

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply