MSSQL Analyses related to user administration

User-Related

This article offers examples for a user administration related analyses with the dashboard.

Number of created and total users per month

SELECT
concat(DATEPART(yy, ident.creationTime),'-', DATEPART(mm, ident.creationTime)) AS Month,
SUM(1) AS Number,
(SELECT
COUNT(*) FROM view_identity
WHERE identitytype = 'USER' AND
concat(DATEPART(yy, creationTime),'-', DATEPART(mm, creationTime)) <= concat(DATEPART(yy, ident.creationTime),'-', DATEPART(mm, ident.creationTime))
) AS Total
FROM view_identity ident WHERE identitytype = 'USER'
GROUP BY concat(DATEPART(yy, ident.creationTime),'-', DATEPART(mm, ident.creationTime));