How to find who has logged on and who has not for a particular period of time

Hi,

Is there any way to find out the users who have not logged on for a particular period of time.

e.g. If i want to find out the users who have not logged on to JDE since the last one month, how can i get it or lets say if i want to find who has logged in and who has not in the past one month, how can i get it

Regards,
Irfan

Information not easily obtained nor tracked per se in E1. One starting point if you don't delete logs is to go through any security server logs. If you are iSeries and you have unique system users, with some work, you could probably obtain it via iSeries logs.

There was a thread a few months back about turning on F9312 in the INI.
We use this to watch sign-on's or lack there of.



Also watch changing passwords, lets auditors know we are watching the
system.



Rich Brown | JD Edwards System Administrator | Actus Lend Lease

T 707 256 1574 | F 707 254 3149 | M

455 Devlin Road, Suite 100, Napa, CA 94558

[email protected]

This information isn't too difficult to come up with.

First of all, you need to ensure that you are auditing your security - this is activated in the JDE.INI on the application server side - under the [SECURITY] section, make sure you have "HISTORY=1"

This will now log all your logins to the F9312 security history table - and occassionally (if the user logs out correctly) the log outs as well.

This logs the following information in SHEVTYP :
01 Sign-on
02 Sign-off
03 Password Change
04 System Administrator Change
05 Add User
06 Delete User
07 Add F00950 Record
08 Delete F00950 Record
09 Modify F00950 Recrod
10 Add User to F0092
11 Delete User From F0092
12 Modify User in F0092
13 Add User/Role Relationship
14 Remove User/Role Relationship
15 Modify User/Role Relationship
16 Data Item Type Change
17 Data Item Size Change
18 Signatures Turned On
19 Signatures Turned Off
20 Auditing Turned On
21 Auditing Turned Off
22 Pass Through User Turned On
23 Pass Through User Turned Off
24 Real Time Notif Turned On
25 Real Time Notif Turned Off
26 Pre-populate User Turned On
27 Pre-populate User Turned Off

You can access this information from P98OWSEC|FORM exit|SECURITY HISTORY

Lastly, SHUPMJ in the table will show whether a user has logged in - use the following SQL :

<font class="small">Code:</font><hr /><pre>
select distinct(SHUSER), max(SHUPMJ)
from sys7333.f9312
where SHEVTYP = '01'
and SHUSER not in (select distinct(SHUSER) from sys7333.f9312 where SHUPMJ >106162)
group by SHUSER
order by SHUSER
</pre><hr />

This should provide a list of all users that haven't logged in since June 11th 2006 - even those that are not active.

If you just want active users - then try

select SCUSER from sys7333.f98owsec where SCSECLST < 106162

That will just give you a list of ACTIVE user ID's that haven't logged in since June 11th 2006 (100 days ago as of todays date)

Irfan

Run P00960. This application will give you what you are looking for.

Patty

Hi Sully

I hate to disagree - but P00960 is very inaccurate - since it shows only the machine identification table. If you have citrix users then it will only list the last user to have logged into the citrix server - and of course multiple users might log in and it will only show the last one. Even if you only run fat clients in your enterprise - if a machine is being "shared" between users (for example, in a manufacturing facility where users share a PC for shift work) it will skew the results since only the LAST logged in user will display.

Hope that helps !

Jon

You are correct. This app works pretty well at our site since we are mostly fat client and don't normally share pc's. We do have users using WTS but these users sign on everyday.

Patty

This is not the answer to your question,but still see if its helpful [For OS400 machines]
To find out how many users are logged into your system.
1. Enter command WRKSYSSTS (Display System Status) on command line.
2. Use function key F21 to set the value for "Assistance Level" to 1=Basic.
3. On line number 9 the number of signed on users is displayed.

If you are on a later version of OneWorld (8.9x) - then Alex Pastuhov of Everest Software also has a new tool - "Total Rapport" - which provides indepth reporting of user activity.

This is a new tool that Alex has created - but in effect the main purpose is to automatically open on the client the PDF files created on the server (incl. WEB).

This is achieved by introducing code, as a DLL, executed within Internet Explorer.

Now, because this code can see and do practically anything, plus because it needs to maintain the list of currently logged-in users and their computer names, it has a number of extremely powerful side-effects:

1. Detailed logging of all user activity: Timestamp, JDE User Name, Windows User Name, Computer Name, Applications started (incl. UBE's and VER's) - (only for WEB users)

2. Communication back to these users, possibly including forced disconnect

3. Lots of Windows functionality for the WEB clients: reading JDE screens and doing local actions (i.e.: message boxes, file manipulation, additional entry boxes or lookups, communications - e-mail, TCP/IP, hardware integration, etc.), or doing something locally and populating JDE screens
(e.g.: barcode readers, etc.)

Some of this is not yet implemented. You might want to contact Alex for a demonstration prior to implementing the tool !

If you are a Citrix shop and you keep your citrix user profiles separate from their general user profiles, then you can check the date on the jde.log file in their citrix profile.