I’ve been looking into Zammad’s
karma_activity_logs in the database, to get an idea of users and their proficiency in using advanced features. Here’s a query I’ve used to get the karma scores of people who have been active in Zammad in the past day (excluding customers).
Note that Zammad’s policy is to discourage people from manually querying the database, as a mistake is easily made and could cause unintended side-effects or even damage your install, leading to data loss. You have been warned.
SELECT CONCAT("firstname", ' ', "lastname") AS "Name", login AS "Account", score_total AS "Karma (total)"
( SELECT DISTINCT ON (u.login) u.firstname, u.lastname, u.login, kal.score_total
FROM karma_activity_logs kal
JOIN users u ON (u.id = kal.user_id)
JOIN roles_users rol ON (u.id = rol.user_id )
WHERE rol.role_id <> 3
AND kal.created_at BETWEEN (CURRENT_DATE - '1 day'::interval) AND CURRENT_DATE )
ORDER BY score_total DESC;
A high or a low score could mean a lot of things though, it is probably best not to make any assumptions about scores or base performance reviews solely on those numbers.
You could probably query for specific karma events and count those actions per user. I might look into that myself whenever I have some spare time, as I am also interested in that data about our agents.