Page 1 of 1

query on processmaker database for users that have never logged in or don't have cases

Posted: Mon Aug 17, 2020 8:18 am
by sefres
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.