View SDE item dependencies within an organization?

GeneH_Chesco

Much like how GEO-Jobe's Admin Tools for ArcGIS Online allows administrators to view item dependencies for layers or maps in ArcGIS Online, is there a tool administrators of an SDE database can use to view all of the MXD's within an organization that depend upon a SDE layer in ArcGIS Enterprise?

Our county would like to clean up SDE layers no longer used by any current initiatives across the entire organization, so a tool like GEO-Jobe's but for SDE layers not online layers would be extremely helpful.

George_Thompson

Here is a starting point: How To: Use Python to list the data sources of all layers in the table of contents of a map document 

import arcpy mxd = arcpy.mapping.MapDocument("CURRENT") for lyr in arcpy.mapping.ListLayers(mxd):     if lyr.supports("DATASOURCE"):         print "Layer: " + lyr.name + "  Source: " + lyr.dataSource

I tested this on my test MXD and it listed both file geodatabase and enterprise geodatabase sources. The enterprise geodatabase are linked to the connection files used (i.e. "name.sde").