I have an issue where I need to find all the hosts that belong to a particular hostgroup. I know of other ways of getting this information but it would require me to make a api call for each host which would take too long and possibly crash the server. I am looking for the following information:

puppethost, puppethost_id, hostgroup_id

Whats the best of of doing this?