Search for users with 0 posts in admin panel?

[Staxed]

Is it possible to find users with 0 posts via the search for users function? All I see is "users with at least x posts". I want "users with less than x posts"...from what I can see, I can't find users that haven't posted at all...am I missing it?

 

[Paul B]

It's not possible to search for users with 0 posts or less than x posts.

I have suggested it though quite a while ago.

 

[Floris]

phpMyAdmin

SELECT * 
FROM  `xf_user` 
WHERE  `xf_user`.`message_count` =0

Would this be the right query Brogan to manually find users with 0 msgs ?

 

[Paul B]

Looks good to me Floris

You could also omit the 'xf_user'. from the last line like so:

SELECT *
FROM xf_user
WHERE message_count = 0

 

[Staxed]

It's not possible to search for users with 0 posts or less than x posts.

I have suggested it though quite a while ago.

/runs off to like that thread