How to create Report for List of Host by Host Collections

Support
1

Problem:
Trying to make reports an get emailed out Either by API or Foreman Email

Expected outcome:
List of Hosts by Host Collection
List for katello/sync_management status ( with result column)