ATF question re: drawing information from a record query to use as reference in a second query

[Josh_]

I am trying to write an ATF test that should be simple, but has one sticking point right at the beginning.

I need to impersonate a member of a specific group.  Best practices say that we should not directly impersonate an existing user, so I have two choices: create one of my own, or try to path my way into impersonating someone in the org who is a member of that group, but whose identity is not fixed.

I query sys_user_grmember to find a user in that group, which is fine.

But the record is a Group Member record, rather than a User record.  There is no way to dot walk my impersonation step to the User field in the Group Member record.  I have tried other, similar paths, but cannot find a way to do it.  I'm sure there is scripting that could do it, but I am unclear as to what would work.

If anyone has an idea as to how this might progress, without creating a new user and assigning all roles and groups, I would appreciate it.

1.  Record query on sys_user_grmember for [group name] and email > is not empty (empty emails are system integration accounts for us).  Current query finds 41 group members.

2.  Would like to impersonate someone from step 1.  But cannot dot walk at all beyond the record ID itself; if I could get to Group Member.User, this is a simple job.

Please advise?

[Josh_]

Yes, unfortunately.

We're having an issue with created users and role/group assignments, so a lot of tests that were working a little while ago are now failing because users aren't being given proper assignments.  I'm looking for a workaround to grab an existing user from a specific group so we don't have to worry about new assignments.  But I believe there is a script posted somewhere below that will do it.

[Ankur Bawiskar]

@Josh_ 

approach shared by @Shaqeel  is easiest

If my response helped please mark it correct and close the thread so that it benefits future readers.