Liste des utilisateurs qui font une action

1

Hello,
I want to list from the sql server, the list of users who have not done any action for a given period but I don’t know which tables to use.
Cordially

2

Hello,
In USERS table, you have a field “DATE_LAST_VISIT” that can be useful.

It’s not exactly what you want (connect on WFG != do something) but it can be a first step.

Best regards

3

Bonjour,
Merci pour votre aide, c’est un premier pas mais cela devrait me permettre d’avancer.
Cordialement.

4

You should look at the WFACTIVITY_INST table.

Here is a query that might help you. It will return a list of users with the last time they updated an activity.

SELECT
	*
FROM (
	SELECT 
		ROW_NUMBER() OVER(PARTITION BY ID_USER_ASSIGNEE ORDER BY AI.DATE_UPDATE DESC) AS RowNumber,
		AI.DATE_UPDATE AS LAST_UPDATE,
		U.*
	FROM 
		USERS U
		JOIN WFACTIVITY_INST AI ON U.ID_USER = ID_USER_ASSIGNEE
	) AS Temp
WHERE
	RowNumber = 1
5

Merci, je vais essayer cette requête :ok_hand: