List N-rep users who haven't been seen in the last X to Y days
Q&A for professional mathematicians
-- Users missing in action -- List N-rep users who haven't been seen in the last X to Y days select Id as [User Link], Reputation, LastAccessDate, DATEDIFF (day,LastAccessDate,GETDATE()) [Last seen days] from Users where Reputation > ##SearchForRepGreaterThan:int## and DATEDIFF (day,LastAccessDate,GETDATE()) between ##MinDaysSinceSeend:int## and ##MaxDaysSinceSeen:int##