I have found a solution to get members per AD group by using a T-SQL query & wanted to share this. The query ran for 00:15:47, returned 3005 rows for the 759 users in system.
Some results have been hidden because they may be inaccessible to you
Show inaccessible results