backend/satellite_tools/spacewalk-report | 17 +++++++++++++++-- 1 file changed, 15 insertions(+), 2 deletions(-)
New commits: commit 098b65571e1dc68befea88cad6863fab44440109 Author: Jan Pazdziora jpazdziora@redhat.com Date: Thu Jul 23 11:46:05 2009 +0200
reporting: add the registered by information.
diff --git a/backend/satellite_tools/spacewalk-report b/backend/satellite_tools/spacewalk-report index f73039c..d59002f 100755 --- a/backend/satellite_tools/spacewalk-report +++ b/backend/satellite_tools/spacewalk-report @@ -71,7 +71,8 @@ if __name__ == '__main__':
h = rhnSQL.prepare(""" select rhnserver.id as server_id, rhnserver.name as profile_name, - rhnservernetwork.hostname, trim(rhnservernetwork.ipaddr) as ip_address + rhnservernetwork.hostname, trim(rhnservernetwork.ipaddr) as ip_address, + ( select login from web_contact where rhnserver.creator_id = web_contact.id ) as registered_by from rhnserver, ( select server_id, hostname, ipaddr
commit 0ffac924319092a2e35f6951859b1f2a9227ddd4 Author: Jan Pazdziora jpazdziora@redhat.com Date: Thu Jul 23 11:44:43 2009 +0200
reporting: add hostname and IP address to the report.
diff --git a/backend/satellite_tools/spacewalk-report b/backend/satellite_tools/spacewalk-report index af2cad4..f73039c 100755 --- a/backend/satellite_tools/spacewalk-report +++ b/backend/satellite_tools/spacewalk-report @@ -70,8 +70,19 @@ if __name__ == '__main__': writer = csv.writer(sys.stdout)
h = rhnSQL.prepare(""" - select rhnserver.id as server_id, rhnserver.name as profile_name - from rhnserver + select rhnserver.id as server_id, rhnserver.name as profile_name, + rhnservernetwork.hostname, trim(rhnservernetwork.ipaddr) as ip_address + from rhnserver, + ( + select server_id, hostname, ipaddr + from rhnservernetwork + where id in ( + select min(id) + from rhnservernetwork + group by server_id + ) + ) rhnservernetwork + where rhnserver.id = rhnservernetwork.server_id (+) order by server_id """) h.execute()
commit d3d685fbe17635102e8a0b6c57a4c6a57538306d Author: Jan Pazdziora jpazdziora@redhat.com Date: Thu Jul 23 11:41:54 2009 +0200
reporting: output field names as the first row.
diff --git a/backend/satellite_tools/spacewalk-report b/backend/satellite_tools/spacewalk-report index 215b2bd..af2cad4 100755 --- a/backend/satellite_tools/spacewalk-report +++ b/backend/satellite_tools/spacewalk-report @@ -75,6 +75,7 @@ if __name__ == '__main__': order by server_id """) h.execute() + writer.writerow(map(lambda x: x[0].lower(), h.description)) row = h.fetchone() while row != None: writer.writerow(row)
spacewalk-commits@lists.fedorahosted.org