Remove users that have been inactive

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.

2 posts
First unread post

2 posts

Remove users that have been inactive#828326

By sefres - Wed Aug 19, 2020 8:57 am

- Wed Aug 19, 2020 8:57 am #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

Re: Remove users that have been inactive#830011

By marceloayllon - Fri Jun 24, 2022 4:15 pm

- Fri Jun 24, 2022 4:15 pm #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