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

How can i enable the plugin automatically using co[…]

ProcessMaker Acquires Doculayer, Adding Next Gener[…]

Enabling SQL Server in Windows

As soon as the companies are realizing the importa[…]

line inputs auto expand

Hello lilidev, Is there any reason why you are u[…]