[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]