Table: jumpcloud_user_group - Query JumpCloud User Groups using SQL

JumpCloud User Groups is a feature within the JumpCloud Directory-as-a-Service that allows you to manage and organize users. It provides a way to group users based on certain criteria, such as job function, department, or location. JumpCloud User Groups help you manage access control, enforce policies, and streamline user management tasks.

Table Usage Guide

The jumpcloud_user_group table provides insights into User Groups within JumpCloud Directory-as-a-Service. As an IT administrator, explore group-specific details through this table, including group IDs, names, and types. Utilize it to manage access control, enforce policies, and streamline user management tasks.

Examples

Basic info

Explore which user groups exist within your system, identifying them by their unique attributes such as name and type. This can be useful for understanding the structure and organization of your user groups.

select
  name,
  id,
  type
from
  jumpcloud_user_group;

select
  name,
  id,
  type
from
  jumpcloud_user_group;

List groups with samba authentication enabled

Determine the areas in which user groups are using Samba authentication. This can be useful for understanding which groups have this specific feature enabled, providing insights into your network's security protocols.

select
  name,
  id,
  type
from
  jumpcloud_user_group
where
  samba_enabled;

select
  name,
  id,
  type
from
  jumpcloud_user_group
where
  samba_enabled = 1;

List unused groups

Identify instances where user groups within JumpCloud are not being utilized. This can help streamline your system management by removing or repurposing these unused groups.

select
  name,
  id,
  type
from
  jumpcloud_user_group
where
  members is null;

select
  name,
  id,
  type
from
  jumpcloud_user_group
where
  members is null;

Schema for jumpcloud_user_group

Name	Type	Operators	Description
_ctx	jsonb		Steampipe context in JSON form.
id	text	=	A unique identifier for the user group.
members	jsonb		A list of the users associated with the group.
name	text		Display name of a user group.
organization_id	text	=, !=, ~~, ~~, !~~, !~~	Specifies the ID of the organization.
posix_groups	jsonb		A list of POSIX groups.
samba_enabled	boolean		If true, samba authentication is configured for the group.
sp_connection_name	text	=, !=, ~~, ~~, !~~, !~~	Steampipe connection name.
sp_ctx	jsonb		Steampipe context in JSON form.
title	text		Title of the resource.
type	text		The type of the group.

Export

This table is available as a standalone Exporter CLI. Steampipe exporters are stand-alone binaries that allow you to extract data using Steampipe plugins without a database.

You can download the tarball for your platform from the Releases page, but it is simplest to install them with the steampipe_export_installer.sh script:

/bin/sh -c "$(curl -fsSL https://steampipe.io/install/export.sh)" -- jumpcloud

You can pass the configuration to the command with the --config argument:

steampipe_export_jumpcloud --config '<your_config>' jumpcloud_user_group