Plugin installed incorrectly. Rename plugin directory 'swiftmail.backup' to 'swiftmail'.
This translation is older than the original page and might be outdated. See what has changed.
Table of Contents
Administrative Analyses
Number of created and total users per month
SELECT concat(to_char(iden.creationtime,'yy'), to_char(iden.creationtime,'mm')) AS Monat, SUM(1) AS Anzahl, (SELECT COUNT(*) FROM view_identity WHERE identitytype = 'USER' AND concat(to_char(creationtime,'yy'), to_char(creationtime,'mm')) <= concat(to_char(iden.creationtime,'yy'), to_char(iden.creationtime,'mm')) ) AS Gesamt FROM view_identity iden WHERE identitytype = 'USER' GROUP BY concat(to_char(iden.creationtime,'yy'), to_char(iden.creationtime,'mm'))
en/software/dashboard/analyses/administrative_analyses_oracle.txt · Last modified: 2021/07/01 09:52 (external edit)
Except where otherwise noted, content on this wiki is licensed under the following license: 2013 T!M Solutions GmbH
