Metabase Queries

Up to date by September 2021

Author: Danilo Lessa Bernardineli (BlockScience)

Groups of User and Login IPs

SELECT 
    handle,
    ip_address,
    count(1) as num
FROM dashboard_profile
INNER JOIN dashboard_useraction 
ON dashboard_useraction.profile_id = dashboard_profile.id
WHERE action = 'Login'
GROUP BY handle, ip_address
ORDER BY num DESC