Sage 100

Here's what I provided to a 4.5 client a few years ago:

I'm guessing you're referring to the "Activity Log " in Sage 100 (Library Master > Reports).  And yes, that report can take a VERY long time to run on some systems, although the data can optionally be extracted via Crystal Reports or Excel or other ODBC options.  And while it likely will show information about when individual users logged into Sage 100, it won't necessarily show what they've performed – unless it's certain functions like Period-End Processing, Utilities and the like.  I did locate an off-the-shelf Enhancement that tracks when a user logged in and out of Sage, but that doesn't help in knowing what the user performed.  There's also certain Sage 100 files that maintain Creation/Update information, ibnlt Customers, Vendors, Items, S/O Entry and P/O Entry, but for any Updates you wouldn't necessarily know specifically what the user changed – although the module-specific Audit Reports (if enabled) will yield that info.

tableName = "" : sStartProgram = "" : sUserCode = "" : busContext = ""
tableName = oBusObj.GetTable("main")
sStartProgram = oSession.StartProgram
sUserCode = oSession.UserCode
busContext = "StartProgram: " & sStartProgram & " - TableName: " & tableName & " - UserCode: " & sUserCode
oSession.WriteLog "M", "Scripting can write to the activity log! " & busContext

Here's what I provided to a 4.5 client a few years ago:

I'm guessing you're referring to the "Activity Log " in Sage 100 (Library Master > Reports).  And yes, that report can take a VERY long time to run on some systems, although the data can optionally be extracted via Crystal Reports or Excel or other ODBC options.  And while it likely will show information about when individual users logged into Sage 100, it won't necessarily show what they've performed – unless it's certain functions like Period-End Processing, Utilities and the like.  I did locate an off-the-shelf Enhancement that tracks when a user logged in and out of Sage, but that doesn't help in knowing what the user performed.  There's also certain Sage 100 files that maintain Creation/Update information, ibnlt Customers, Vendors, Items, S/O Entry and P/O Entry, but for any Updates you wouldn't necessarily know specifically what the user changed – although the module-specific Audit Reports (if enabled) will yield that info.