Query: login_from_unrecognized_device

select
  tp_timestamp as timestamp,
action as operation,
concat('https://github.com/', user) as resource,
actor,
tp_source_ip as source_ip,
tp_id as source_id,
*
exclude (actor, timestamp)

from
  github_security_log
where
  action = 'user.login_from_unrecognized_device'
order by
  tp_timestamp desc;