@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\n")
# 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}\n")
print("Finished")
