ProcessMaker Forum | BPM Workflow Simplified

Hi
Can anyone assist me? I am trying to run a query against the processmaker database to identify all users that have never logged in or have no cases, so that I can delete them. I cannot find the fields that would give me this information. I can see it in the list of users in the admin tab, but I cannot identify how processmaker pulls that data from the database.

Any help would be most appreciated.

Thanks

Hi,

What I can think of is that you can make a script with the use of executeQuery where you can see the LOGIN_LOG table and compare it with USERS and you can see which users never logged in and you can update it to inactive for example to users who never logged in

I pass you the information link so that you can use executeQuery

https://wiki.processmaker.com/3.2/ProcessMaker_Functions/Database_Functions