rhns-export-to-csv-per-sysgroup.py

#!/usr/bin/python

#NOTE: this requires pythoon 2.3 minumum

###
# To the extent possible under law, Red Hat, Inc. has dedicated all copyright to this software to the public domain worldwide, pursuant to the CC0 Public Domain Dedication. 
# This software is distributed without any warranty.  See <http://creativecommons.org/publicdomain/zero/1.0/>.
###


__author__ = "Felix Dewaleyne"
__credits__ = ["Felix Dewaleyne"]
__license__ = "GPL"
__version__ = "0.2"
__maintainer__ = "Felix Dewaleyne"
__email__ = "fdewaley@redhat.com"
__status__ = "test"


import xmlrpclib, sys, getpass, csv
#connection part
sys.stderr.write("Please input the fqdn of your satellite or its ip adress: ")
sathost = raw_input().strip()
client = xmlrpclib.Server("https://%s/rpc/api" % (sathost))
sys.stderr.write("enter your RHN login: ")
login = raw_input().strip()
password = getpass.getpass(prompt="enter your RHN Password: ")
sys.stderr.write("\n")
key = client.auth.login(login, password)
#remove the password from memory
del password

#gather the list of system groups
for a_group in client.systemgroup.listAllGroups(key):
    extract_sysgroup(a_group['name'])

def extract_sysgroup(sysgroup):
    """generates a csv file for the systems in the sysgroup"""
    #fetch the data
    print "Fetching the list of systems and the details for each of your system. This may take some time"
    rhn_data={}
    #change the call in this part
    for system in client.systemgroup.listSystems(key, sysgroup):
        #gather the details for each system
        rhn_data[system['id']] = {'id': system['id'], 'osa_status': system['osa_status'], 'last_boot': system['last_boot']}
        #add all the data from getDetails to this dictionary
        rhn_data[system['id']].update(client.system.getDetails(key,int(system['id'])))
        #add all the network details as well
        rhn_data[system['id']].update(client.system.getNetwork(key,int(system['id'])))
        #get the count of erratas available & unscheduled
        try:
            relevant_errata_count = len(client.system.getRelevantErrata(key, system['id']))
            unscheduled_errata_count = len(client.system.getUnscheduledErrata(key, system['id']))
            rhn_data[system['id']].update({'relevant_erratas': str(relevant_errata_count), 'unscheduled_erratas': str(unscheduled_errata_count) })
        except:
            rhn_data[system['id']].update({'relevant_erratas': 'NA', 'unscheduled_erratas': 'NA' })

    #now write the csv file
    print "Writing data to the csv file"
    headers=['id' , 'profile_name', 'hostname', 'ip', 'osa_status', 'last_boot', 'base_entitlement', 'relevant_erratas', 'unscheduled_erratas', 'description', 'adress1','adress2', 'city', 'state', 'country', 'building', 'room', 'rack']
    csvfile = open('systems_'+sysgroup+'.csv', 'wb' )
    csv_writer = csv.writer(csvfile, delimiter=',', quotechar='"', quoting=csv.QUOTE_NONNUMERIC)
    csv_writer.writerow(headers)
    for system in rhn_data.itervalues():
        line = []
        for value in headers:
            line.append(system.get(value))
        csv_writer.writerow(line)
        del line
    del rhn_data

#end of the script
client.auth.logout(key)