Chapter 12. Using report templates to monitor hosts

Procedure

1. In the Satellite web UI, navigate to Monitor > Reports > Report Templates. For example, the Host – Installed Products template generates a report with installed product information along with other metrics, including system purpose attributes.
2. To the right of the report template that you want to use, click Generate.
3. Optional: To schedule a report, to the right of the Generate at field, click the icon to select the date and time you want to generate the report at.
4. Optional: To send a report to an e-mail address, select the Send report via e-mail checkbox, and in the Deliver to e-mail addresses field, enter the required e-mail address.
5. Optional: Apply search query filters. To view all available results, do not populate the filter field with any values.
6. Click Submit. A CSV file that contains the report is downloaded. If you have selected the Send report via e-mail checkbox, the host monitoring report is sent to your e-mail address.

Procedure

1. List all available report templates:

   $ hammer report-template list

2. Generate a report:

   $ hammer report-template generate --id My_Template_ID

   This command waits until the report fully generates before completing. If you want to generate the report as a background task, you can use the hammer report-template schedule command.

Procedure

1. In the Satellite web UI, navigate to Monitor > Reports > Report Templates.
2. Click Create Template.
3. In the Name field, enter a unique name for your report template.
4. If you want the template to be available to all locations and organizations, select Default.
5. Create the template directly in the template editor or import a template from a text file by clicking Import. For more information about importing templates, see Section 12.7, “Importing report templates”.
6. Optional: In the Audit Comment field, you can add any useful information about this template.
7. Click the Input tab, and in the Name field, enter a name for the input that you can reference in the template in the following format: input('name'). Note that you must save the template before you can reference this input value in the template body.
8. Select whether the input value is mandatory. If the input value is mandatory, select the Required checkbox.
9. From the Value Type list, select the type of input value that the user must input.
10. Optional: If you want to use facts for template input, select the Advanced checkbox.
11. Optional: In the Options field, define the options that the user can select from. If this field remains undefined, the users receive a free-text field in which they can enter the value they want.
12. Optional: In the Default field, enter a value, for example, a host name, that you want to set as the default template input.
13. Optional: In the Description field, you can enter information that you want to display as inline help about the input when you generate the report.
14. Optional: Click the Type tab, and select whether this template is a snippet to be included in other templates.
15. Click the Location tab and add the locations where you want to use the template.
16. Click the Organizations tab and add the organizations where you want to use the template.
17. Click Submit to save your changes.

Procedure

1. In the Satellite web UI, navigate to Monitor > Reports > Report Templates.
2. Locate the template that you want to export, and from the list in the Actions column, select Export.
3. Repeat this action for every report template that you want to download.

Procedure

1. To view the report templates available for export, enter the following command:

   $ hammer report-template list

   Note the template ID of the template that you want to export in the output of this command.

2. To export a report template, enter the following command:

   $ hammer report-template dump --id My_Template_ID > example_export.erb

Procedure

1. Use the following request to retrieve a list of available report templates. For example:

   $ curl \
   --insecure \
   --user My_User_Name:My_Password \
   --request GET \
   --config https://satellite.example.com/api/report_templates \
   | json_reformat

   In this example, the json_reformat tool is used to format the JSON output.

   Example response:

   {
       "total": 6,
       "subtotal": 6,
       "page": 1,
       "per_page": 20,
       "search": null,
       "sort": {
           "by": null,
           "order": null
       },
       "results": [
           {
               "created_at": "2019-11-20 17:49:52 UTC",
               "updated_at": "2019-11-20 17:49:52 UTC",
               "name": "Applicable errata",
               "id": 112
           },
           {
               "created_at": "2019-11-20 17:49:52 UTC",
               "updated_at": "2019-11-20 17:49:52 UTC",
               "name": "Applied Errata",
               "id": 113
           },
           {
               "created_at": "2019-11-30 16:15:24 UTC",
               "updated_at": "2019-11-30 16:15:24 UTC",
               "name": "Hosts - complete list",
               "id": 158
           },
           {
               "created_at": "2019-11-20 17:49:52 UTC",
               "updated_at": "2019-11-20 17:49:52 UTC",
               "name": "Host statuses",
               "id": 114
           },
           {
               "created_at": "2019-11-20 17:49:52 UTC",
               "updated_at": "2019-11-20 17:49:52 UTC",
               "name": "Registered hosts",
               "id": 115
           },
           {
               "created_at": "2019-11-20 17:49:52 UTC",
               "updated_at": "2019-11-20 17:49:52 UTC",
               "name": "Subscriptions",
               "id": 116
           }
       ]
   }

2. Note the id of the template that you want to export, and use the following request to export the template.

   Example request:

   $ curl --insecure --output /tmp/_Example_Export_Template.erb_ \
   --user admin:password --request GET --config \
   https://satellite.example.com/api/report_templates/My_Template_ID/export

   Note that 158 is an example ID of the template to export.

   In this example, the exported template is redirected to host_complete_list.erb.

Procedure

1. In the Satellite web UI, navigate to Monitor > Reports > Report Templates.
2. In the upper right of the Report Templates window, click Create Template.
3. On the upper right of the Editor tab, click the folder icon, and select the .erb file that you want to import.
4. Edit the template to suit your requirements.
5. Click Submit.

Procedure

1. Use the following example to format the template that you want to import to a .json file:

   # cat Example_Template.json
   {
       "name": "Example Template Name",
       "template": "
       Enter ERB Code Here
   "
   }

   Example JSON file with ERB template:

   {
       "name": "Hosts - complete list",
       "template": "
   <%#
   name: Hosts - complete list
   snippet: false
   template_inputs:
   - name: host
     required: false
     input_type: user
     advanced: false
     value_type: plain
     resource_type: Katello::ActivationKey
   model: ReportTemplate
   -%>
   <% load_hosts(search: input('host')).each_record do |host| -%>
   <%
         report_row(
             'Server FQDN': host.name
         )
   -%>
   <%  end -%>
   <%= report_render %>
   "
   }

2. Use the following request to import the template:

   $ curl \
   --insecure \
   --user My_User_Name:My_Password \
   --data @Example_Template.json \
   --header "Content-Type:application/json" \
   --request POST \
   --config https://satellite.example.com/api/report_templates/import

3. Use the following request to retrieve a list of report templates and validate that you can view the template in Satellite:

   $ curl \
   --insecure \
   --user My_User_Name:My_Password \
   --request GET \
   --config https://satellite.example.com/api/report_templates | json_reformat