AnsweredAssumed Answered

Disconnect database connections

Question asked by hr404 on Jan 31, 2013
Latest reply on Dec 12, 2016 by ben_vk
Hello All,
We have an issue with users leaving their PCs on over night (or longer) with connections to our enterprise database.  Unfortunately, this has become quite the issue lately with us running out of connections to the database during the middle of the day, when in reality, there's 5 or more connections left over from a previous day.
I've attempted at using the arcpy.Disconnectuser function, but it seems to only like the ID, from arcpy.ListUsers.
We really need the disconnect function to be based on date.
I'm probably totally overthinking how to get this to work and have scrapped several attempts so far.
Does anyone have a python script that disconnects users based on the ConnectionTime that is generated from arcpy.ListUsers?
Is there a better way?

Thanks for any help!!

Outcomes