Hi everyone! I'm new to managing Tailscale for my team and kept losing track of which nodes were up. So I built a simple internal dashboard to monitor them.
I used Airbyte to pull data from the Tailscale API (list devices endpoint) into BigQuery. Then set up a dbt model to clean it and flag stale nodes. The dashboard is just a Looker Studio report on top of that.
Here’s the core of the dbt model for determining status:
```sql
WITH device_data AS (
SELECT
name,
last_seen,
addresses
FROM {{ source('tailscale_api', 'devices') }}
)
SELECT
name,
last_seen,
CASE
WHEN TIMESTAMP_DIFF(CURRENT_TIMESTAMP(), last_seen, HOUR) > 24 THEN 'stale'
ELSE 'active'
END AS status
FROM device_data
```
It's basic, but really helps me! Curious if others have built similar internal tools. How do you handle monitoring?