I am not aware of how to pull this from the system database but you may be able to look at the Application log on the NT server(s) that are running as APS's.(If you run on NT) There seems to be a message there each time someone logs on.
Create a crystal report to run agains the application event log of the APS machine. Event id is 4001 If you then add this to the Info Desktop you can just run it as needed.
Like I said, there's no easy way to gather this information cleanly. Event ID 4001 only tells you that a user attempted to logon. It doesn't tell you whether or not the user is still logged on. Event ID 4002 tells you that the user logged off.
You could substring User ID's, compare Event ID's and DateTime values. Frankly, its a pain, especially when you can use the the server software mentioned above.
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.