report example

gistfile1.txt

foreman=# select * from hosts where name='servername.localdomain.com';
 id  |            name            |    last_compile     |     last_report     |         updated_at         |         created_at         | root_pass | architecture_id | operatingsystem_id | envir
onment_id | ptable_id | medium_id | build | comment | disk | installed_at | model_id | hostgroup_id | owner_id | owner_type | enabled | puppet_ca_proxy_id | managed | use_image | image_file | uu
id | compute_resource_id | puppet_proxy_id |          certname          | image_id | organization_id | location_id |     type      | otp | realm_id | compute_profile_id | provision_method | grub
_pass | global_status |      lookup_value_matcher       
-----+----------------------------+---------------------+---------------------+----------------------------+----------------------------+-----------+-----------------+--------------------+------
----------+-----------+-----------+-------+---------+------+--------------+----------+--------------+----------+------------+---------+--------------------+---------+-----------+------------+---
---+---------------------+-----------------+----------------------------+----------+-----------------+-------------+---------------+-----+----------+--------------------+------------------+-----
------+---------------+---------------------------------
 308 | servername.localdomain.com | 2015-12-29 13:31:47 | 2015-12-29 14:31:41 | 2015-12-29 14:32:28.610286 | 2015-12-28 19:37:18.976695 |           |               1 |                  1 |      
        1 |           |           | f     |         |      |              |        1 |              |          |            | t       |                    | f       |           |            |   
   |                     |                 | servername.localdomain.com |          |               5 |           1 | Host::Managed |     |          |                    |                  |     
      |             0 | fqdn=servername.localdomain.com
(1 row)

foreman=# select * from reports where id=159223;
   id   | host_id |     reported_at     |         created_at         |         updated_at         |  status   |                            metrics                             
--------+---------+---------------------+----------------------------+----------------------------+-----------+----------------------------------------------------------------
 159223 |     308 | 2015-12-29 14:31:41 | 2015-12-29 14:32:28.621189 | 2015-12-29 14:32:28.621189 | 385888256 | --- !ruby/hash:ActiveSupport::HashWithIndifferentAccess       +
        |         |                     |                            |                            |           | resources: !ruby/hash:ActiveSupport::HashWithIndifferentAccess+
        |         |                     |                            |                            |           |   changed: 0                                                  +
        |         |                     |                            |                            |           |   failed: 1                                                   +
        |         |                     |                            |                            |           |   failed_to_restart: 0                                        +
        |         |                     |                            |                            |           |   out_of_sync: 1                                              +
        |         |                     |                            |                            |           |   restarted: 0                                                +
        |         |                     |                            |                            |           |   scheduled: 0                                                +
        |         |                     |                            |                            |           |   skipped: 23                                                 +
        |         |                     |                            |                            |           |   total: 796                                                  +
        |         |                     |                            |                            |           | changes: !ruby/hash:ActiveSupport::HashWithIndifferentAccess  +
        |         |                     |                            |                            |           |   total: 0                                                    +
        |         |                     |                            |                            |           | time: !ruby/hash:ActiveSupport::HashWithIndifferentAccess     +
        |         |                     |                            |                            |           |   augeas: 0.375928                                            +
        |         |                     |                            |                            |           |   config_retrieval: 5.49310684204102                          +
        |         |                     |                            |                            |           |   cron: 0.002569                                              +
        |         |                     |                            |                            |           |   exec: 6.2911                                                +
        |         |                     |                            |                            |           |   file: 5.459231                                              +
        |         |                     |                            |                            |           |   file_line: 0.001009                                         +
        |         |                     |                            |                            |           |   filebucket: 0.00018                                         +
        |         |                     |                            |                            |           |   filesystem: 0.051045                                        +
        |         |                     |                            |                            |           |   firewall: 0.03401                                           +
        |         |                     |                            |                            |           |   host: 0.001586                                              +
        |         |                     |                            |                            |           |   ini_setting: 0.002046                                       +
        |         |                     |                            |                            |           |   logical_volume: 0.417199                                    +
        |         |                     |                            |                            |           |   mount: 0.008867                                             +
        |         |                     |                            |                            |           |   package: 2.481949                                           +
        |         |                     |                            |                            |           |   physical_volume: 0.262438                                   +
        |         |                     |                            |                            |           |   resources: 0.000197                                         +
        |         |                     |                            |                            |           |   schedule: 0.001726                                          +
        |         |                     |                            |                            |           |   service: 6.190083                                           +
        |         |                     |                            |                            |           |   sysctl: 0.653531                                            +
        |         |                     |                            |                            |           |   total: 28.232447842041                                      +
        |         |                     |                            |                            |           |   user: 0.0381050000000001                                    +
        |         |                     |                            |                            |           |   volume_group: 0.462999                                      +
        |         |                     |                            |                            |           |   yumrepo: 0.003543                                           +
        |         |                     |                            |                            |           | events: !ruby/hash:ActiveSupport::HashWithIndifferentAccess   +
        |         |                     |                            |                            |           |   failure: 1                                                  +
        |         |                     |                            |                            |           |   success: 0                                                  +
        |         |                     |                            |                            |           |   total: 1                                                    +
        |         |                     |                            |                            |           | 
(1 row)