Alfresco audit entries by user name

alfresco-audit-entries-by-user-name.sql

SELECT
    COUNT(*) AS entry_count,
    s.string_value AS user_name
FROM
    alf_audit_entry a
JOIN
    alf_prop_value p ON a.audit_user_id = p.id
JOIN
    alf_prop_string_value s ON p.long_value = s.id
GROUP BY
    s.string_value
ORDER BY
    entry_count DESC;