topic Re: Duration of Connection for User in Data Management Questions https://community.esri.com/t5/data-management-questions/duration-of-connection-for-user/m-p/514114#M29187 <HTML><HEAD></HEAD><BODY><SPAN>Thanks for the clarification. This is not something that will be possible with 10.1. We do not keep a log in the database of what users were connected and for how long. You would need to do something like you suggested to get the currently connected users and subtract their connection time from the current time.</SPAN></BODY></HTML> Tue, 10 Jan 2012 19:57:41 GMT RussellBrennan 2012-01-10T19:57:41Z Duration of Connection for User https://community.esri.com/t5/data-management-questions/duration-of-connection-for-user/m-p/514111#M29184 <HTML><HEAD></HEAD><BODY><SPAN>What is the recommended approach for reporting how long the user was connected, since ConnectionTime is The time when the user made the initial connection to the geodatabase?&nbsp; I mean, I know I could use Time, or datetime, to get a Now value, and then subtract that value from ConnectionTime, but I would not know when the user was disconnected, if they were disconnecting themselves, other then constantly pinging the database with ListUser and searching for specific users.&nbsp; Is there a way to easily achieve this with the new capability at 10.1 that i am not seeing off hand using arcpy?</SPAN><BR /><SPAN>[INDENT][/INDENT]</SPAN></BODY></HTML> Mon, 09 Jan 2012 18:30:20 GMT https://community.esri.com/t5/data-management-questions/duration-of-connection-for-user/m-p/514111#M29184 TedCronin 2012-01-09T18:30:20Z Re: Duration of Connection for User https://community.esri.com/t5/data-management-questions/duration-of-connection-for-user/m-p/514112#M29185 <HTML><HEAD></HEAD><BODY><SPAN>Ted, can you please clarify. The way I read the question is that you want to be able to find out how long a user was connected to a database whilst you are disconnecting them?</SPAN></BODY></HTML> Tue, 10 Jan 2012 15:50:30 GMT https://community.esri.com/t5/data-management-questions/duration-of-connection-for-user/m-p/514112#M29185 RussellBrennan 2012-01-10T15:50:30Z Re: Duration of Connection for User https://community.esri.com/t5/data-management-questions/duration-of-connection-for-user/m-p/514113#M29186 <HTML><HEAD></HEAD><BODY><SPAN>Nope.&nbsp; What I mean is I can get basic reporting now, based on the 10.1 functionality.&nbsp; I would like to get a report on how long a specific user was connected.&nbsp; The current capability allows to report on when they connected </SPAN><SPAN style="font-style:italic;">initially</SPAN><SPAN>, not on how long they were connected.&nbsp; Is that possible?&nbsp; I am not disconnecting them.&nbsp; I want to be able to report a user who connects to my database, then they log off.&nbsp; I then run a script that tells me user Steve connected at 10:30am, did a sync to our database and then they logged off.&nbsp; I would then use this information for network optimization.&nbsp; Does this clarify more, Russell?</SPAN></BODY></HTML> Tue, 10 Jan 2012 18:40:37 GMT https://community.esri.com/t5/data-management-questions/duration-of-connection-for-user/m-p/514113#M29186 TedCronin 2012-01-10T18:40:37Z Re: Duration of Connection for User https://community.esri.com/t5/data-management-questions/duration-of-connection-for-user/m-p/514114#M29187 <HTML><HEAD></HEAD><BODY><SPAN>Thanks for the clarification. This is not something that will be possible with 10.1. We do not keep a log in the database of what users were connected and for how long. You would need to do something like you suggested to get the currently connected users and subtract their connection time from the current time.</SPAN></BODY></HTML> Tue, 10 Jan 2012 19:57:41 GMT https://community.esri.com/t5/data-management-questions/duration-of-connection-for-user/m-p/514114#M29187 RussellBrennan 2012-01-10T19:57:41Z