This website uses cookies. By clicking Accept, you consent to the use of cookies. Click Here to learn more about how we use cookies.
Accept
Reject
Community FAQ
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Show  only  | Search instead for 
Did you mean: 
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Show  only  | Search instead for 
Did you mean: 

[Help] Lansweeper Cloud Report - Get the list of users who are not members of a O365 Group

Fal
Engaged Sweeper

‎06-06-2023 04:14 PM - last edited on ‎04-01-2024 01:00 PM by

Hello,

I'm trying to create a new custom Report in Lansweeper Cloud. The goal is to get the list of users who are not members of specific O365 groups.

With a SQL request, it's quite simple, but do you know if it's possible to do that with a MongoDB Query?

Thank you

Labels:
0 Kudos
2 REPLIES 2
Obi_1_Cinobi
Lansweeper Tech Support
Lansweeper Tech Support

‎06-07-2023 05:17 PM

Hello there!

In case it helps, Esben recently did a video on advanced cloud reporting: https://community.lansweeper.com/t5/pro-tips/pro-tips-40-chatgpt-amp-advanced-reporting-in-cloud/ba-...

0 Kudos
Fal
Engaged Sweeper
In response to Obi_1_Cinobi

‎06-07-2023 06:00 PM

Hello,

Yes I watched the video but it doesn't help me to create a request to get M365 users who are not members of a list of M365 groups. I continue to investigate, but any help is welcome. 

0 Kudos

Reports & Analytics

Ask about reports you're interested in and share reports you've created. Subscribe to receive daily updates of reports shared in the Community.

New to Lansweeper?

Try Lansweeper For Free

Experience Lansweeper with your own data.
Sign up now for a 14-day free trial.

Try Now