Table: tailscale_device

A Tailscale device is any computer in the Tailnet.

Examples

select
  id,
  name,
  addresses,
  hostname,
  created,
  user
from
  tailscale_device;

select
  os,
  count(*)
from
  tailscale_device
group by
  os
order by
  count desc;

select
  name,
  id,
  created,
  expires,
  hostname
from
  tailscale_device d
where
  d.user = 'luis@turbot.com'
order by
  d.name;

select
  name,
  id,
  created,
  expires,
  hostname
from
  tailscale.tailscale_device d
where
  d.authorized = false;

select
  name,
  id,
  hostname
from
  tailscale_device
where
  tags is null;

select
  name,
  id,
  os,
  user,
  created,
  tailnet_name
from
  tailscale_device
where
  blocks_incoming_connections;

select
  name,
  id,
  os,
  user,
  created,
  tailnet_name
from
  tailscale_device
where
  is_external;

select
  name,
  id,
  os,
  user,
  created,
  tailnet_name,
  last_seen
from
  tailscale_device
where
  last_seen <= (now() - interval '90' day);

select
  name,
  id,
  os,
  user,
  created,
  tailnet_name,
  expires
from
  tailscale_device
where
  expires <= (now() + interval '90' day);

select
  name,
  id,
  os,
  user,
  created,
  tailnet_name
from
  tailscale_device
where
  update_available;

A Tailscale Device represents the devices under a tailnet.

Name	Type	Description
_ctx	jsonb	Steampipe context in JSON form, e.g. connection_name.
addresses	jsonb	The list of device's IPs.
authorized	boolean	Whether the device is authorized.
blocks_incoming_connections	boolean	Whether the device blocks incoming connections.
client_version	text	Version of the client.
created	timestamp with time zone	Device creation time.
device_subnet_routes	jsonb	A list of the device subnet routes.
expires	timestamp with time zone	Device expiry time.
hostname	text	Name of the host.
id	text	An unique identifier of the device.
is_external	boolean	Whether the device is external.
key_expiry_disabled	boolean	Whether the key expiration is disabled.
last_seen	timestamp with time zone	Device last active time.
machine_key	text	Machine key of the device.
name	text	The name of the device.
node_key	text	Node key of the device.
os	text	OS information of the device.
tags	jsonb	The tags applied to the device.
tailnet_name	text	The name of your tailnet.
title	text	Title of the resource.
update_available	boolean	Whether an update is available.
user	text	Name of the owner of the device.