Plugins » Katello » Hammer CLI CSV

  require 'hammer_cli_csv/content_hosts'

  require 'hammer_cli_csv/host_collections'

                                                   'organization_id' => organization['id']

                                                 })['results'].each do |activationkey|

              hostcollections = export_column(activationkey, 'systemGroups', 'name')

                      hostcollections, subscriptions]

                                       'organization_id' => foreman_organization(:name => line[ORGANIZATION])

            @api.resource(:host_collections).call(:add_activation_keys, {

                                                     'id' => katello_hostcollection(line[ORGANIZATION], :name => name),

                                                        'organization_id' => foreman_organization(:name => organization),

                                               'organization_id' => foreman_organization(:name => organization)

                                                         'organization_id' => foreman_organization(:name => organization),

    def katello_hostcollection(organization, options = {})

      @hostcollections ||= {}

      @hostcollections[organization] ||= {}

        options[:id] = @hostcollections[organization][options[:name]]

          @api.resource(:host_collections).call(:index,

                    'organization_id' => foreman_organization(:name => organization),

                  })['results'].each do |hostcollection|

            @hostcollections[organization][hostcollection['name']] = hostcollection['id'] if hostcollection

          options[:id] = @hostcollections[organization][options[:name]]

        options[:name] = @hostcollections.key(options[:id])

          hostcollection = @api.resource(:host_collections).call(:show, {'id' => options[:id]})

          raise "System group '#{options[:name]}' not found" if !hostcollection || hostcollection.empty?

          options[:name] = hostcollection['name']

          @hostcollections[options[:name]] = options[:id]

# Copyright 2013-2014 Red Hat, Inc.

#

# This software is licensed to you under the GNU General Public

# License as published by the Free Software Foundation; either version

# 2 of the License (GPLv2) or (at your option) any later version.

# There is NO WARRANTY for this software, express or implied,

# including the implied warranties of MERCHANTABILITY,

# NON-INFRINGEMENT, or FITNESS FOR A PARTICULAR PURPOSE. You should

# have received a copy of GPLv2 along with this software; if not, see

# http://www.gnu.org/licenses/old-licenses/gpl-2.0.txt.

#

# -= Systems CSV =-

#

# Columns

#   Name

#     - System name

#     - May contain '%d' which will be replaced with current iteration number of Count

#     - eg. "os%d" -> "os1"

#   Count

#     - Number of times to iterate on this line of the CSV file

#   MAC Address

#     - MAC address

#     - May contain '%d' which will be replaced with current iteration number of Count

#     - eg. "FF:FF:FF:FF:FF:%02x" -> "FF:FF:FF:FF:FF:0A"

#     - Warning: be sure to keep count below 255 or MAC hex will exceed limit

#

require 'hammer_cli'

require 'json'

require 'csv'

require 'uri'

module HammerCLICsv

  class CsvCommand

    class ContentHostsCommand < BaseCommand

      command_name 'content-hosts'

      desc         'import or export content hosts'

      ORGANIZATION = 'Organization'

      ENVIRONMENT = 'Environment'

      CONTENTVIEW = 'Content View'

      HOSTCOLLECTIONS = 'Host Collections'

      VIRTUAL = 'Virtual'

      HOST = 'Host'

      OPERATINGSYSTEM = 'OS'

      ARCHITECTURE = 'Arch'

      SOCKETS = 'Sockets'

      RAM = 'RAM'

      CORES = 'Cores'

      SLA = 'SLA'

      PRODUCTS = 'Products'

      SUBSCRIPTIONS = 'Subscriptions'

      def export

        CSV.open(option_csv_file || '/dev/stdout', 'wb', {:force_quotes => false}) do |csv|

          csv << [NAME, COUNT, ORGANIZATION, ENVIRONMENT, CONTENTVIEW, HOSTCOLLECTIONS, VIRTUAL, HOST,

                  OPERATINGSYSTEM, ARCHITECTURE, SOCKETS, RAM, CORES, SLA, PRODUCTS, SUBSCRIPTIONS]

          @api.resource(:organizations).call(:index, {:per_page => 999999})['results'].each do |organization|

            @api.resource(:systems).call(:index, {

                                  'per_page' => 999999,

                                  'organization_id' => foreman_organization(:name => organization['name'])

                                 })['results'].each do |system|

              system = @api.resource(:systems).call(:show, {

                                            'id' => system['uuid'],

                                            'fields' => 'full'

                                          })

              name = system['name']

              count = 1

              organization_name = organization['name']

              environment = system['environment']['label']

              contentview = system['content_view']['name']

              hostcollections = CSV.generate do |column|

                column << system['systemGroups'].collect do |hostcollection|

                  hostcollection['name']

                end

              end

              hostcollections.delete!("\n")

              virtual = system['facts']['virt.is_guest'] == 'true' ? 'Yes' : 'No'

              host = system['host']

              operatingsystem = "#{system['facts']['distribution.name']} " if system['facts']['distribution.name']

              operatingsystem += system['facts']['distribution.version'] if system['facts']['distribution.version']

              architecture = system['facts']['uname.machine']

              sockets = system['facts']['cpu.cpu_socket(s)']

              ram = system['facts']['memory.memtotal']

              cores = system['facts']['cpu.core(s)_per_socket']

              sla = ''

              products = CSV.generate do |column|

                column << system['installedProducts'].collect do |product|

                  "#{product['productId']}|#{product['productName']}"

                end

              end

              products.delete!("\n")

              subscriptions = CSV.generate do |column|

                column << @api.resource(:subscriptions).call(:index, {

                                                      'system_id' => system['uuid']

                                                    })['results'].collect do |subscription|

                  "#{subscription['product_id']}|#{subscription['product_name']}"

                end

              end

              subscriptions.delete!("\n")

              csv << [name, count, organization_name, environment, contentview, hostcollections, virtual, host,

                      operatingsystem, architecture, sockets, ram, cores, sla, products, subscriptions]

            end

          end

        end

      end

      def import

        @existing = {}

        @host_guests = {}

        thread_import do |line|

          create_systems_from_csv(line)

        end

        print 'Updating host and guest associations...' if option_verbose?

        @host_guests.each do |host_id, guest_ids|

          @api.resource(:systems).call(:update, {

                                 'id' => host_id,

                                 'guest_ids' => guest_ids

                               })

        end

        puts 'done' if option_verbose?

      end

      def create_systems_from_csv(line)

        if !@existing[line[ORGANIZATION]]

          @existing[line[ORGANIZATION]] = {}

          @api.resource(:systems).call(:index, {

                                'organization_id' => foreman_organization(:name => line[ORGANIZATION]),

                                'page_size' => 999999})['results'].each do |system|

            @existing[line[ORGANIZATION]][system['name']] = system['uuid'] if system

          end

        end

        line[COUNT].to_i.times do |number|

          name = namify(line[NAME], number)

          # TODO w/ @daviddavis p-r

          #subscriptions(line).each do |subscription|

          #  katello_subscription(line[ORGANIZATION], :name => subscription[:number])

          #end

          if !@existing[line[ORGANIZATION]].include? name

            print "Creating system '#{name}'..." if option_verbose?

            system_id = @api.resource(:systems).call(:create, {

                                                       'name' => name,

                                                       'organization_id' => foreman_organization(:name => line[ORGANIZATION]),

                                                       'environment_id' => katello_environment(line[ORGANIZATION], :name => line[ENVIRONMENT]),

                                                       'content_view_id' => katello_contentview(line[ORGANIZATION], :name => line[CONTENTVIEW]),

                                                       'facts' => facts(name, line),

                                                       'installed_products' => products(line),

                                                       'type' => 'system'

                                                     })['uuid']

            @existing[line[ORGANIZATION]][name] = system_id

          else

            print "Updating system '#{name}'..." if option_verbose?

            system_id = @api.resource(:systems).call(:update, {

                                                       'id' => @existing[line[ORGANIZATION]][name],

                                                       'system' => {

                                                         'name' => name,

                                                         'environment_id' => katello_environment(line[ORGANIZATION], :name => line[ENVIRONMENT]),

                                                         'content_view_id' => katello_contentview(line[ORGANIZATION], :name => line[CONTENTVIEW]),

                                                         'facts' => facts(name, line),

                                                         'installed_products' => products(line)

                                                       }

                                                     })['uuid']

          end

          if line[VIRTUAL] == 'Yes' && line[HOST]

            raise "Host system '#{line[HOST]}' not found" if !@existing[line[ORGANIZATION]][line[HOST]]

            @host_guests[@existing[line[ORGANIZATION]][line[HOST]]] ||= []

            @host_guests[@existing[line[ORGANIZATION]][line[HOST]]] << system_id

          end

          set_host_collections(system_id, line)

          puts 'done' if option_verbose?

        end

      rescue RuntimeError => e

        raise "#{e}\n       #{line}"

      end

      private

      def facts(name, line)

        facts = {}

        facts['cpu.core(s)_per_socket'] = line[CORES]

        facts['cpu.cpu_socket(s)'] = line[SOCKETS]

        facts['memory.memtotal'] = line[RAM]

        facts['uname.machine'] = line[ARCHITECTURE]

        if line[OPERATINGSYSTEM].index(' ')

          (facts['distribution.name'], facts['distribution.version']) = line[OPERATINGSYSTEM].split(' ')

        else

          (facts['distribution.name'], facts['distribution.version']) = ['RHEL', line[OPERATINGSYSTEM]]

        end

        facts['virt.is_guest'] = line[VIRTUAL] == 'Yes' ? true : false

        facts['virt.uuid'] = "#{line[ORGANIZATION]}/#{name}" if facts['virt.is_guest']

        facts

      end

      def set_host_collections(system_id, line)

        CSV.parse_line(line[HOSTCOLLECTIONS]).each do |hostcollection_name|

          @api.resource(:host_collections).call(:add_systems, {

                                                  'id' => katello_hostcollection(line[ORGANIZATION], :name => hostcollection_name),

                                                  'system_ids' => [system_id]

                                                })

        end

      end

      def products(line)

        return nil if !line[PRODUCTS]

        products = CSV.parse_line(line[PRODUCTS]).collect do |product_details|

          product = {}

          # TODO: these get passed straight through to candlepin; probably would be better to process in server

          #       to allow underscore product_id here

          (product['productId'], product['productName']) = product_details.split('|')

          product

        end

        products

      end

      def subscriptions(line)

        return nil if !line[SUBSCRIPTIONS]

        subscriptions = CSV.parse_line(line[SUBSCRIPTIONS]).collect do |subscription_details|

          subscription = {}

          (subscription[:number], subscription[:name]) = subscription_details.split('|')

          subscription

        end

        subscriptions

      end

    end

  end

end

# Copyright 2013-2014 Red Hat, Inc.

#

# This software is licensed to you under the GNU General Public

# License as published by the Free Software Foundation; either version

# 2 of the License (GPLv2) or (at your option) any later version.

# There is NO WARRANTY for this software, express or implied,

# including the implied warranties of MERCHANTABILITY,

# NON-INFRINGEMENT, or FITNESS FOR A PARTICULAR PURPOSE. You should

# have received a copy of GPLv2 along with this software; if not, see

# http://www.gnu.org/licenses/old-licenses/gpl-2.0.txt.

#

# -= System Groups CSV =-

#

# Columns

#   Name

#     - System group name

#     - May contain '%d' which will be replaced with current iteration number of Count

#     - eg. "group%d" -> "group1"

#   Count

#     - Number of times to iterate on this line of the CSV file

#   Org Label

#   Limit

#   Description

#

require 'hammer_cli'

require 'json'

require 'csv'

module HammerCLICsv

  class CsvCommand

    class HostCollectionsCommand < BaseCommand

      command_name 'host-collections'

      desc         'import or export host collections'

      ORGANIZATION = 'Organization'

      LIMIT = 'Limit'

      DESCRIPTION = 'Description'

      def export

        CSV.open(option_csv_file, 'wb') do |csv|

          csv << [NAME, COUNT, ORGANIZATION, LIMIT, DESCRIPTION]

          @api.resource(:organizations).call(:index, {'per_page' => 999999})['results'].each do |organization|

            @api.resource(:host_collections).call(:index, {'organization_id' => organization['id']}).each do |hostcollection|

              puts hostcollection

              csv << [hostcollection['name'], 1, organization['id'],

                      hostcollection['max_systems'].to_i < 0 ? 'Unlimited' : sytemgroup['max_systems'],

                      hostcollection['description']]

            end

          end

        end

      end

      def import

        @existing = {}

        thread_import do |line|

          create_hostcollections_from_csv(line)

        end

      end

      def create_hostcollections_from_csv(line)

        if !@existing[line[ORGANIZATION]]

          @existing[line[ORGANIZATION]] = {}

          @api.resource(:host_collections).call(:index, {

                                                  'per_page' => 999999,

                                                  'organization_id' => foreman_organization(:name => line[ORGANIZATION])

                                                })['results'].each do |hostcollection|

            @existing[line[ORGANIZATION]][hostcollection['name']] = hostcollection['id']

          end

        end

        line[COUNT].to_i.times do |number|

          name = namify(line[NAME], number)

          if !@existing[line[ORGANIZATION]].include? name

            print "Creating system group '#{name}'..." if option_verbose?

            @api.resource(:host_collections).call(:create, {

                                      'organization_id' => foreman_organization(:name => line[ORGANIZATION]),

                                      'name' => name,

                                      'max_systems' => (line[LIMIT] == 'Unlimited') ? -1 : line[LIMIT],

                                      'description' => line[DESCRIPTION]

                                    })

          else

            print "Updating system group '#{name}'..." if option_verbose?

            @api.resource(:host_collections).call(:update, {

                                        'organization_id' => line[ORGANIZATION],

                                        'id' => @existing[line[ORGANIZATION]][name],

                                        'name' => name,

                                        'max_systems' => (line[LIMIT] == 'Unlimited') ? -1 : line[LIMIT],

                                        'description' => line[DESCRIPTION]

                                      })

          end

      print "done\n" if option_verbose?

        end

      end

    end

  end

end

      option '--locations', 'FILE', 'source to import locations'

      option '--puppet-environments', 'FILE', 'source to puppet environments'

      option '--operating-systems', 'FILE', 'source to operating systems'

      option '--architectures', 'FILE', 'source to architectures'

      option '--domains', 'FILE', 'source to domains'

      option '--architectures', 'FILE', 'source to architectures'

      option '--partition-tables', 'FILE', 'source to partition-tables'

        %w( organizations locations roles users puppet_environments operating_systems

            hosts domains architectures partition_tables ).each do |resource|

          swing(resource)

        end

        return if !self.send("option_#{resource}") && !option_dir

        options_file = self.send("option_#{resource}") || "#{option_dir}/#{resource.sub('_', '-')}.csv"

        raise "File for #{resource} '#{options_file}' does not exist" unless File.exists? options_file

        args = %W{ csv #{resource.sub('_', '-')} --csv-file #{options_file} }

        hammer.run(args)

                                       'organization_id' => organization['id']

                                     'organization_id' => foreman_organization(:name => organization['name']),

                                        'organization_id' => foreman_organization(:name => line[ORGANIZATION]),

                                        'organization_id' => foreman_organization(:name => line[ORGANIZATION]),

          @existing[organization['name']] = organization['id'] if organization

#     - organizations, environments, activation_keys, host_collections, providers, users, roles,

#     host_collections - create, delete, delete_systems, update, update_systems, read, read_systems

        # {"all_tags"=>false, "all_verbs"=>false, "created_at"=>"2013-11-11T02:31:23Z", "description"=>"and it's description!", "id"=>12, "name"=>"Accounting System Group Modify Systems", "organization_id"=>2, "resource_type_id"=>5, "role_id"=>124, "updated_at"=>"2013-11-11T02:31:23Z", "tags"=>[{"created_at"=>"2013-11-11T02:31:23Z", "formatted"=>{"name"=>6, "display_name"=>"Accounting"}, "id"=>2, "permission_id"=>12, "tag_id"=>6, "updated_at"=>"2013-11-11T02:31:23Z"}], "verbs"=>[{"created_at"=>"2013-11-07T19:44:45Z", "id"=>7, "updated_at"=>"2013-11-07T19:44:45Z", "verb"=>"update_systems"}], "resource_type"=>{"created_at"=>"2013-11-07T16:36:56Z", "id"=>5, "name"=>"host_collections", "updated_at"=>"2013-11-07T16:36:56Z"}}

                                            'organization_id' => foreman_organization(:name => organization['name'])

                                 'organization_id' => foreman_organization(:name => line[ORGANIZATION]),

                                        'organization_id' => foreman_organization(:name => line[ORGANIZATION]),

                                                 'organization_id' => foreman_organization(:name => line[ORGANIZATION]),

                                                'organization_id' => foreman_organization(:name => line[ORGANIZATION]),

                                                  'organization_id' => foreman_organization(:name => line[ORGANIZATION]),

                                         'organization_id' => foreman_organization(:name => line[ORGANIZATION]),

            #                                               'organization_id' => foreman_organization(:name => line[ORGANIZATION]),

                                  'organization_id' => organization['id']

              hostcollections = CSV.generate do |column|

                column << system['systemGroups'].collect do |hostcollection|

                  hostcollection['name']

              csv << [name, count, organization_label, environment, contentview, hostcollections, virtual, host,

          set_host_collections(system_id, line)

      def set_host_collections(system_id, line)

        CSV.parse_line(line[SYSTEMGROUPS]).each do |hostcollection_name|

          @api.resource(:hostcollections).call(:add_systems, {

                                           'id' => katello_hostcollection(line[ORGANIZATION], :name => hostcollection_name),

Name,Count,Organization,Description,Limit,Environment,Content View,Host Collections,Subscriptions

damon.dials@megacorp.com,1,Mega Corporation,"Individual account",1,Library,Default Organization View,"Employee","""RH00004|Red Hat Enterprise Linux Server, Standard (Physical or Virtual Nodes)"""

jenee.jahns@megacorp.com,1,Mega Corporation,"Individual account",1,Library,Default Organization View,"Employee"

gilbert.guerriero@megacorp.com,1,Mega Corporation,"Individual account",1,Library,Default Organization View,"Employee"

quiana.quesnel@megacorp.com,1,Mega Corporation,"Individual account",1,Library,Default Organization View,"Employee"

bernard.bigler@megacorp.com,1,Mega Corporation,"Individual account",1,Library,Default Organization View,"Employee"

marietta.menzel@megacorp.com,1,Mega Corporation,"Individual account",1,Library,Default Organization View,"Employee"

ruby.rieser@megacorp.com,1,Mega Corporation,"Individual account",1,Library,Default Organization View,"Employee"

leonor.limberg@megacorp.com,1,Mega Corporation,"Individual account",1,Library,Default Organization View,"Employee"

herminia.hochmuth@megacorp.com,1,Mega Corporation,"Individual account",1,Library,Default Organization View,"Employee"

luana.larson@megacorp.com,1,Mega Corporation,"Individual account",1,Library,Default Organization View,"Employee"

gilda.gutirrez@megacorp.com,1,Mega Corporation,"Individual account",1,Library,Default Organization View,"Employee"

karlene.kirch@megacorp.com,1,Mega Corporation,"Individual account",1,Library,Default Organization View,"Employee"

chelsea.calaway@megacorp.com,1,Mega Corporation,"Individual account",1,Library,Default Organization View,"Employee"

tajuana.thies@megacorp.com,1,Mega Corporation,"Individual account",1,Library,Default Organization View,"Employee"

dominica.dubberly@megacorp.com,1,Mega Corporation,"Individual account",1,Library,Default Organization View,"Employee"

gregg.gault@megacorp.com,1,Mega Corporation,"Individual account",1,Library,Default Organization View,"Employee"

boyd.buckle@megacorp.com,1,Mega Corporation,"Individual account",1,Library,Default Organization View,"Employee"

georgeanna.griffiths@megacorp.com,1,Mega Corporation,"Individual account",1,Library,Default Organization View,"Employee"

julio.jerabek@megacorp.com,1,Mega Corporation,"Individual account",1,Library,Default Organization View,"Employee"

chaya.cordova@megacorp.com,1,Mega Corporation,"Individual account",1,Library,Default Organization View,"Employee"

reinaldo.reardon@megacorp.com,1,Mega Corporation,"Individual account",1,Library,Default Organization View,"Employee"

nancie.nassar@megacorp.com,1,Mega Corporation,"Individual account",1,Library,Default Organization View,"Employee"

ayako.alday@megacorp.com,1,Mega Corporation,"Individual account",1,Library,Default Organization View,"Employee"

skye.strobl@megacorp.com,1,Mega Corporation,"Individual account",1,Library,Default Organization View,"Employee"

merle.miceli@megacorp.com,1,Mega Corporation,"Individual account",1,Library,Default Organization View,"Employee"

sung.skipper@megacorp.com,1,Mega Corporation,"Individual account",1,Library,Default Organization View,"Employee"

danilo.dilbeck@megacorp.com,1,Mega Corporation,"Individual account",1,Library,Default Organization View,"Employee"

marylee.millsap@megacorp.com,1,Mega Corporation,"Individual account",1,Library,Default Organization View,"Employee"

rolf.rueb@megacorp.com,1,Mega Corporation,"Individual account",1,Library,Default Organization View,"Employee"

miriam.messenger@megacorp.com,1,Mega Corporation,"Individual account",1,Library,Default Organization View,"Employee"

danae.drayer@megacorp.com,1,Mega Corporation,"Individual account",1,Library,Default Organization View,"Employee"

stan.stokely@megacorp.com,1,Mega Corporation,"Individual account",1,Library,Default Organization View,"Employee"

martin.magallon@megacorp.com,1,Mega Corporation,"Individual account",1,Library,Default Organization View,"Employee"

orville.oneill@megacorp.com,1,Mega Corporation,"Individual account",1,Library,Default Organization View,"Employee"

kourtney.kyle@megacorp.com,1,Mega Corporation,"Individual account",1,Library,Default Organization View,"Employee"

tessa.treiber@megacorp.com,1,Mega Corporation,"Individual account",1,Library,Default Organization View,"Employee"

kamilah.kurland@megacorp.com,1,Mega Corporation,"Individual account",1,Library,Default Organization View,"Employee"

zelma.zemke@megacorp.com,1,Mega Corporation,"Individual account",1,Library,Default Organization View,"Employee"

jefferson.jock@megacorp.com,1,Mega Corporation,"Individual account",1,Library,Default Organization View,"Employee"

shirely.stowe@megacorp.com,1,Mega Corporation,"Individual account",1,Library,Default Organization View,"Employee"

niesha.nold@megacorp.com,1,Mega Corporation,"Individual account",1,Library,Default Organization View,"Employee"

bruce.butterworth@megacorp.com,1,Mega Corporation,"Individual account",1,Library,Default Organization View,"Employee"

denna.debartolo@megacorp.com,1,Mega Corporation,"Individual account",1,Library,Default Organization View,"Employee"

janay.johnson@megacorp.com,1,Mega Corporation,"Individual account",1,Library,Default Organization View,"Employee"

kristen.kellems@megacorp.com,1,Mega Corporation,"Individual account",1,Library,Default Organization View,"Employee"

tiny.tacy@megacorp.com,1,Mega Corporation,"Individual account",1,Library,Default Organization View,"Employee"

dolores.delay@megacorp.com,1,Mega Corporation,"Individual account",1,Library,Default Organization View,"Employee"

shira.sitzes@megacorp.com,1,Mega Corporation,"Individual account",1,Library,Default Organization View,"Employee"

aron.askew@megacorp.com,1,Mega Corporation,"Individual account",1,Library,Default Organization View,"Employee"

nydia.neil@megacorp.com,1,Mega Corporation,"Individual account",1,Library,Default Organization View,"Employee"

theodore.talbert@megacorp.com,1,Mega Corporation,"Individual account",1,Library,Default Organization View,"Employee"

shani.spinks@megacorp.com,1,Mega Corporation,"Individual account",1,Library,Default Organization View,"Employee"

diedra.darrow@megacorp.com,1,Mega Corporation,"Individual account",1,Library,Default Organization View,"Employee"

judith.joachim@megacorp.com,1,Mega Corporation,"Individual account",1,Library,Default Organization View,"Employee"

melda.metheny@megacorp.com,1,Mega Corporation,"Individual account",1,Library,Default Organization View,"Employee"

nannie.nobles@megacorp.com,1,Mega Corporation,"Individual account",1,Library,Default Organization View,"Employee"

annamae.audie@megacorp.com,1,Mega Corporation,"Individual account",1,Library,Default Organization View,"Employee"

kalyn.kimzey@megacorp.com,1,Mega Corporation,"Individual account",1,Library,Default Organization View,"Employee"

hsiu.henningsen@megacorp.com,1,Mega Corporation,"Individual account",1,Library,Default Organization View,"Employee"

delcie.diez@megacorp.com,1,Mega Corporation,"Individual account",1,Library,Default Organization View,"Employee"

edris.ekhoff@megacorp.com,1,Mega Corporation,"Individual account",1,Library,Default Organization View,"Employee"

monique.maly@megacorp.com,1,Mega Corporation,"Individual account",1,Library,Default Organization View,"Employee"

robbi.rosendahl@megacorp.com,1,Mega Corporation,"Individual account",1,Library,Default Organization View,"Employee"

lakeesha.loiacono@megacorp.com,1,Mega Corporation,"Individual account",1,Library,Default Organization View,"Employee"

coralee.culbert@megacorp.com,1,Mega Corporation,"Individual account",1,Library,Default Organization View,"Employee"

danette.dewitt@megacorp.com,1,Mega Corporation,"Individual account",1,Library,Default Organization View,"Employee"

cinthia.cadieux@megacorp.com,1,Mega Corporation,"Individual account",1,Library,Default Organization View,"Employee"

myron.mclawhorn@megacorp.com,1,Mega Corporation,"Individual account",1,Library,Default Organization View,"Employee"

madeleine.magers@megacorp.com,1,Mega Corporation,"Individual account",1,Library,Default Organization View,"Employee"

evita.epting@megacorp.com,1,Mega Corporation,"Individual account",1,Library,Default Organization View,"Employee"

karrie.kindel@megacorp.com,1,Mega Corporation,"Individual account",1,Library,Default Organization View,"Employee"

moses.modisette@megacorp.com,1,Mega Corporation,"Individual account",1,Library,Default Organization View,"Employee"

winifred.wessels@megacorp.com,1,Mega Corporation,"Individual account",1,Library,Default Organization View,"Employee"

ashton.aumann@megacorp.com,1,Mega Corporation,"Individual account",1,Library,Default Organization View,"Employee"

guillermina.gloster@megacorp.com,1,Mega Corporation,"Individual account",1,Library,Default Organization View,"Employee"

jeremy.jong@megacorp.com,1,Mega Corporation,"Individual account",1,Library,Default Organization View,"Employee"

marilou.mcintosh@megacorp.com,1,Mega Corporation,"Individual account",1,Library,Default Organization View,"Employee"

rubin.ravenscroft@megacorp.com,1,Mega Corporation,"Individual account",1,Library,Default Organization View,"Employee"

peggie.phillips@megacorp.com,1,Mega Corporation,"Individual account",1,Library,Default Organization View,"Employee"

evelina.elders@megacorp.com,1,Mega Corporation,"Individual account",1,Library,Default Organization View,"Employee"

edda.elam@megacorp.com,1,Mega Corporation,"Individual account",1,Library,Default Organization View,"Employee"

fausto.fortino@megacorp.com,1,Mega Corporation,"Individual account",1,Library,Default Organization View,"Employee"

elena.eisert@megacorp.com,1,Mega Corporation,"Individual account",1,Library,Default Organization View,"Employee"

mariella.molock@megacorp.com,1,Mega Corporation,"Individual account",1,Library,Default Organization View,"Employee"

starla.scheiber@megacorp.com,1,Mega Corporation,"Individual account",1,Library,Default Organization View,"Employee"

parker.paetzold@megacorp.com,1,Mega Corporation,"Individual account",1,Library,Default Organization View,"Employee"

vallie.vizcaino@megacorp.com,1,Mega Corporation,"Individual account",1,Library,Default Organization View,"Employee"

renea.rubenstein@megacorp.com,1,Mega Corporation,"Individual account",1,Library,Default Organization View,"Employee"

lien.lipscomb@megacorp.com,1,Mega Corporation,"Individual account",1,Library,Default Organization View,"Employee"

debby.dupuy@megacorp.com,1,Mega Corporation,"Individual account",1,Library,Default Organization View,"Employee"

carolann.corbo@megacorp.com,1,Mega Corporation,"Individual account",1,Library,Default Organization View,"Employee"

lee.litchfield@megacorp.com,1,Mega Corporation,"Individual account",1,Library,Default Organization View,"Employee"

lashon.locker@megacorp.com,1,Mega Corporation,"Individual account",1,Library,Default Organization View,"Employee"

caroll.colquitt@megacorp.com,1,Mega Corporation,"Individual account",1,Library,Default Organization View,"Employee"

lillian.louviere@megacorp.com,1,Mega Corporation,"Individual account",1,Library,Default Organization View,"Employee"

rafaela.rasco@megacorp.com,1,Mega Corporation,"Individual account",1,Library,Default Organization View,"Employee"

mandie.mcquinn@megacorp.com,1,Mega Corporation,"Individual account",1,Library,Default Organization View,"Employee"

bambi.bivona@megacorp.com,1,Mega Corporation,"Individual account",1,Library,Default Organization View,"Employee"

jacques.joaquin@megacorp.com,1,Mega Corporation,"Individual account",1,Library,Default Organization View,"Employee"

wes.wallner@megacorp.com,1,Mega Corporation,"Individual account",1,Library,Default Organization View,"Employee"

retta.rosso@megacorp.com,1,Mega Corporation,"Individual account",1,Library,Default Organization View,"Employee"

melia.meche@megacorp.com,1,Mega Corporation,"Individual account",1,Library,Default Organization View,"Employee"

nga.nordquist@megacorp.com,1,Mega Corporation,"Individual account",1,Library,Default Organization View,"Employee"

georgine.grimmett@megacorp.com,1,Mega Corporation,"Individual account",1,Library,Default Organization View,"Employee"

elden.easley@megacorp.com,1,Mega Corporation,"Individual account",1,Library,Default Organization View,"Employee"

van.villanveva@megacorp.com,1,Mega Corporation,"Individual account",1,Library,Default Organization View,"Employee"

shemika.spikes@megacorp.com,1,Mega Corporation,"Individual account",1,Library,Default Organization View,"Employee"

bettina.budniewski@megacorp.com,1,Mega Corporation,"Individual account",1,Library,Default Organization View,"Employee"

yun.yarberry@megacorp.com,1,Mega Corporation,"Individual account",1,Library,Default Organization View,"Employee"

mac.malmberg@megacorp.com,1,Mega Corporation,"Individual account",1,Library,Default Organization View,"Employee"

rory.rollinson@megacorp.com,1,Mega Corporation,"Individual account",1,Library,Default Organization View,"Employee"

silva.sotelo@megacorp.com,1,Mega Corporation,"Individual account",1,Library,Default Organization View,"Contractor"

le.leggett@megacorp.com,1,Mega Corporation,"Individual account",1,Library,Default Organization View,"Contractor"

eartha.edie@megacorp.com,1,Mega Corporation,"Individual account",1,Library,Default Organization View,"Contractor"

tenisha.tinajero@megacorp.com,1,Mega Corporation,"Individual account",1,Library,Default Organization View,"Contractor"

hien.hamby@megacorp.com,1,Mega Corporation,"Individual account",1,Library,Default Organization View,"Contractor"

milford.mize@megacorp.com,1,Mega Corporation,"Individual account",1,Library,Default Organization View,"Contractor"

elnora.efaw@megacorp.com,1,Mega Corporation,"Individual account",1,Library,Default Organization View,"Contractor"

Name,Count,Organization,Environment,Content View,Host Collections,Virtual,Host,OS,Arch,Sockets,RAM,Cores,SLA,Products,Subscriptions

host%d,1,Mega Corporation,Library,Default Organization View,"Mega Corp HQ",No,,RHEL 6.4,x86_64,1,4,1,Standard,"69|Red Hat Enterprise Linux Server,79|Red Hat Enterprise Linux Server",RH0103708|Red Hat Enterprise Linux Server Premium (8 sockets) (Up to 4 guests)

guest%d,1,Mega Corporation,Library,Default Organization View,"Mega Corp HQ,Accounting",Yes,host0,RHEL 6.4,x86_64,1,4,1,Standard,"69|Red Hat Enterprise Linux Server,79|Red Hat Enterprise Linux Server",RH0103708|Red Hat Enterprise Linux Server Premium (8 sockets) (Up to 4 guests)

Name,Count,Organization,Limit,Description

Mega Corp HQ,1,Mega Corporation,Unlimited,Downtown headquarters

Engineering,1,Mega Corporation,Unlimited,,

Quality,1,Mega Corporation,Unlimited,,

Accounting,1,Mega Corporation,Unlimited,,

Facilities,1,Mega Corporation,Unlimited,,

Shipping,1,Mega Corporation,Unlimited,,

Lobby,1,Mega Corporation,Unlimited,,

Customer Service,1,Mega Corporation,Unlimited,,

Marketing,1,Mega Corporation,Unlimited,,

HR,1,Mega Corporation,Unlimited,,

Sales,1,Mega Corporation,Unlimited,,

Legal,1,Mega Corporation,Unlimited,,

Senior Leadership,1,Mega Corporation,Unlimited,,

Employee,1,Mega Corporation,Unlimited,,

Contractor,1,Mega Corporation,Unlimited,,

"Name","Count","Label","Organization","Prior Environment","Description"

"Development","1","Development","Mega Corporation","Library",""

"Testing","1","Testing","Mega Corporation","Development",""

"Stage","1","Stage","Mega Corporation","Testing",""

"Production","1","Production","Mega Corporation","Stage",""

"OpenStack","1","OpenStack","Mega Corporation","Library",""

"Name","Count","Family"

"CentOS 6.4","1","Redhat"

"Debian 6.0","1","Debian"

"Debian 7.0","1","Debian"

"Fedora 14","1","Redhat"

"Fedora 17","1","Redhat"

"Fedora 18","1","Redhat"

"Fedora 19","1","Redhat"

"OpenSuSE 11.4","1","Suse"

"RHEL 5.8","1","Redhat"

"RHEL 6.3","1","Redhat"

"RHEL 5.7","1","Redhat"

"RHEL 6.4","1","Redhat"

"Solaris 5.10","1","Solaris"

"Ubuntu 12.10","1","Debian"

"Windows 6.1","1","Windows"