E9.2 Listing of users who have signed into JDE Environment

[CNCTech]

Is there a way I can extract listing of all log in attempts to a specific JDE Environment ? Userid and Date

 

[Kim Schmidt]

Query the F9312 history table. This is populated for every login and logoff event, provided your server's JDE.INI has the correct setting.

 

[CNCTech]

Query the F9312 history table. This is populated for every login and logoff event, provided your server's JDE.INI has the correct setting.

Thanks Kim. I have already reviewed F9312 history table and I dont see environment noted in the table.

 

[ice_cube210]

That's right F9312, unfortunately, does not have the environment. But it does have the host so depending on your architecture you may be able to at least distinguish between Prod and Non-Prod login attempts. F9312 also shows a login record every time a UBE is submitted so depending on why you are collecting this you may need to distinguish those.

Not sure what tools release you are on but if you are on the later releases (9.2.2.x and above) you can use Object Tracking to some extent to extrapolate log in activity and that does record it by pathcode. You can otherwise use some of the commercial monitoring tools for JDE that captures all this information via Server Manager and stores it so you can report off of it later. You can also create your own scripts to use Server Manager REST APIs to collect this user login info from your HTML instances and store it in a database somewhere.

 

[glen7x]

on the newer tools release, you should be able to create a REST call to the server manager to get the list of logged in users on a particular web server. This however is not realtime - as in, you only get the information when you invoke the call.

 

[CNCTech]

Thank you everyone for your suggestion. We are on TS 9.2.2.7 FYI