v1.0 for Steampipe, Powerpipe, Flowpipe, 116 plugins, and 44 mods →

steampipe plugin install l-teles/detectifysteampipe plugin install l-teles/detectify

detectify_asset detectify_asset_full detectify_connector detectify_finding detectify_ip detectify_member detectify_policy detectify_port detectify_profile detectify_technology

Table: detectify_member

This table contains information about users who have access to the Detectify platform.

Examples

List all users / members

select
  concat(first_name, ' ', last_name) AS name,
  email,
  authentication,
  role,
  last_login
from
  detectify_member;

List the users that have never logged in

select
  concat(first_name, ' ', last_name) AS name,
  email,
  authentication,
  role,
  last_login
from
  detectify_member
where
  last_login is null;

Group users by authentication method

select
  count(*) as users,
  authentication
from
  detectify_member
group by
  authentication;

Schema for detectify_member

Name	Type	Operators	Description
_ctx	jsonb		Steampipe context in JSON form.
authentication	text		Authentication method used by the user.
created	timestamp with time zone		Timestamp when the user was created.
email	text		Email address of the user.
first_name	text		First name of the user.
last_login	timestamp with time zone		Timestamp when the user last logged in.
last_name	text		Last name of the user.
role	text		Role of the user.
sp_connection_name	text	=, !=, ~~, ~~, !~~, !~~	Steampipe connection name.
sp_ctx	jsonb		Steampipe context in JSON form.
user_token	text		Unique token of the user.