diff options
author | Gustavo Duarte AC <gduarte@activitycentral.com> | 2013-02-22 18:05:18 (GMT) |
---|---|---|
committer | Gustavo Duarte AC <gduarte@activitycentral.com> | 2013-02-22 18:05:18 (GMT) |
commit | c4fc1ba6b622aa63c2b04be3359b8f8c895ae375 (patch) | |
tree | 2c9d6274aebf757942ba60fdbeafd73f3cf8537b /sql/rep_desktops.sh | |
parent | c7067de14c249cd92fd5d0c1efaf0d0342f4a5c4 (diff) |
Improves:
+ Add queries script to get report by desktops and list the activities most used.
Diffstat (limited to 'sql/rep_desktops.sh')
-rwxr-xr-x | sql/rep_desktops.sh | 17 |
1 files changed, 17 insertions, 0 deletions
diff --git a/sql/rep_desktops.sh b/sql/rep_desktops.sh new file mode 100755 index 0000000..0640c4e --- /dev/null +++ b/sql/rep_desktops.sh @@ -0,0 +1,17 @@ +#!/bin/bash +DB_NAME=statistics +DB_USER=root +DB_PASS=gustavo + +QUERY=desktops +DESKTOP=gnome +START_DATE=2013-02-10 +END_DATE=2013-02-14 + + +s +LOG_LEVEL=info + + +./make_report --query $QUERY --desktop $DESKTOP --start_date $START_DATE --end_date $END_DATE --db_name $DB_NAME --db_user $DB_USER --db_pass $DB_PASS --log_level $LOG_LEVEL + |