• [font="Courier New"]my alter ego replying to my own question:

    I actually found a couple of work arounds to view the SS 2012 SSIS "All Executions" report.

    1. modify 2 views -- using this solution: http://sqlwriter.blogspot.com/2013/12/ssiscatalog-report-execution-permission.html --- this is what we opted to use which is described here:

    SSIS Catalog "All Executions" Report permission

    SSIS developers who do not have ssis_admin access are given db_datareader to SSISDB and public role to server. Still they are not able to view ssis execution reports in SSIS Catalog because ssis_Admin access is required to view them. The access right is limited in Catalog views by Microsoft.

    To fix the issues, ALTER the following views in SSIS catalog.

    · Catalog.event_messages

    · Catalog.executions

    To alter catalog.event_messages and catalog.executions, click on script view as > alter to > new query editor window.

    Then, comment out the following part of the script.

    --comment it to give access to reports

    --WHERE opmsg.[operation_id] in (SELECT [id] FROM [internal].[current_user_readable_operations])

    -- OR (IS_MEMBER('ssis_admin') = 1)

    -- OR (IS_SRVROLEMEMBER('sysadmin') = 1)

    After updating views, developer can view executions and drill down messages. Connect to server and you can be able to view reports.

    2. deploy a canned set of SSRS reports (requires data source to connect to SSISDB using sa / acct pwd) described here: https://ssisreportingpack.codeplex.com/ --- we've deployed this. cool set of reports[/font]

    BT