Bug 1284679

Description of problem:
When we want to learn which compute resources are most used, we have to collect these data somewhere. Maybe foreman-debug can be used?


Version-Release number of selected component (if applicable):
foreman-debug-1.7.2.46-1.el6_6sat.noarch


How reproducible:
always


Steps to Reproduce:
1. Attempt to estimate which compute resources are used at most


Actual results:
There are no such data available


Expected results:
Maybe foreman debug can collect hosts counts per compute resource types (no customer internal info like concrete hosts or compute resource names)


Additional info:
Maybe something like this could be added to foreman-debug?

# diff -u `type -p foreman-debug `{.ORIG,}
--- /usr/sbin/foreman-debug.ORIG	2015-11-23 16:06:15.646949752 -0500
+++ /usr/sbin/foreman-debug	2015-11-23 16:28:59.070276247 -0500
@@ -270,6 +270,7 @@
 add_files /var/log/{httpd,apache2}/foreman-ssl_access_ssl.log*
 add_cmd "echo \"select id,name,value from settings where name not similar to '%(pass|key|secret)'\" | su postgres -c 'psql foreman'" "foreman_settings_table"
 add_cmd "echo 'select type,name,host,port,account,base_dn,attr_login,onthefly_register,tls from auth_sources' | su postgres -c 'psql foreman'" "foreman_auth_table"
+add_cmd "echo 'select count(hosts.name), compute_resources.type from hosts, compute_resources where hosts.compute_resource_id = compute_resources.id group by compute_resources.type;' | su postgres -c 'psql foreman'" "foreman_compute_resources_host_counts"
 add_cmd "foreman-selinux-relabel -nv" "foreman_filecontexts"
 
 add_files /etc/{sysconfig,default}/foreman