-- Show all Active users who have not logged within 90 days
-- IDXwf is the default name for the GE Web Framework database. This may differ by installation.
SELECT * FROM IDXwf..Users
WHERE LastLogin < dateadd(dd, -90, getdate())
AND Active = 'Y'
Users browsing this forum: No registered users and 1 guest