Users¶
List logged in users¶
SELECT
s.pk,
p.username,
CASE
WHEN s.ip IN ('83.150.12.146', '::fff:83.150.12.146') or s.ip like '2001:8e3:5396:c92:%'
THEN 'tocco office'
ELSE s.ip
END AS ip,
now() - s.timestamp as age
FROM nice_session AS s LEFT OUTER JOIN nice_principal AS p ON s.fk_principal = p.pk
WHERE s.timestamp > now() - interval '30m'
ORDER BY s.timestamp desc;