Questions and discussion about developing processes and programming in PHP, JavaScript, web services & REST API.
Forum rules: Please search to see if a question has already asked before creating a new topic. Please don't post the same question in multiple forums.
By sefres
#828326
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
#830011
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
Multiple Uploader in Grids

RubyGarage provides professional web development c[…]

Hello omarvillada Please make sure to have tis […]

Notice: Creole.php

Hello ptmi1047, Please make sure to have tis lin[…]

hi i am need link download processmaker 3.7 lower[…]