Maintnance domains

Question

Hello,
I am thinking about how I could use a python script to audit my domains in the sde database.
I would like to be able to:
- make an inventory of the existing domains
-Identify duplicates in the domains
-Identify domains used in services
-identify the owners of the domains
- extract domains in CSV format
-remove duplicate domains not in use
- automate this script to run every month
Has anyone thought about this problem or has a script to do this?
Thank you in advance.

blake.terhune · Answer

I also came up with a script that will delete unused domains. It should be a good starting point for doing the other things you mentioned.

Delete Unused Domains - Esri Community

Anonymous User · Answer

Thank you @JakeSkinner 
this will get me started.

jskinner · Answer

@Anonymous User,

Here is a script that will list which domains are no longer in use.  This can be a good starting point to perform some of the other maintenance tasks you're looking to do.

import arcpy, os, sys

# Variables
report = r"C:\Temp\Python\list_unused_domains.csv"
gdbConnection = r"C:\DBConnection\SQL SERVER - DBO@VECTOR.sde"

# Create report of domains not in use
with open(report, "w") as f:
    f.write("Domains not in use
")

# create list of domains
    domains = arcpy.da.ListDomains(gdbConnection)
    lst_names = [domain.name for domain in domains]

# list featureclasses
    arcpy.env.workspace = gdbConnection
    lst_fds = arcpy.ListDatasets(feature_type="feature")
    lst_fds.append("")
    lst_doms = []
    for fds in lst_fds:
        lst_fc = arcpy.ListFeatureClasses(feature_dataset=fds)
        for fc in lst_fc:
            try:
                flds = arcpy.ListFields(os.path.join(gdbConnection, fds, fc))
                for fld in flds:
                    if fld.domain != "":
                        lst_doms.append(fld.domain)
            except:
                pass

# process tables
    lst_tbl = arcpy.ListTables()
    for tbl in lst_tbl:
         try:
             flds = arcpy.ListFields(tbl)
             for fld in flds:
                 if fld.domain != "":
                    lst_doms.append(fld.domain)
         except:
             pass

# create list of domains not in use
    lst_notinuse = list(set(lst_names) - set(lst_doms))

# write to file
    for dom in lst_notinuse:
        f.write(f"{dom}
")
print("Finished")