Skip to Main Content
Liongard Library

Welcome to Liongard Library, where Lions share! This is a community-led space where Liongard users can come to teach and learn from one another.
Share custom Metrics, get inspired and see what’s trending in the Pride.

Pride Etiquette:
➕ Have great custom Metrics? Add them as entries!
🌟 Want to use a Metric? Copy the query and
follow this doc.
👍 Tried a Metric from the Library? Like it!
📣 Have a question or feedback on a Metric? Add a comment!
🔎 Not sure where to start? Learn about Metrics and how to write them.
💬 Need help writing a metric or want to help support others? Join the conversation in our Liongard Lounge #metrics slack channel.


🥴 See something off? Open a support chat to let us know.

Categories Google Workspace
Created by Lamont Largie
Created on Jan 22, 2025

Google Workspace - Groups and Members Overview

Category: Google Workspace Management

Description:

This metric pulls a clear list of all Google Workspace groups and their members, helping you stay on top of who has access to what and ensuring your team stays organized.

Purpose:

This metric is your go-to for tracking group memberships in Google Workspace. Whether you're checking if someone was accidentally removed, troubleshooting access issues, or preparing for an audit, it gives you the visibility you need. It’s also handy for monitoring changes to high-priority groups over time.

How it Works:

The metric uses JMESPath to grab a snapshot of all groups and their members from Liongard's Google Workspace inspector. It organizes this data into a readable list with group names and their member lists. Plus, you can enhance it by setting up alerts for changes to specific groups, making it easy to spot unexpected removals or additions.

Use Cases:

  1. Restore Confidence in Troubleshooting: If a user suddenly loses access to something critical, use the historical reports in Liongard to confirm their previous group memberships and figure out when and why they were removed.

  2. Monitor Key Groups: Keep an eye on high-priority groups, like Admins or HR, and get alerts if someone adds or removes members.

  3. Audits Made Simple: Quickly generate a clean report of group memberships for periodic compliance checks or access reviews.

  4. Onboarding and Offboarding: Ensure users are added or removed from the right groups as part of onboarding or offboarding processes.

Beneficiaries:

  • IT Teams: Save time troubleshooting access issues and managing group memberships.

  • Security Teams: Ensure groups are configured properly to minimize risk.

  • Compliance Officers: Use reports to confirm access controls during audits.

Notes for Adjustments:

  • Change Detection: Enable change detection on the Admin>Metrics page to flag modifications in key groups over time. This makes it easy to spot unauthorized changes.

  • Reporting: Schedule reports to compare snapshots daily and highlight any new or removed members.

  • Custom Filters: Refine the output to focus on specific groups, such as those with admin-level permissions, by adding filters like Groups[?contains(name, 'Admin')].

  • Historical Data: Use Liongard’s historical reporting to see group membership as it was at any point in time, ideal for resolving past incidents or meeting compliance requirements.

By tailoring this metric to your needs, you’ll have even more control and insight into your Google Workspace groups and their memberships.

Query

Groups[].[['Name:'name],['Members:'MembersList_r],['-']][]

  • Attach files