Disconnect database connections

CameronMcCormick

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!!

RussellBrennan

Here is a script that I have used with a little bit more flexibility than using the 'All' keyword.

# Import necessary modules. import arcpy, datetime   # Set the admin connection -> this user needs to have privilegs to disconnect users. adminConnection = r'Database Connections\dbo@testDB@testServer.sde'   # Get a list of connected users. uList = arcpy.ListUsers(adminConnection)   # Print the number of connected users count = len(uList) print 'There are currently {0} users connected\n'.format(count)   # Exception lists -> these are used to determine machine names or users # which will not be disconnected. Leave blank if there are no exceptions machines = ['devinci','rocky'] users = ['samhill', 'stevepeat', 'stevesmith']   # Get current time. now = datetime.datetime.now()   # Get time a week ago weekAgo = now - arcpy.time.EsriTimeDelta(7, 'days')   # Iterate through users for u in uList:     if u.ConnectionTime < weekAgo:         if u.ClientName.lower() in machines:             print "Skipping user: {0} on machine: {1}".format(u.Name, u.ClientName)             print "Machine name is on exception list.\n"         elif u.Name.lower() in users:             print "Skipping user: {0} on machine: {1}".format(u.Name, u.ClientName)             print "User's name is on exception list.\n"         else:             try:                 arcpy.DisconnectUser(adminConnection, u.ID)                 print "Successfully disconnected user: {0}\n".format(u.Name)             except:                 print arcpy.GetMessages()     else:         print "User ({0}) connection time did not exceed the set limit.\n".format(u.Name)   # Get a list of connected users. uList = arcpy.ListUsers(adminConnection)   # Print the number of connected users count = len(uList) print 'There are currently {0} users connected'.format(count)   print 'Done'