Commit message (Collapse) | Author | Age | Files | Lines | |
---|---|---|---|---|---|
* | Revert "[statistics_reporting] Consider all machines in DB" | Simon Rettberg | 2024-02-07 | 1 | -6/+3 |
| | | | | | | | | | | 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 DB | Steffen Ritter | 2024-01-25 | 1 | -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 complaints | Simon Rettberg | 2023-11-14 | 1 | -21/+14 |
| | |||||
* | Roundup of issues reported by PHPStorm | Simon Rettberg | 2023-11-02 | 1 | -5/+3 |
| | | | | Mostly redundant checks, logic errors, dead code, etc. | ||||
* | [statistics_reporting] Report legacy VMware CPUs | Simon Rettberg | 2023-09-25 | 1 | -0/+9 |
| | |||||
* | [statistics_reporting] Future-proof mem check :> | Simon Rettberg | 2023-09-25 | 1 | -1/+1 |
| | |||||
* | [statistics_reporting] Add GPU type counts | Simon Rettberg | 2022-04-13 | 1 | -1/+1 |
| | |||||
* | Moderize Database handling | Simon Rettberg | 2021-05-11 | 1 | -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 counts | Simon Rettberg | 2020-12-03 | 1 | -0/+16 |
| | | | | References #3781 | ||||
* | [statistics_reporting] Fix json types, add duration field | Simon Rettberg | 2020-10-22 | 1 | -1/+4 |
| | |||||
* | [statistics_reporting] Add missing group statement | Simon Rettberg | 2020-10-22 | 1 | -1/+2 |
| | |||||
* | [statistics_reporting] Add exam statistics | Simon Rettberg | 2020-10-22 | 1 | -4/+31 |
| | |||||
* | [statistics_reporting] Fix numer of unique users and server CPU model | Simon Rettberg | 2020-06-29 | 1 | -2/+1 |
| | |||||
* | [statistics_reporting] Don't consider machines not recently used | Simon Rettberg | 2020-01-17 | 1 | -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 Rettberg | 2018-02-05 | 1 | -6/+6 |
| | |||||
* | [statistics_reporting] Query rewrite: Use iterative approach | Simon Rettberg | 2018-01-04 | 1 | -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 Rettberg | 2017-12-16 | 1 | -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, userstats | Simon Rettberg | 2017-04-24 | 1 | -0/+63 |
| | | | | This implements #3108 | ||||
* | [statistics_reporting] fixed clients/locations without offline-length ↵ | Udo Walter | 2017-04-04 | 1 | -4/+4 |
| | | | | entries not showing | ||||
* | [statistics_reporting] Fallback to ip if client has no hostname | Simon Rettberg | 2017-04-03 | 1 | -1/+1 |
| | |||||
* | [statistics_reporting] Don't return so many NULL fields from queries | Simon Rettberg | 2017-04-03 | 1 | -2/+2 |
| | |||||
* | [statistics_reporting] fixed column selector order | Udo Walter | 2017-02-23 | 1 | -6/+6 |
| | |||||
* | [statistics_reporting] included currently offline clients in offline time + ↵ | Udo Walter | 2017-02-23 | 1 | -64/+107 |
| | | | | bugfixes + some comments | ||||
* | [statistics_reporting] Fix 'Not assigned' row not showing up in locations ↵ | Simon Rettberg | 2017-02-08 | 1 | -5/+5 |
| | | | | grouping anymore | ||||
* | [statistics_reporting] Consistent field naming across classes, templates etc. | Simon Rettberg | 2017-02-08 | 1 | -4/+4 |
| | |||||
* | [statistics_reporting] Use indexed fields for joins, return location id from ↵ | Simon Rettberg | 2017-02-07 | 1 | -6/+6 |
| | | | | GetData::* | ||||
* | [statistics_reporting] fixed incorrect median | Udo Walter | 2017-02-06 | 1 | -0/+3 |
| | |||||
* | [statistics_reporting] i18n: Move tags used in code to separate file, delete ↵ | Simon Rettberg | 2017-01-19 | 1 | -2/+2 |
| | | | | unused tags | ||||
* | [statistics_reporting] improved anonymization | Udo Walter | 2017-01-17 | 1 | -8/+9 |
| | |||||
* | [statistics_reporting] added vm name anonymization | Udo Walter | 2017-01-17 | 1 | -1/+1 |
| | |||||
* | [statistics_reporting] improved cutoff in query functions + bugfix | Udo Walter | 2017-01-13 | 1 | -37/+54 |
| | |||||
* | [statistics_reporting] moved some functions to a new class | Udo Walter | 2017-01-12 | 1 | -0/+153 |