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
line inputs auto expand

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

Version 3.7

Hello Vysakh, I am afraid 3.7 community is not av[…]

Fortunately, there are several ways to do it: some[…]

s data analytics courses in hyderabad a top-rated[…]