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_activity_list_by_desktop.sh | |
parent | c7067de14c249cd92fd5d0c1efaf0d0342f4a5c4 (diff) |
Improves:
+ Add queries script to get report by desktops and list the activities most used.
Diffstat (limited to 'sql/rep_activity_list_by_desktop.sh')
-rwxr-xr-x | sql/rep_activity_list_by_desktop.sh | 18 |
1 files changed, 18 insertions, 0 deletions
diff --git a/sql/rep_activity_list_by_desktop.sh b/sql/rep_activity_list_by_desktop.sh new file mode 100755 index 0000000..7d143ee --- /dev/null +++ b/sql/rep_activity_list_by_desktop.sh @@ -0,0 +1,18 @@ +#!/bin/bash +DB_NAME=statistics +DB_USER=root +DB_PASS=gustavo + +QUERY=activity_most_used +CANT_MAX=10 +DESKTOP=any +START_DATE=2013-02-10 +END_DATE=2013-02-14 + + + +LOG_LEVEL=info + + +./make_report --query $QUERY --desktop $DESKTOP --cant_max $CANT_MAX --start_date $START_DATE --end_date $END_DATE --db_name $DB_NAME --db_user $DB_USER --db_pass $DB_PASS --log_level $LOG_LEVEL + |