How to Speed Up PowerShell Script for Fetching MS Graph Group Members?

I handle a similar task using the Graph API directly. Instead of querying user groups individually, I fetch the group members in pages of 500 with the following URI:

`https://graph.microsoft.com/v1.0/groups/GROUPOBJECTID/members/microsoft.graph.user?$select=id,employeeId,userPrincipalName,signInActivity&$count=true&$top=500`

Just replace 'GROUPOBJECTID' with your actual group ID. But keep in mind, while you can fetch all users by sign-in activity, filtering within a specific group can be tricky in large environments.

Also, make sure you're aware there are alternative methods to accomplish your goals more efficiently. I’m working on automating a process to remove licenses from accounts without a company name that haven't signed in this year. This might involve dynamic groups and group-based licensing if that’s within your scope.

I've recently tackled a similar problem, and I found it much faster to use `Get-EntraUser` to fetch all users at once and reference their sign-in activities from there. It's just one query that takes a bit of time initially, but it’s definitely worth it. Here’s a simplified snippet from my workflow:

```powershell
# Connect to Entra using Microsoft Graph
Connect-Entra -Scopes 'User.Read.All','AuditLog.Read.All' -NoWelcome

$entraUsers = Get-EntraUser -All -Property 'UserPrincipalName', 'SignInActivity'
```
After that, you can easily filter based on your criteria. Also, I'm currently looking at how to incorporate last user action times from Exchange mailboxes, but that's been a bit of a challenge!

I can confirm that including `SignInActivity` when using `Get-MGUser` can significantly slow things down, especially if done in a loop. You might want to first query without it, gather your list, and then check sign-in activity afterward, which should lessen your API calls.

It looks like you're hitting the Graph API multiple times unnecessarily. Instead of querying the group for different filters and then pulling user details again, try to get everything in one go. Just remember, querying `SignInActivity` is going to make things a bit slower. You might want to pull a list of users who've never signed in separately and then locally compare that to speed things up.