/
Oracle Analyses related to user administration
Oracle Analyses related to user administration
- Betül Kara (Deactivated)
Owned by Betül Kara (Deactivated)
Benutzerbezogen
Dieser Artikel bietet Beispiele für eine benutzerverwaltungsbezogene Analyse mit dem Dashboard.
Anzahl der erstellten Benutzer und Gesamtzahl der Benutzer pro Monat
SELECT
CONCAT(CONCAT(to_char(ident.CREATIONTIME,'yyyy'), '-'), to_char(ident.CREATIONTIME,'mm')) AS "Month",
SUM(1) AS "Number",
(
SELECT
COUNT(*)
FROM view_identity
WHERE identitytype = 'USER' AND
CONCAT(CONCAT(to_char(CREATIONTIME,'yyyy'), '-'), to_char(CREATIONTIME,'mm')) <=
CONCAT(CONCAT(to_char(ident.CREATIONTIME,'yyyy'), '-'), to_char(ident.CREATIONTIME,'mm'))
) AS "Total"
FROM view_identity ident WHERE identitytype = 'USER'
GROUP BY CONCAT(CONCAT(to_char(ident.CREATIONTIME,'yyyy'), '-'), to_char(ident.CREATIONTIME,'mm'))
ORDER BY CONCAT(CONCAT(to_char(ident.CREATIONTIME,'yyyy'), '-'), to_char(ident.CREATIONTIME,'mm'));
Related content
MySQL Analyses related to user administration
MySQL Analyses related to user administration
More like this
MSSQL Analyses related to user administration
MSSQL Analyses related to user administration
More like this
Oracle Analyses related to user administration
Oracle Analyses related to user administration
More like this
Oracle Analyses related to processes
Oracle Analyses related to processes
More like this
MySQL Analyses related to user administration
MySQL Analyses related to user administration
More like this
MSSQL Analyses related to user administration
MSSQL Analyses related to user administration
More like this
© TIM Solutions GmbH | AGB | Datenschutz | Impressum