query how many users created in the last 4 days
SELECT *
FROM [identityiq].[identityiq].[spt_identity]
where DATEADD(s, created/1000, '1970-01-01 00:00:00') > DATEADD(day, -4, GETDATE());
IIQ Select query on date EPOC Print
Created by: Yaniv Rozenzweig
Modified on: Mon, 3 Nov, 2025 at 8:41 PM
Did you find it helpful? Yes No
Send feedbackSorry we couldn't be helpful. Help us improve this article with your feedback.