topic Re: Disconnect database connections in Python Questions

Disconnect database connections

CameronMcCormick — Thu, 31 Jan 2013 17:54:51 GMT

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

Re: Disconnect database connections

MathewCoyle — Thu, 31 Jan 2013 18:19:11 GMT

Why don't you just run a scheduled task at night that disconnects all users?

Re: Disconnect database connections

CameronMcCormick — Fri, 01 Feb 2013 10:59:26 GMT

Why don't you just run a scheduled task at night that disconnects all users?

Thanks! I knew I was overthinking this whole situation. The best part was that the ArcGIS Server services reconnected by themselves, which was my initial fear with using "ALL" when this started.

Re: Disconnect database connections

RussellBrennan — Fri, 01 Feb 2013 20:31:38 GMT

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'

Re: Disconnect database connections

CameronMcCormick — Tue, 05 Feb 2013 18:40:22 GMT

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

That is exactly what I was trying to do.
Oddly, my original code looked eerily similar, barring the "arcpy.time.EsriTimeDelta," which is what was giving me the hardest time.
I really need to read through all the modules

Thanks much!!

Re: Disconnect database connections

NickJacob — Tue, 05 Mar 2013 18:34:47 GMT

Thanks! Very helpful and nice use of pro downhiller names 😃

Re: Disconnect database connections

BenVan_Kesteren1 — Sat, 11 Dec 2021 19:36:59 GMT

Hi, the website seems to have killed your code formatting, I have just tidied it up for use myself, thought I would re-post for anyone else that may stumble upon this thread:

# 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'  ‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍