summaryrefslogtreecommitdiffstats
path: root/modules-available/statistics_reporting/inc/queries.inc.php
Commit message (Collapse)AuthorAgeFilesLines
* [statistics_reporting] Fix numer of unique users and server CPU modelSimon Rettberg2020-07-301-2/+1Star
|
* [statistics_reporting] Don't consider machines not recently usedSimon Rettberg2020-01-171-6/+9
| | | | | ... machine must have been running in the previous 30 days, relative to the "from" timestamp of selected interval.
* [statistics_reporting] Fix perVM and perUser (type mismatch in SQL)Simon Rettberg2018-02-051-6/+6
|
* [statistics_reporting] Query rewrite: Use iterative approachSimon Rettberg2018-01-041-192/+320
| | | | | | | Several simple test cases yielded incorrect results, also sessions partially overlapping with the selected hours were not handled properly. Iterative processing of logged events instead of single humongous unmaintainable SQL query.
* Fix A LOT of type problems, logic flaws, uninitialized variables etc.Simon Rettberg2017-12-161-2/+2
| | | | | Most of them were found by phpstorm, so I put in some time and went through the list, fixing quite a bunch of them.
* [statistics_reporting] Extend remote report by hwstats, date ranges, userstatsSimon Rettberg2017-04-241-0/+63
| | | | This implements #3108
* [statistics_reporting] fixed clients/locations without offline-length ↵Udo Walter2017-04-041-4/+4
| | | | entries not showing
* [statistics_reporting] Fallback to ip if client has no hostnameSimon Rettberg2017-04-031-1/+1
|
* [statistics_reporting] Don't return so many NULL fields from queriesSimon Rettberg2017-04-031-2/+2
|
* [statistics_reporting] fixed column selector orderUdo Walter2017-02-231-6/+6
|
* [statistics_reporting] included currently offline clients in offline time + ↵Udo Walter2017-02-231-64/+107
| | | | bugfixes + some comments
* [statistics_reporting] Fix 'Not assigned' row not showing up in locations ↵Simon Rettberg2017-02-081-5/+5
| | | | grouping anymore
* [statistics_reporting] Consistent field naming across classes, templates etc.Simon Rettberg2017-02-081-4/+4
|
* [statistics_reporting] Use indexed fields for joins, return location id from ↵Simon Rettberg2017-02-071-6/+6
| | | | GetData::*
* [statistics_reporting] fixed incorrect medianUdo Walter2017-02-061-0/+3
|
* [statistics_reporting] i18n: Move tags used in code to separate file, delete ↵Simon Rettberg2017-01-191-2/+2
| | | | unused tags
* [statistics_reporting] improved anonymizationUdo Walter2017-01-171-8/+9
|
* [statistics_reporting] added vm name anonymizationUdo Walter2017-01-171-1/+1
|
* [statistics_reporting] improved cutoff in query functions + bugfixUdo Walter2017-01-131-37/+54
|
* [statistics_reporting] moved some functions to a new classUdo Walter2017-01-121-0/+153