It’s so helpful to have an Excel list of the username data contained in multiple PWA Security Groups. So, we thought we’d make a blog post with the solution! You can easily achieve this if you only have a handful of PWA Security Group Usernames. But, what if you have more than a few users? You may have noticed there is no nifty “Export to Excel” button in the ribbon to save you this time.
You’ll find the secret to extracting users from PWA Security Groups in the HTML source code. There are two ways we can go about locating the User list in HTML source code, but both require you to access your PWA Security Group. We’ll outline both ways below.
Prep Work
Firstly, you will need to access your PWA Security Group, and navigate to Manage Groups.
Go into your PWA environment by right-clicking on the cog wheel located at the top right-hand corner.
Select “PWA settings”, then Under Security section, click on “Manage Groups”
On the Group Name in the “Users” section, select the PWA Security Group you would like to extract Username data from.
While it might vary for your set up, we accessed our HTML under “Portfolio Managers”, where you’ll find this data located in a container labelled “Selected Users”.
Time Saver Approach to Extract PWA Security Group Usernames
Once you’re inside your desired PWA Security Group, right click on the web page to for the pop-up window to pop up.
Select and click on “View page source”.
This will open a new browser window with all the HTML source code, which can be edited.
Use the Find command (Control + F or Command + F) and type into the search bar: