find_latest_kernel.rb

def report
  rows = []
  Organization.all.each do |org|
    org.kt_environments.each do |env|
      env.content_view_versions.not_ignorable.each do |cvv|
        nvra = Katello::Rpm.latest(::Katello::Rpm.where(name: "kernel", id: cvv.packages)).first&.nvra
        if nvra
          rows << { organization: org.title, 
                    lifecycle_environment: env.label,
                    version: cvv.name,
                    nvra: nvra
                  }
        end      
      end
    end
  end
  rows
end

FYI, the shell script i came up with for Sat 6.10 - 6.13 i.e. https://gist.github.com/sayan3296/61a4d3efc1ba6a2f817dc6bc94b0dc14