reporting/reports/data/custom-info | 30 ++++++++++++++++++++++++++++++
1 file changed, 30 insertions(+)
New commits:
commit 35d0025259f03dd5e77f94897b77f3697be80d06
Author: Tomas Kasparek <tkasparek(a)redhat.com>
Date: Tue Jan 22 10:47:53 2013 +0100
745342 - system custom info report
diff --git a/reporting/reports/data/custom-info b/reporting/reports/data/custom-info
new file mode 100644
index 0000000..2ccdf00
--- /dev/null
+++ b/reporting/reports/data/custom-info
@@ -0,0 +1,30 @@
+
+synopsis:
+
+ Display system custom info
+
+description:
+
+ Display custom for all systems in spacewalk with any custom info associated
+
+columns:
+
+ server_id Server id
+ org_id Organization id
+ server_name Server name
+ key Custom info key
+ value Custom info value
+
+sql:
+
+ select * from (
+ select rhnServer.id as server_id,
+ rhnServer.org_id as org_id,
+ rhnServer.name as server_name,
+ rhnCustomDataKey.label as key,
+ rhnServerCustomDataValue.value as value
+ from rhnServer join rhnServerCustomDataValue on
rhnServer.id=rhnServerCustomDataValue.server_id join rhnCustomDataKey on
rhnServerCustomDataValue.key_id=rhnCustomDataKey.id
+ ) X
+ -- where placeholder
+ order by org_id, server_id
+
Show replies by date