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

[MonsterCable]

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

Thanks

 

[Larry_Jones]

Ummm ... yeah. P0092 - User Profiles

 

[MFreitag]

F0092 as Larry said, join F0101 on AN8 if you want your address book data with it

 

[mateo31]

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

 

[Kim Schmidt]

Mateo, are you looking for users having activity in the current year regardless if their logon is currently enabled or not?

 

[DSauve]

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).

 

[MFreitag]

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.

 

[mateo31]

Ok thanks to all !

 

[JDEspecialistITWORKS]

Is there anything here that lists companies that currently use JD Edwards software?

 

[DSauve]

That would be one of Oracle's customer lists - probably not likely to get that one

 

[MFreitag]

Is there anything here that lists companies that currently use JD Edwards software?

Now that's one way to do acquisition