I hardly needed the userlist from production OBIEE repository and few minutes of Googling landed me to a blog post by John Minkjan, I have updated his script to write the output to a file with userid, name and groupname columns and thought of sharing with all,
Here is the script with the steps.
Here is the script with the steps.