backend/satellite_tools/reports/data/errata-list | 28 ++++++++++++++++++
backend/satellite_tools/reports/data/errata-systems | 30 ++++++++++++++++++++
backend/satellite_tools/spacewalk-report | 2 -
3 files changed, 59 insertions(+), 1 deletion(-)
New commits:
commit 1a7477c0e2b984b0743cdca9896f53e74f67b535
Author: Jan Pazdziora <jpazdziora(a)redhat.com>
Date: Fri Oct 23 13:29:49 2009 +0200
reporting: as errata-system report does not have any multival_columns, we need to disable the multival logic in that case.
diff --git a/backend/satellite_tools/spacewalk-report b/backend/satellite_tools/spacewalk-report
index eb80584..af81457 100755
--- a/backend/satellite_tools/spacewalk-report
+++ b/backend/satellite_tools/spacewalk-report
@@ -124,7 +124,7 @@ if __name__ == '__main__':
outrow = None
multival_dupes = {}
while row != None:
- if options.multivalonrows:
+ if options.multivalonrows or not report.multival_column_names.keys():
writer.writerow(row)
row = h.fetchone()
continue
commit e05cda398c8997da84884307db1cfa62e64a98cd
Author: Jan Pazdziora <jpazdziora(a)redhat.com>
Date: Fri Oct 23 13:28:36 2009 +0200
reporting: new report errata-systems, listing systems for each errata.
diff --git a/backend/satellite_tools/reports/data/errata-systems b/backend/satellite_tools/reports/data/errata-systems
new file mode 100755
index 0000000..85079d3
--- /dev/null
+++ b/backend/satellite_tools/reports/data/errata-systems
@@ -0,0 +1,30 @@
+
+columns:
+
+ advisory
+ server_id
+ profile_name
+ hostname
+ ip_address
+
+sql:
+
+ select rhnErrata.advisory_name as advisory,
+ rhnServerNeededErrataCache.server_id,
+ rhnServer.name as profile_name,
+ rhnservernetwork.hostname, trim(rhnservernetwork.ipaddr) as ip_address
+ from rhnErrata, rhnServerNeededErrataCache, rhnServer,
+ (
+ select server_id, hostname, ipaddr
+ from rhnservernetwork
+ where id in (
+ select min(id)
+ from rhnservernetwork
+ group by server_id
+ )
+ ) rhnservernetwork
+ where rhnErrata.id = rhnServerNeededErrataCache.errata_id
+ and rhnServerNeededErrataCache.server_id = rhnServer.id
+ and rhnServerNeededErrataCache.server_id = rhnservernetwork.server_id (+)
+ order by rhnErrata.advisory_name, rhnServerNeededErrataCache.server_id
+
commit bfac445773847e2132cb41b832d5f75adc2250c7
Author: Jan Pazdziora <jpazdziora(a)redhat.com>
Date: Fri Oct 23 11:53:55 2009 +0200
reporting: errata-list: as the severity_id seems to always be null, removing the severity column from output.
diff --git a/backend/satellite_tools/reports/data/errata-list b/backend/satellite_tools/reports/data/errata-list
index 58f6abe..f76a918 100755
--- a/backend/satellite_tools/reports/data/errata-list
+++ b/backend/satellite_tools/reports/data/errata-list
@@ -3,7 +3,6 @@ columns:
advisory
cve
- severity
synopsis
systems_affected
@@ -16,17 +15,14 @@ sql:
select rhnErrata.advisory_name as advisory,
rhnCVE.name as cve,
- rhnErrataSeverity.label as severity,
rhnErrata.synopsis,
count(*) as systems_affected
- from rhnErrata, rhnServerNeededErrataCache, rhnErrataCVE, rhnCVE, rhnErrataSeverity
+ from rhnErrata, rhnServerNeededErrataCache, rhnErrataCVE, rhnCVE
where rhnErrata.id = rhnServerNeededErrataCache.errata_id
and rhnErrata.id = rhnErrataCVE.errata_id (+)
and rhnErrataCVE.cve_id = rhnCVE.id (+)
- and rhnErrata.severity_id = rhnErrataSeverity.id (+)
group by rhnErrata.id,
rhnErrata.advisory_name,
rhnCVE.name,
- rhnErrataSeverity.label,
rhnErrata.synopsis
order by rhnErrata.advisory_name, rhnCVE.name
commit f6ad8fe19d1ef742a6adcda4ddba3cd0ab22c1f3
Author: Jan Pazdziora <jpazdziora(a)redhat.com>
Date: Fri Oct 23 11:52:39 2009 +0200
reporting: new report errata-list, listing erratas applicable to systems.
diff --git a/backend/satellite_tools/reports/data/errata-list b/backend/satellite_tools/reports/data/errata-list
new file mode 100755
index 0000000..58f6abe
--- /dev/null
+++ b/backend/satellite_tools/reports/data/errata-list
@@ -0,0 +1,32 @@
+
+columns:
+
+ advisory
+ cve
+ severity
+ synopsis
+ systems_affected
+
+multival_columns:
+
+ advisory
+ cve : cve
+
+sql:
+
+ select rhnErrata.advisory_name as advisory,
+ rhnCVE.name as cve,
+ rhnErrataSeverity.label as severity,
+ rhnErrata.synopsis,
+ count(*) as systems_affected
+ from rhnErrata, rhnServerNeededErrataCache, rhnErrataCVE, rhnCVE, rhnErrataSeverity
+ where rhnErrata.id = rhnServerNeededErrataCache.errata_id
+ and rhnErrata.id = rhnErrataCVE.errata_id (+)
+ and rhnErrataCVE.cve_id = rhnCVE.id (+)
+ and rhnErrata.severity_id = rhnErrataSeverity.id (+)
+ group by rhnErrata.id,
+ rhnErrata.advisory_name,
+ rhnCVE.name,
+ rhnErrataSeverity.label,
+ rhnErrata.synopsis
+ order by rhnErrata.advisory_name, rhnCVE.name