From 28995453682effde0eff414333ef2973e2c52fec Mon Sep 17 00:00:00 2001 From: Joey Hagedorn Date: Fri, 14 Jul 2006 15:55:24 +0000 Subject: Final commit before view data in new reports gets restructured. git-svn-id: https://svn.mcs.anl.gov/repos/bcfg/trunk/bcfg2@1942 ce84e21b-d406-0410-9b95-82705330c041 --- reports/brpt/reports/sql/client.sql | 1 + reports/brpt/reports/templates/clients/client-nodebox.html | 2 +- 2 files changed, 2 insertions(+), 1 deletion(-) create mode 100644 reports/brpt/reports/sql/client.sql diff --git a/reports/brpt/reports/sql/client.sql b/reports/brpt/reports/sql/client.sql new file mode 100644 index 000000000..6ef37a27f --- /dev/null +++ b/reports/brpt/reports/sql/client.sql @@ -0,0 +1 @@ +CREATE VIEW reports_current_interactions AS SELECT x.client_id AS client_id, reports_interaction.id AS interaction_id FROM (select client_id, MAX(timestamp) as timer FROM reports_interaction GROUP BY client_id) x, reports_interaction WHERE reports_interaction.client_id = x.client_id AND reports_interaction.timestamp = x.timer \ No newline at end of file diff --git a/reports/brpt/reports/templates/clients/client-nodebox.html b/reports/brpt/reports/templates/clients/client-nodebox.html index 12b53d899..e3ed25cee 100644 --- a/reports/brpt/reports/templates/clients/client-nodebox.html +++ b/reports/brpt/reports/templates/clients/client-nodebox.html @@ -2,7 +2,7 @@
Time Ran: {{interaction.timestamp}} - (-Insert Profile Name Here-) +

Node: -- cgit v1.2.3-1-g7c22