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

[Fal]

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

[Obi_1_Cinobi]

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-...

[Fal]

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.