---
tags: Info
---

# Metabase Queries

:::info
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