Latest Contributions by ChristianWells

Did a little digging and found this enhancement for the non-admin user ability: NIM096849 If you get the chance to call into support sometime, we can attach you to this defect. ... View more

Thanks Jose, this tool only does work for the administrative user but this sounds like a good enhancement request to me.  However, it is it still possible to see users connected a few other ways. The simplest method is to do a selection from the Geodatabase process_information table. This should have the same information you were seeing from sdemon -o info -I users. This table by default is accessible through the public role, so any user will be able to select from it.  I know this goes without saying, but only selections should be run against this table, no edits.  ... View more

In Python you can use arcpy.ListUsers() or use the GDB Administration window by right-clicking on the database connection in ArcCatalog and choosing Administration > Geodatabase Administration ListUsers—ArcPy Functions | ArcGIS for Desktop  ... View more

Hi Guido Stein‌, as the Python API is still in Beta, I would recommend posting your questions to the user forums on the Esri Early Adopter Community: https://earlyadopter.esri.com/project/home.html?cap=035D6DE6E9674EF8A396B8C29CA3C6B1  On those forums the Product Team and Support are actively looking at issues and providing responses there. Best, Christian ... View more

Starting at 10.1 you can connect to SQL Server as a standalone database (non-geodatabase) you can read the addresses from there. After the addresses are geocoded, the entire table can be exported to the standalone database. Editing data, however, is limited to geodatabases. Connect to SQL Server from ArcGIS—Help | ArcGIS for Desktop  ... View more

Although not supported, you can use the SQL Server 11.0 client to connect to older releases of the database. From your ArcGIS Desktop machine, which client are you using?: 1. From the start menu search for and run ODBC Data Sources (32-bit) 2. When the window appears, click the tab: Drivers 3. Look for SQL Server Native Client ... View more

You could use a replace function to change your commas to new line characters: ls = ['rangedate_D032495_20160822124736.txt', 'rangedate_D032498_20160822125645.txt', 'rangedate_D032499_20160822125129.txt', 'rangedate_D032500_20160822125032.txt', 'rangedate_D032501_20160822125559.txt', 'rangedate_D032502_20160822125356.txt', 'rangedate_D033108_20160822125458.txt'] print str(ls).replace(',', '\n') #Output: ['rangedate_D032495_20160822124736.txt' 'rangedate_D032498_20160822125645.txt' 'rangedate_D032499_20160822125129.txt' 'rangedate_D032500_20160822125032.txt' 'rangedate_D032501_20160822125559.txt' 'rangedate_D032502_20160822125356.txt' 'rangedate_D033108_20160822125458.txt'] #If you want to replace the square brackets we can handle that as well: print str(ls).replace(',', '\n').replace('[', '').replace(']', '') #Another option: for i in ls:     print i #Output: rangedate_D032495_20160822124736.txt rangedate_D032498_20160822125645.txt rangedate_D032499_20160822125129.txt rangedate_D032500_20160822125032.txt rangedate_D032501_20160822125559.txt rangedate_D032502_20160822125356.txt rangedate_D033108_20160822125458.txt‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍ ... View more

Thanks Forest, you should be able to remove all the users pretty quickly using the following arcpy command.  gdb = r'Database Connections\w1041.sde' arcpy.DisconnectUser(gdb, 'ALL')‍‍‍‍ DisconnectUser—ArcPy Functions | ArcGIS for Desktop  The SDE command line tools have a similar function, but as they are deprecated, it may be best to start working with the arcpy module.  ... View more

Schema locks should only be managed through the ArcGIS clients. If locks need to be removed, the supported and recommended way is to disconnect users via the Geodatabase Administration window in ArcGIS Desktop.  Manage geodatabase locks—Help | ArcGIS for Desktop  What is happening that requires locks to be removed via SQL? Are they being orphaned? ... View more

When creating views using the Create View tool, only the select statement needs to be passed. The semi-colon is also going to throw an error and needs to be removed.  For example, just try this part: SELECT (OBJECTID, LABEL, LOGDT, SHAPE) FROM schemaowner.TRUCK_HISTORY_3HR WHERE OBJECTID > 0 ... View more

Here is the steps on adding code blocks to GeoNet: https://community.esri.com/people/huffmanp/blog/2014/07/08/how-do-we-add-code-blocks-in-this-new-forum  To add to bixb0012‌ comments, can you post the output of your script, perhaps in a txt file? ... View more

On the case sensitive error, Enterprise Geodatabases are only supported with a case-insensitive name. The reason for this is that ArcGIS does not delimit any objects in SQL Server, other than user names: Enterprise geodatabase size and name limits—Help | ArcGIS for Desktop  "However, ArcGIS does not delimit object names. Do not create any tables, feature classes, databases, users*, roles, or other object names that require delimiters if you will be using it with ArcGIS. The object will be created in the database, but you cannot access it from ArcGIS." Can you provide an example of the name of the database you are getting this error with? On your question about running this tool for all databases, the answer is yes. Creating a geodatabase must be done on each database that requires ArcGIS Geodatabase functionality. However, if you have a large number of them, this can be done via Python. Set up an enterprise geodatabase in SQL Server—Help | ArcGIS for Desktop  ... View more

Hi Jens, Similar to your other post, can you put this in the Early Adopter Community forums? https://earlyadopter.esri.com ... View more

Hi Jens, Please post any Python API Beta questions over in the Early Adopter Community as this product is still in beta. https://earlyadopter.esri.com  ... View more