Get the list of map services where table "xyz" is used

Question

I have an SDE feature class:

And I'm looking to find, to how many map services it is pointing.

There are like duplicate map services pointing to same table, so I was trying to figure out how many duplicate services we have.

Is there any script/method to start with?

Feature classes don't ever point at map layers. Map layers point at feature classes. You'd need to compile the sources of every map service layer, and look for duplicates (a dictionary could help). If you had the MXDs from which the services were published, you'd probably have an easier time. — Vince, Oct 29, 2019 at 15:00
@Vince thanks for reply, I have more then 200 services in total and many servers. is there any way to verify by scripting.. i think by manually verifying every mxd source will consume time and for me its hard to get all MXD's — Mr_gemini, Oct 29, 2019 at 15:35
I'd certainly script the MXD content access, which wouldn't require admin access to the ArcGIS Servers; the compilation process would be the same; use data source path as a dictionary key to a list of services, adding new lists and appending to existing. Then you parse the dictionary keys and report all sources with multiple services. — Vince, Oct 29, 2019 at 16:42

Mr_gemini · Accepted Answer · 2019-11-05 16:29:23Z

0

i did it by following steps from here

and verify datasets of every Mapserver

answered Nov 5, 2019 at 16:29

Mr_gemini

1031 silver badge9 bronze badges

Add a comment |

1 Answer 1