How can I view all users currently logged in?

I would like to see who is logged in at any given moment. How do I do this? Our old ERP had a nice function for this and the Master Console doesn't really offer what I am looking for.

I'd like to have this information in real time:

userid; time logged on

Very simple.

Thank you!

  • The Master Console is real time.  If you want the log in time, you can create a Crystal Report based on the SY_ActivityLog table.

  • If you are using Sage 100 Advanced or Premium, you can also check the Application Server Configuration - Sessions - to see connections and how long active (if you are looking for stuck connections or users - you can see which ones show VERY long times).  

    The Sage 100 Activity Log (Library Master, Reports, Activity Log) also records the logins (selecting entry will show detail including login name) but you could also create a Crystal Report (as mentioned before here) to read records from SY_ActivityLog.M4T file in \MAS90\MAS_SYSTEM and filter the records you need, which has the following layout:

       1  LogDate . . . . . . . . . . .     8 SNY  Log Date. . . . . . . . . . . .DATE
       2  LogTime . . . . . . . . . . .     9 SNY  Log Time. . . . . . . . . . . .TIME
       3  CompanyCode . . . . . . . . .     3 SYY  Company Code. . . . . . . . . .COMPANYCODE
       4  UserLogon . . . . . . . . . .    60 SNY  User Logon. . . . . . . . . . .USERLOGON
       5  ModuleCode. . . . . . . . . .     3 SYN  Module Code . . . . . . . . . .MODULECODE
       6  LogType . . . . . . . . . . .     2 SNY  Log Type. . . . . . . . . . . .
                                                    Notes: A=Activity, E=Error,
                                                    M=Miscellaneous
       7  ErrorCode . . . . . . . . . .    10 SNN  Error Code. . . . . . . . . . .
       8  LogProgram. . . . . . . . . .    32 SNN  Log Program . . . . . . . . . .
       9  LogLine . . . . . . . . . . .    10 SNN  Log Line. . . . . . . . . . . .
      10  LogFile . . . . . . . . . . .   128 SNN  Log File. . . . . . . . . . . .
      11  LogDescription. . . . . . . .  4096 SNN  Log Description . . . . . . . .

    .

  • in reply to DGR

    but Activity Log just records entries so you would have to filter information - this is not Real time like the Master Console (or the Sessions in Application Server Configuration - which does not show what they are doing at the moment).  Maybe it would help to know what specific information not in the Master Console you are looking for?