reporting/reports/data/errata-channels | 29 ++++++++++++++++++++++++++++
reporting/reports/data/kickstartable-trees | 30 +++++++++++++++++++++++++++++
2 files changed, 59 insertions(+)
New commits:
commit 783a9108ae3ea1112c3d8475b7ecfa403523e49a
Author: Jan Pazdziora <jpazdziora(a)redhat.com>
Date: Mon Aug 8 14:51:20 2011 +0200
New reports: errata-channels and kickstartable-trees.
diff --git a/reporting/reports/data/errata-channels
b/reporting/reports/data/errata-channels
new file mode 100755
index 0000000..d294cd9
--- /dev/null
+++ b/reporting/reports/data/errata-channels
@@ -0,0 +1,29 @@
+
+synopsis:
+
+ List of erratas in channels
+
+description:
+
+ List of all erratas and their relation to channels.
+
+columns:
+
+ advisory Advisory / errata identifier
+ channel_label Channel label
+
+sql:
+
+
+ select advisory, channel_label
+ from (
+ select rhnErrata.advisory_name as advisory,
+ rhnErrata.id as errata_id,
+ rhnChannel.label as channel_label,
+ rhnChannel.id as channel_id
+ from rhnErrata, rhnChannelErrata, rhnChannel
+ where rhnErrata.id = rhnChannelErrata.errata_id
+ and rhnChannelErrata.channel_id = rhnChannel.id
+ ) X
+ -- where placeholder
+ order by advisory, errata_id, channel_label, channel_id
diff --git a/reporting/reports/data/kickstartable-trees
b/reporting/reports/data/kickstartable-trees
new file mode 100755
index 0000000..7a2d5fc
--- /dev/null
+++ b/reporting/reports/data/kickstartable-trees
@@ -0,0 +1,30 @@
+
+synopsis:
+
+ List of kickstartable trees
+
+description:
+
+ List of all kickstartable trees.
+
+columns:
+
+ organization_id:i Organization identifier
+ channel_label Label of the channel
+ tree_label Kickstartable tree label
+ number_of_files:i Number of files in the kickstartable tree
+
+sql:
+
+ select organization_id, channel_label, tree_label, number_of_files
+ from (
+ select rhnKickstartableTree.org_id as organization_id,
+ rhnChannel.label as channel_label,
+ rhnKickstartableTree.label as tree_label,
+ ( select count(*) from rhnKSTreeFile where rhnKickstartableTree.id =
rhnKSTreeFile.kstree_id ) as number_of_files,
+ rhnKickstartableTree.id
+ from rhnKickstartableTree, rhnChannel
+ where rhnKickstartableTree.channel_id = rhnChannel.id
+ ) X
+ -- where placeholder
+ order by organization_id, channel_label, tree_label, id
Show replies by date