User Tools

Site Tools


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.
en:software:dashboard:analyses:administrative_analyses_oracle

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)