Latest Contributions by MDB_GIS

I've found myself acting as the database administrator for our organization despite never having any formal database training, so I have a few questions.  What are the best practices as far as user logins on the sql server? We currently have a "GISadmin" login and then a bunch of individual user logins. The GISadmin login has been used as sysadmin and only used for administrative tasks like reconciling versions and database maintenance. However we have recently had an issue trying to create a parcel fabric on the eGDB and I think it has something to do with the GISadmin having sysadmin privileges. Looking around, it seems like it is recommended that sysadmin versions should not own data. Is that correct? If that is the case, who should there be a designated "data_owner" login that owns all data? If so, what server roles and permissions should that login have?  Adding on to the previous question, are there any other user logins that are considered best practices outside of the standard admin login and individual users? If yes, what are they and what is their purpose and what permissions would they need? Is it better to create users using the ArcGIS Pro tool or in SSMS? I have been using SSMS because, at first, it seemed easier. I could create the login and then map it to all databases at once using the Login>properties>user mapping window and then grant permissions. If I use the arcgis pro tool, I had to run the "Create Database User" tool for each enterprise geodatabase (so in my case 4 times). I recently found out, however, that the arcgis pro tool also creates user schemas in each database, which is not done automatically if you map the user in SSMS. Is there anything else that is missed if you create it using SSMS?  Are there any free/affordable training options for someone out there for someone like me who has no database admin experience but needs to learn it? It would be great if it was geared toward GIS database admin. The problem I'm having is that most sources I have come across don't really touch the GIS side of database administration. I need to find something that will help me better understand the SQL server management side of things while wearing the GIS glasses.  ... View more

I've been doing some spring cleaning of our ArcGIS online organization. In doing so, I kept wanting a way to find out what maps and apps a feature service was used in. That lead me to this thread, which has been very helpful. I am attempting to use @Katie_Clark's excellent version from page two which is set up to run like a GP tool. Here is the code:    from arcgis.gis import GIS import pandas as pd # Log in to portal; 'home' uses the credentials used to login within Pro gis = GIS('home') # Set up input parameters to use in the GUI find_id = arcpy.GetParameterAsText(0) search_type = arcpy.GetParameterAsText(1) find_url = gis.content.get(find_id).url if search_type == 'Web Map': arcpy.AddMessage("Searching for Web Maps. This could take a few minutes...") # Pull list of all web maps in portal webmaps = gis.content.search('', item_type='Web Map', max_items=-1) # Return subset of map IDs which contain the service URL we're looking for matches = [m.id for m in webmaps if str(m.get_data()).find(find_url) > -1] # Create empty list to populate with results map_list = [] # Check each web map for matches for w in webmaps: try: # Get the JSON as a string wdata2 = str(w.get_data()) criteria = [ wdata2.find(find_url) > -1, # Check if URL is directly referenced any([wdata2.find(i) > -1 for i in matches]) # Check if any matching maps are in app ] # If layer is referenced directly or indirectly, append map to list if any(criteria): map_list.append(w) # Some apps don't have data, so we'll just skip them if they throw a TypeError except: continue output = pd.DataFrame([{'title': m.title, 'id': m.id, 'type': m.type} for m in map_list]) arcpy.AddMessage(f"OUTPUT TABLE: \n \n {output}") if search_type == 'Web Application': arcpy.AddMessage("Searching for Web Applications. This could take a few minutes...") # Pull list of all web apps in portal arcpy.AddMessage("1") webapps = gis.content.search('', item_type='Application', max_items=-1) # Create empty list to populate with results arcpy.AddMessage("2") app_list = [] # Return subset of map IDs which contain the service URL we're looking for arcpy.AddMessage("3") matches = [a.id for a in webapps if str(a.get_data()).find(find_url) > -1] # Check each web app for matches arcpy.AddMessage("4") for w in webapps: try: # Get the JSON as a string wdata = str(w.get_data()) criteria = [ wdata.find(find_url) > -1, # Check if URL is directly referenced any([wdata.find(i) > -1 for i in matches]) # Check if any matching maps are in app ] # If layer is referenced directly or indirectly, append app to list if any(criteria): app_list.append(w) # Some apps don't have data, so we'll just skip them if they throw a TypeError except: continue output = pd.DataFrame([{'title':a.title, 'id':a.id, 'type':a.type} for a in app_list]) arcpy.AddMessage(f"OUTPUT TABLE: \n \n {output}")   The tool does work. when searching for web maps, it takes less than a minute on average to run. The problem is if I use the option to search for web applications, it takes 3.5 hours to run. We are a pretty small organization with less than 500 items in our org, so that seems a bit excessive. Is there something I have done wrong in the code that could lead to this? Is there some way I can track what is causing this slow down? I'm very much a python journeyman, so implementing an error reporting method is outside my area of knowledge. Any help you can provide would be appreciated! ... View more

The first error is as follows: It is saying it for every layer in the parcel fabric. I don't understand why I'm getting this error now because in the past, I have been able to publish the parcel fabric before with no issue. I'm not really sure what would have changed. I haven't altered the database owner, which seems to be what it is implying, but it is hard to be sure. The second error is this:   The only layer it says is having this error is "TaxParcels_Lines". All of the other layers are apparently fine. This doesn't really make sense to me because our server is version 10.9.1 and our parcel fabric is version 5 which is compatible with Enterprise 10.9.1.   I would appreciate any help that you can provide!   ... View more