Garth Colasurdo Posted September 21, 2022 Share Posted September 21, 2022 I can't copy and paste the list from the web. I'd do it by hand, but over three enviornments we have several thousands of users.The License audit only has Name, but this is our IDs from Active Directory. Someone will ask for full names. It would also be super nice to get the Security Groups they belong to, but that is a stretch.This is for WF 9.0 and 8207. Link to comment Share on other sites More sharing options...
Garth Colasurdo Posted September 21, 2022 Author Share Posted September 21, 2022 Update. I have access to the Repository and made my queries there for the list I need. I suppose I could create a report to share with the Admins. We are on a tight deadline and I panicked. Maybe this will help someone. Link to comment Share on other sites More sharing options...
Dirk Kuerbig Posted September 22, 2022 Share Posted September 22, 2022 Thank you Garth, custom reports against the repository always work nicely.Here is an alternative, a shortcut / one time method:* In the WebFOCUS Client Administration Console* on the top right of the screen, there is a menu item labelled "Licenses"* Sub menu "User Audit" gives you access to a list of configured users / groups / privileges and moreDirect link:http://webservername:webserver_portibi_apps/WFServlet.ibfs?IBFS__methodName=auditUserCounts&IBFS1_action=auditUserCountse.g. http://localhost:8080/ibi_apps/WFServlet.ibfs?IBFS__methodName=auditUserCounts&IBFS1_action=auditUserCountsOne of the sections is called "Analysis of Users"* It shows user groups and License types (IA stands for Info Assist / Designer user)You can select this table inside the web page, copy it, and paste it into a spreadsheet, and you have a complete list which you can save, format nicely, and structure the way you need.Hope this helps if you don't have access to the Repository data. Link to comment Share on other sites More sharing options...
Martin Yergeau Posted September 23, 2022 Share Posted September 23, 2022 From the Repository (SQL querry) and to display only what you listed : name, description, last loginSELECT [NAME] ,[DESCRIPTION]-- , ,[LASTLOGIN]-- ,[sTATUS] FROM [<YourRepositoryDBName>].[dbo].[uOA_USERS]ORDER BY 1 Link to comment Share on other sites More sharing options...
Garth Colasurdo Posted September 23, 2022 Author Share Posted September 23, 2022 Thanks for those methods and details. It is funny how I've assumed that select/copy-paste always works on a web interface. :)Also, the information in the Repository is pretty amazing- though I forget about it all the time. When we audit the security groups and who is in each of them, I'm definitely going this route. Link to comment Share on other sites More sharing options...
Patrick Huebgen Posted September 28, 2022 Share Posted September 28, 2022 Hi Garth you can use the WebFOCUS Client adapter as well - Added a short video for you Link to comment Share on other sites More sharing options...
Garth Colasurdo Posted January 24, 2023 Author Share Posted January 24, 2023 This looks fantastic and I'd love to use more of this. However, after configuring the adapter (only WebFOCUS Client REST was available on our 9.0.1) I was able to successfully test in the configuration screen, but it failed elsewhere with a 403 - Access Denied. Is there a Role or Rule a signed in user needs to access example.com/ibi_apps/rs for example? Link to comment Share on other sites More sharing options...
Garth Colasurdo Posted January 24, 2023 Author Share Posted January 24, 2023 This is really good, but I am having a hard time figuring out how to connect the UOA_USERS to UOA_GROUPS. I tried to use UOA_GROUPUSERS, but that table only has 40 rows and would have been expecting several hundred, eg User records x Groups per user. Or are they connected through a different tables? It would seem that the WebFOCUS Client adapter can do it (see below, but I can't get it to work currently). Link to comment Share on other sites More sharing options...
Patrick Huebgen Posted January 24, 2023 Share Posted January 24, 2023 Which user are you using in your adapter config and what is your Security - Single Signon, Tristed Ticket, ...?Try to use an admn user please Link to comment Share on other sites More sharing options...
Patrick Huebgen Posted January 24, 2023 Share Posted January 24, 2023 Client Adapter comes with a sample GET_USERS_WITHIN_GROUP but this will only pull users for one groupTo get all users and groups ....Before I call it a day fo today - here's a tutorial for you Patrick Link to comment Share on other sites More sharing options...
Roberto Trevino Posted January 31, 2023 Share Posted January 31, 2023 I created a custom GET_USERS_WITHIN_GROUP that gets all the users for all the groups.Its a combination of GET_USERS and GET_USERS_WITHIN_GROUP sample reports.I attached it if anyone wants to see how I did it, or use it.I am pretty sure others could come up with a cleaner more elegant solution but it works for me so.¯_(ツ)_/¯ Link to comment Share on other sites More sharing options...
Garth Colasurdo Posted February 1, 2023 Author Share Posted February 1, 2023 Thank you Patrick for the link to your tutorial and channel. There is a lot of great stuff in there. However, it seems that my UOA tables are not populated with the data that reflects our environment. For what ever reason, it only has a hand full of the links between users and groups, though it does have all the users and groups. I have a case open to see why that is and if we can get that UOA_GROUPSUSERS re-populated. Link to comment Share on other sites More sharing options...
Patrick Huebgen Posted February 1, 2023 Share Posted February 1, 2023 Hi Garth, are you using mapped / external Groups in WebFOCUS if yes those are not stored in WebFOCUS as they are pulled dynamically during runtime Link to comment Share on other sites More sharing options...
Patrick Huebgen Posted February 2, 2023 Share Posted February 2, 2023 Hi Garth ae you using externel mapped groups? if this is the case those are not stored in the repository as they are queried as soon as the user logs on? Link to comment Share on other sites More sharing options...
Garth Colasurdo Posted February 16, 2023 Author Share Posted February 16, 2023 Update 2: thanks for the great suggestions. They all would have been THE solution, but, indeed we are using external Active Directory groups to manage the Security Groups. I was able to get my lists with Powershell (learned something new). However, I will have to match the WF Security Groups by hand. 😥 Link to comment Share on other sites More sharing options...
Patrick Huebgen Posted February 17, 2023 Share Posted February 17, 2023 Hi Garth WebFOCUS provides you with an LDAP Adapter - as Active Directory can be queried using LDAP - you can use this to get these groups into WebFOCUS Link to comment Share on other sites More sharing options...
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now