summaryrefslogtreecommitdiffstats
path: root/modules-available/statistics_reporting/inc/queries.inc.php
Commit message (Collapse)AuthorAgeFilesLines
* Revert "[statistics_reporting] Consider all machines in DB"Simon Rettberg2024-02-071-6/+3Star
| | | | | | | | | | Revert these changes that would result in different results. We're still not entirely clear how to handle the case of missing machines vs. machines that just haven't been used for quite some time. So instead of changing this now and possibly again in the near future, leave it as is for now and then do something more clever in the near future. This reverts commit 5dd6473d2f78d74c005ed20fb2a968f9bcae6ade.
* [statistics_reporting] Consider all machines in DBSteffen Ritter2024-01-251-3/+6
| | | | | | | | | | Don't limit on machines which booted at least once in the last 30 days. Otherwise the number of machines in statistics_reporting doesn't match the number of clients in rooms/locations or client-statistics which is kinda irritating. We still have the problem, that we don't know which clients still exist in the real world. But that' another story.
* Add function param/return types, fix a lot more phpstorm complaintsSimon Rettberg2023-11-141-21/+14Star
|
* Roundup of issues reported by PHPStormSimon Rettberg2023-11-021-5/+3Star
| | | | Mostly redundant checks, logic errors, dead code, etc.
* [statistics_reporting] Report legacy VMware CPUsSimon Rettberg2023-09-251-0/+9
|
* [statistics_reporting] Future-proof mem check :>Simon Rettberg2023-09-251-1/+1
|
* [statistics_reporting] Add GPU type countsSimon Rettberg2022-04-131-1/+1
|
* Moderize Database handlingSimon Rettberg2021-05-111-3/+3
| | | | | | | * Auto-convert to utf8mb4_unicode_520_ci * Use foreach instead of while to loop over results * Drop useless statement caching * Keep emulated prepares, as we sometimes loop over nested queries
* [statistics_reporting/statistics] Include system/runmode total countsSimon Rettberg2020-12-031-0/+16
| | | | References #3781
* [statistics_reporting] Fix json types, add duration fieldSimon Rettberg2020-10-221-1/+4
|
* [statistics_reporting] Add missing group statementSimon Rettberg2020-10-221-1/+2
|
* [statistics_reporting] Add exam statisticsSimon Rettberg2020-10-221-4/+31
|
* [statistics_reporting] Fix numer of unique users and server CPU modelSimon Rettberg2020-06-291-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