---
# System prepended metadata

title: Metabase Queries
tags: [Info]

---

---
tags: Info
---


# Metabase Queries

:::info
Up to date by September 2021
:::

*Author: Danilo Lessa Bernardineli (BlockScience)*

**Groups of User and Login IPs**

```sql 
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
```