how to see who hasn't looged into Moodle

[beeswax]

Is there a way to query a Moodle site to find out who hasn't yet logged in? We went live in September and I need to find the pockets of resistance and obliterate them.

[ChrisH]

When I look at our user list it states when they last logged on, if ever.

[danIT]

Heres a MySQL query that will show you all the users that have never logged on to Moodle:

 

select * from mdl_user where lastlogin = 0;

 

Here is patch listed in the Moodle Tracker which should add the functionality required:

 

[#MDL-15502] Bulk user actions should include a filter option to select users who have never logged in - Moodle Tracker

[beeswax]

When I look at our user list it states when they last logged on, if ever.

 

With nearly 1500 users I'm hoping to avoid going down that path.