Search for Deactive users

[ATForum]

Is there a way to search for any users who are set to Deactive versus Active?
Thanks.

[In Omnibus]

There is no "deactive" status in vBulletin 5. You'd have to run a query by last login date.

[ATForum]

hmmm... we had some customization done on our forum. They must have added it. Thanks for the response. I'm assuming a query is not a function that is offered to non-tech people (a button I can push). I'm a little saavy but not like most of you guys. Thanks anyways!

[In Omnibus]

You can run something like this in AdminCP > Maintenance > Execute SQL Query:

SELECT * FROM user WHERE lastactivity='2008-11-11'

Obviously you'll want to change the date to whatever last activity date for which you're searching.

[ATForum]

Thanks!