Query for Logged In Users?

One of our users runs a script in the evening to modify data. Once in awhile, they will receive an error that data is locked by user. I know that we can kick users by going into Help > Current Users, but I was wondering if there is a table containing this info? If so, I could create a script to alert the admin team in advance of the script that they can kick any users in the system.

For reference we are running Sage 300 2017. (Upgrading to 2023 in a few months)

Parents
  • 0

    Also check for any third-party modules such as Orchid DML which place an object in the Task Tray that will prevent those users from logging out properly even if they have closed Sage 300.  Also, as per other user suggestions, try stopping the App Pools in IIS relating to Sage 300 which may resolve the issue.  Cheers...Tim

Reply
  • 0

    Also check for any third-party modules such as Orchid DML which place an object in the Task Tray that will prevent those users from logging out properly even if they have closed Sage 300.  Also, as per other user suggestions, try stopping the App Pools in IIS relating to Sage 300 which may resolve the issue.  Cheers...Tim

Children
No Data