List of all JD Edwards EnterpriseOne User IDs with the user's name

Is there a way to see a list of all the E1 user IDs + their names? Roles and security are not a concern. Just need to see their user IDs



Active Member
Just to complete the topic, is there a way to extract/identify only ACTIVE users? (for instance, from the beginning of the year)? Thks


Legendary Poster
Assuming you've enabled security history, you can join the F0092 table to the F9312 table and find F9312 records that have occurred since the beginning of the year (in your case).


Well Known Member
You can also join F98OWSEC and only select 01 records (=active) and also roles that have access etc. - depends on your general setup for sure.