diff options
| author | Udo Walter | 2017-01-17 13:47:24 +0100 |
|---|---|---|
| committer | Udo Walter | 2017-01-17 13:47:24 +0100 |
| commit | 4910fa0b9f5ca6b6063965cc516ced8d72f8be5b (patch) | |
| tree | 7514244884661c4e7fc323d6d67587616237885b /modules-available/statistics_reporting/inc/queries.inc.php | |
| parent | [statistics_reporting] added cronjob for weekly report (diff) | |
| download | slx-admin-4910fa0b9f5ca6b6063965cc516ced8d72f8be5b.tar.gz slx-admin-4910fa0b9f5ca6b6063965cc516ced8d72f8be5b.tar.xz slx-admin-4910fa0b9f5ca6b6063965cc516ced8d72f8be5b.zip | |
[statistics_reporting] added vm name anonymization
Diffstat (limited to 'modules-available/statistics_reporting/inc/queries.inc.php')
| -rw-r--r-- | modules-available/statistics_reporting/inc/queries.inc.php | 2 |
1 files changed, 1 insertions, 1 deletions
diff --git a/modules-available/statistics_reporting/inc/queries.inc.php b/modules-available/statistics_reporting/inc/queries.inc.php index 23f5fb03..219640a6 100644 --- a/modules-available/statistics_reporting/inc/queries.inc.php +++ b/modules-available/statistics_reporting/inc/queries.inc.php @@ -64,7 +64,7 @@ class Queries // Virtual Machine Data: Name, Number of Usages public static function getVMStatistics($from, $to, $lowerTimeBound = 0, $upperTimeBound = 24) { - $res = Database::simpleQuery("SELECT data AS name, COUNT(*) AS 'count' + $res = Database::simpleQuery("SELECT data AS name, MD5(data) AS vmHash, COUNT(*) AS 'count' FROM statistic WHERE typeid='.vmchooser-session-name' AND dateline+data >= $from and dateline <= $to AND ( (@daysDiff := (TO_DAYS(FROM_UNIXTIME(@end := IF(dateline+data > $to, $to, dateline+data), '%y-%m-%d')) - TO_DAYS(FROM_UNIXTIME(@start := IF(dateline < $from, $from, dateline), '%y-%m-%d'))) = 0 |