I have used this in the past:
def main():
import arcpy
import os
# output file (change this)
report = r"D:\Xander\Domains\list_unused_domains.txt"
# database connection (change this)
conn = r"C:\Users\xbakker\AppData\Roaming\ESRI\Desktop10.2\ArcCatalog\Dev 10.2.sde"
# set encoding to utf-8 (for non ASCII chars)
import sys
reload(sys)
print sys.getdefaultencoding()
def_enc = sys.getdefaultencoding()
sys.setdefaultencoding('utf8')
with open(report, "w") as f:
f.write("Domains not in use\n")
# create list of domains
domains = arcpy.da.ListDomains(conn)
lst_names = [domain.name for domain in domains]
# list featureclasses
arcpy.env.workspace = conn
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(ws, 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("{0}\n".format(dom))
# restore default settings
sys.setdefaultencoding(def_enc)
if __name__ == '__main__':
main()This does not get you the full list of domains that are in use. It is possible (and I have seen cases) where a column used with a default value in a subtype uses domain 'a' while the field itself uses domain 'b'. So if you have subtypes, you should check the domains in use by the subtypes too Use arcpy.da.ListSubtypes(featureclass).
Kind regards, Xander
