[sefres]

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

[marceloayllon]

Hello sefres,

Although the table USERS, has a field USR_LAST_LOGIN, apparently it is never filled, what I suggest is that you use a report table, to be able to save information of your cases and then know who worked them and who did not through a trigger with a simple query.

I leave the link for you to consult: https://wiki.processmaker.com/3.1/Report_Tables