host-checkin-report.rb

#!/usr/bin/ruby

require 'time'
require 'rest-client'
require 'json'
require 'yaml'
require 'mail'

url = 'https://satellite.mycompany.com'
foreman_url = "#{url}/api/v2"
katello_url = "#{url}/katello/api/v2/"

email_to = 'admin@mycompany.com'
username = 'admin'
password = 'mypassword'
expire = 864000

org_name = '{{ satellite_deployment_organization }}'

mailer_settings = YAML.load(File.read('/etc/foreman/email.yaml'))['production']
Mail.defaults do 
  delivery_method mailer_settings['delivery_method'], mailer_settings['smtp_settings'].inject({}){|memo,(k,v)| memo[k.to_sym] = v; memo}
end

# Performs a GET using the passed URL location
def get_json(location)
  response = RestClient::Request.new(
    :method => :get,
    :url => location,
    :user => username,
    :password => password,
    :headers => { :accept => :json,
    :content_type => :json }
  ).execute
  JSON.parse(response.to_str)
end

# Has the host checked in within ten days?
def too_late?(host)
  last = host.fetch('subscription_facet_attributes', {}).fetch('last_checkin', nil)
  if last.nil?
    true
  else
    Time.now.to_i - Time.parse(last).to_i > $expire.to_i
  end
end
 
def lineitem(host, style)
  red = "border: none; background-color: rgba(255, 99, 71, 0.5); padding: 8px; font-family: Arial, Helvetica, sans-serif"
  if too_late?(host)
    style = red
  end
  <<-"EOF"
    <tr>
      <td style="#{style}">#{host['name']}</td>
      <td style="#{style}">#{host.fetch('subscription_facet_attributes', {}).fetch('last_checkin', 'N/A')}</td>
      <td style="#{style}">#{host.fetch('content_facet_attributes', {}).fetch('errata_counts', {}).fetch('security', "N/A").to_s}</td>
      <td style="#{style}">#{host.fetch('content_facet_attributes', {}).fetch('errata_counts', {}).fetch('bugfix', "N/A").to_s}</td>
      <td style="#{style}">#{host.fetch('content_facet_attributes', {}).fetch('upgradable_package_count', "N/A").to_s}</td>
    </tr>
EOF
end

def table_def
  th_style = "border: none; background-color: DodgerBlue; color: white; font-size: 18px; font-family: Arial, Helvetica, sans-serif; texgt-align: center"
  <<-"EOF"
  <h1 style="font-family: Arial, Helvetica, sans-serif">Satellite Host Report</h1>
  <table style="border-collapse: collapse; width: 100%">
    <tr>
      <th style="#{th_style}">Host</th>
      <th style="#{th_style}">Last Checkin</th>
      <th style="#{th_style}">Security</th>
      <th style="#{th_style}">Bugfixes</th>
      <th style="#{th_style}">Upgradeable</th>
    </tr>
EOF
end

def table_end 
  "  </table>"
end

###### Do the things ######

grey = "border: none; background-color: #f2f2f2; padding: 8px; font-family: Arial, Helvetica, sans-serif"
nocolor = "border: none; padding: 8px; font-family: Arial, Helvetica, sans-serif"
hosts = get_json("#{foreman_url}/hosts")['results']
counter=0

body = table_def

hosts.each do |host|
  counter % 2 == 0 ? body.concat(lineitem(host, nocolor)) : body.concat(lineitem(host, grey))
  counter += 1
end

body.concat(table_end)

mail = Mail.new do
  from mailer_settings['smtp_settings']['user_name']
  to email_to
  subject "Satellite Host Report"

  text_part do
    body 'This message is in html format.'
  end

  html_part do
    content_type 'text/html; charset=UTF-8'
    body body
  end
end

mail.deliver!