=====Administrative Auswertungen=====
==== Anzahl an erstellten und gesamten Usern pro Monat ====
<code sql>
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')) 
</code>