devices

9 rows

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: display_name, ip, hidden

Link rowid ▼ user_id device_id display_name last_seen ip user_agent hidden
4 4 @james:matrix.jamesst.one Oi5QZOyyZJVbV9FPusyh+NPMTx6k2mXS9NJrIdsU5Zw master signing key       1
5 5 @james:matrix.jamesst.one c2IY8LelH/ymXkKQyvY/3lrg6j8m3AFJ8R3Hp/uam4M self_signing signing key       1
6 6 @james:matrix.jamesst.one iWIbAW5bV4xVOjsTw0ZCqng0COyuuZFO6x8TFCOUuvg user_signing signing key       1
8 8 @james:matrix.jamesst.one BLSFYMBGKR telegram-double-puppet 1788591110902 127.0.0.1 mautrix-telegram/0.15.3+dev.unknown mautrix-python/0.21.1 aiohttp/3.14.3 Python/3.13.15 0
11 11 @james:matrix.jamesst.one SZXXSYDHEN chat CLI 1788673193650 2.106.20.143 matrix-rust-sdk 0
12 12 @james:matrix.jamesst.one HMCRCRAOHC app.element.io: Firefox on Linux 1788064849281 2.106.20.143 Mozilla/5.0 (X11; Linux x86_64; rv:154.0) Gecko/20100101 Firefox/154.0 0
13 13 @james:matrix.jamesst.one oOEYiqAZIau+3IABvdDpCR0EsripJsloRjQlM1dZhMQ master signing key       1
14 14 @james:matrix.jamesst.one SXUa7oVbKuTMpVGAGVpvD5hmSVcXyZfj3+u73V0V8jg self_signing signing key       1
15 15 @james:matrix.jamesst.one QAfNc/8DSGAxtcuDvlHkLeYp+D10BsVhwsTXTbESZHY user_signing signing key       1

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

CREATE TABLE "devices" (
    user_id TEXT NOT NULL,
    device_id TEXT NOT NULL,
    display_name TEXT,
    last_seen BIGINT,
    ip TEXT,
    user_agent TEXT,
    hidden BOOLEAN DEFAULT 0,
    CONSTRAINT device_uniqueness UNIQUE (user_id, device_id)
);