reporting/reports/data/system-packages-installed | 38 +++++++++++++++++++++++
1 file changed, 38 insertions(+)
New commits:
commit 3c378cef47adb232d67a7f57502d2a4dd4eb17b4
Author: Tomas Kasparek <tkasparek(a)redhat.com>
Date: Tue Jan 15 14:24:47 2013 +0100
662773 - spacewalk-report system-packages-installed
Report of all installed packages on all systems across spacewalk
diff --git a/reporting/reports/data/system-packages-installed
b/reporting/reports/data/system-packages-installed
new file mode 100644
index 0000000..9309185
--- /dev/null
+++ b/reporting/reports/data/system-packages-installed
@@ -0,0 +1,38 @@
+
+synopsis:
+
+ Packages installed on systems
+
+description:
+
+ List all packages for all systems across whole spacewalk
+
+columns:
+
+ system_id System id
+ org_id Id of organization system belongs to
+ package_name Name of the package
+ package_epoch Epoch of the package
+ package_version Version of the package
+ package_release Release of the package
+ package_arch Architecture of the package
+
+sql:
+
+ select * from (
+ select rhnServer.id as system_id,
+ rhnServer.org_id as org_id,
+ rhnPackageName.name as package_name,
+ rhnPackageEvr.epoch as package_epoch,
+ rhnPackageEvr.version as package_version,
+ rhnPackageEvr.release as package_release,
+ rhnPackageArch.label as package_arch
+ from rhnServer
+ join rhnServerPackage on rhnServer.id=rhnServerPackage.server_id
+ join rhnPackageName on rhnServerPackage.name_id=rhnPackageName.id
+ join rhnPackageEvr on rhnServerPackage.evr_id=rhnPackageEvr.id
+ join rhnPackageArch on rhnServerPackage.package_arch_id=rhnPackageArch.id
+ ) X
+ -- where placeholder
+ order by system_id, org_id, package_name, package_name
+
Show replies by date