View all PE activity service events without the GUI

view_all_activites.sql

select
  ec.submit_time,
  s.subject_name,
  o.object_name,
  e.message
from event_commits ec
left join events e on ec.id = e.commit_id
left join subject_digests s on s.id = ec.subject_digest_id
left join object_digests o on ec.object_digest_id = o.id
order by ec.submit_time desc limit 10;

/*
[root@master ~]# sudo -u pe-postgres /opt/puppetlabs/server/bin/psql pe-activity < activity.sql
        submit_time         | subject_name |      object_name      |                                        message
----------------------------+--------------+-----------------------+----------------------------------------------------------------------------------------
 2017-04-06 17:00:57.075+00 | admin        | Apps Dev apps_process | Deleted the "Apps Dev apps_process" group with id ceca709b-1d8e-45b3-98e5-e00260649ec4
 2017-04-06 16:39:37.634+00 | admin        | admin                 | User Administrator (42bf351c-f9ec-40af-84ad-e976fec7f4bd) logged in.
 2017-04-04 21:14:41.776+00 | admin        | admin                 | User Administrator (42bf351c-f9ec-40af-84ad-e976fec7f4bd) logged in.
 2017-04-04 04:33:36.68+00  | api_user     | Apps Dev apps_process | Added the "apps_build" parameter to the "profiles::apps" class
 2017-04-04 04:33:36.68+00  | api_user     | Apps Dev apps_process | Added the "apps_version" parameter to the "profiles::apps" class
 2017-04-04 04:33:36.68+00  | api_user     | Apps Dev apps_process | Added the "apps_release" parameter to the "profiles::apps" class
 2017-04-04 04:33:36.569+00 | api_user     | Apps Dev sso          | Added the "apps_build" parameter to the "profiles::apps" class
 2017-04-04 04:33:36.569+00 | api_user     | Apps Dev sso          | Added the "apps_version" parameter to the "profiles::apps" class
 2017-04-04 04:33:36.569+00 | api_user     | Apps Dev sso          | Added the "apps_release" parameter to the "profiles::apps" class
 2017-04-04 04:33:36.454+00 | api_user     | Apps Dev scheduler    | Added the "apps_build" parameter to the "profiles::apps" class
(10 rows)
*/