topic Re: Get Data Source for ArcGIS Map Service Layers in ArcGIS Enterprise Questions

Get Data Source for ArcGIS Map Service Layers

MeleKoneya — Tue, 24 May 2016 22:47:44 GMT

I am looking for some programmatic way to get the underlying data source used for a Map Service Layer. We use mostly SDE layers, so I would like the Feature Class Name.

I was able to do this with ArcObjects with C# .NET prior to 10.1 but I don't believe it can be done the same way due to the changes in ArcGIS Server architecture

Does anyone have any code examples of getting the layer sources?

I may end up using the MXD to compile data sources, but would like to go against the map services directly if possible.

Thanks,

Mele

Re: Get Data Source for ArcGIS Map Service Layers

AdrianWelsh — Wed, 25 May 2016 04:47:01 GMT

Mele,

Are you wanting to get the data source of your own company's Map Services? Or are you hoping to get the data source of any Map Service you find in ArcGIS Online?

Re: Get Data Source for ArcGIS Map Service Layers

MeleKoneya — Wed, 25 May 2016 15:31:16 GMT

Adrian,

Thanks for the reply.

I am looking for the data source of our organization's map services that are hosted on our internal ArcGIS Server not those on AGOL.

Mele

Re: Get Data Source for ArcGIS Map Service Layers

George_Thompson — Wed, 25 May 2016 16:05:56 GMT

Looks like you might be able to collect that information via ArcPy

Alphabetical list of arcpy.mapping functions—Help | ArcGIS for Desktop

Alphabetical list of arcpy.mapping classes—Help | ArcGIS for Desktop

Hope this helps gets you pointed in the correct direction.

Python python snippets

Re: Get Data Source for ArcGIS Map Service Layers

BillDaigle — Wed, 25 May 2016 16:27:47 GMT

I think you'll need to go back to the source mxd. I don't believe the originating source information is exposed via the service.

Re: Get Data Source for ArcGIS Map Service Layers

JonathanQuinn — Wed, 25 May 2016 22:17:36 GMT

If you go to ArcGIS Server Manager, then click on the Service Workspaces button next to the Service name and the type of service, (it looks like a geodatabase/database icon), you can see the workspaces the data in the service resides in. You can expand the workspace to see the individual feature classes in the service. These are Rest calls, so take a look at the web traffic when traversing the Service Workspaces windows.

Re: Get Data Source for ArcGIS Map Service Layers

RebeccaStrauch__GISP — Thu, 26 May 2016 00:40:43 GMT

If you have to go back to the mxd to do it programatically, you may want to see if there is something in this sample tool

http://www.arcgis.com/home/item.html?id=7d6f7b4548f64d7ca8ba5cf73b0d9932

Custom Toolbox providing a compact/detailed MXD description. Run in ArcMap/ArcCatalog.
The selected mxd file is analyzed and the result is saved in a txt report file. No need to open the Map Document.

I have done something similar, but I think I only grabbed the info for broken links. Python addin for data inventory and “broken-link” repair. so this tool might have more (I have not tested...just saw it as I was looking at the other samples)

Re: Get Data Source for ArcGIS Map Service Layers

ModyBuchbinder — Thu, 26 May 2016 05:02:45 GMT

When you publish mxd to map service the mxd is copied to C:\arcgisserver\directories\arcgissystem\arcgisinput\<serviceName>.MapServer\extracted\v101\<serviceName).mxd

You can get this file, open it (arcpy or ArcObjects) and get all information.

Do not change it!!

Have fun

Mody

Re: Get Data Source for ArcGIS Map Service Layers

pheede-esri — Sun, 29 May 2016 15:01:24 GMT

Mele Koneya: Adding to Jon's answer, you may want to take a look at this GitHub sample https://github.com/pheede/agsadmin-devsummit. Specifically the GetServiceManifest method in https://github.com/pheede/agsadmin-devsummit/blob/master/ArcGISRESTAdmin/AGSClient.cs which uses the REST Admin API to do this.

Re: Get Data Source for ArcGIS Map Service Layers

MeleKoneya — Mon, 30 May 2016 15:40:48 GMT

Thanks for the samples! This looks like I was looking for. I like that it is in C# too. I will work with it this week.

Re: Get Data Source for ArcGIS Map Service Layers

MeleKoneya — Mon, 28 Aug 2017 20:25:11 GMT

Philip,

I am finally getting back to this, but am not getting the information I want. Below is the code that I am using. Can you see what I am doing wrong?

Thanks,

Mele

namespace ConsoleApplication1

{

class Program

{

static void Main(string[] args)

{

AGSClient Client = new AGSClient("https://MyServer:6443/arcgis/admin", "User", "PWD");

Task<Dictionary<string, ArcGISRESTAdmin.Classes.ServiceReport[]>> taskServiceReports = Client.GetAllServiceReports();

Dictionary<string, ArcGISRESTAdmin.Classes.ServiceReport[]> dctServiceReports = taskServiceReports.Result;

foreach (KeyValuePair<string, ArcGISRESTAdmin.Classes.ServiceReport[]> kvp in dctServiceReports)

{

string theKey = kvp.Key;

ArcGISRESTAdmin.Classes.ServiceReport[] serviceReports = kvp.Value;

for (int x = 0; x < serviceReports.Length; x++)

{

string serviceName = serviceReports.serviceName;

string configuredStatus = serviceReports.status.configuredState.ToString();

Task<ServiceManifest> manifest = Client.GetServiceManifest(serviceReports, "");

}

Re: Get Data Source for ArcGIS Map Service Layers

MeleKoneya — Tue, 29 Aug 2017 19:03:33 GMT

Found this presentation that helped me out:

Home | Esri Video

Re: Get Data Source for ArcGIS Map Service Layers

MeleKoneya — Wed, 30 Aug 2017 17:50:34 GMT

This is what I ended up doing with the GitHub Code from Philip Heede. Works great.

https://github.com/pheede/agsadmin-devsummit

static async Task DoWork()
{
AGSClient Client = new AGSClient("https://server:6080/arcgis/admin/", "user", "pwd");

await Client.Authenticate();

            Console.Out.WriteLine("Authenticated against {0}: {1}", Client.ServerUrl, Client.IsAuthenticated);
            Console.Out.WriteLine("Session expires at {0}", Client.TokenExpiration.ToLocalTime());
            Console.Out.WriteLine("------------------");

// get status of all services in all folders

var folders = await Client.GetFolderNames();

            Console.Out.WriteLine("The following folders are defined on the server:");
            Console.Out.WriteLine("/");
            foreach (string folder in folders)
            {
                Console.Out.WriteLine(folder);
            }
            Console.Out.WriteLine("------------------");

var taskServiceReports = await Client.GetAllServiceReports();

            foreach (string folder in taskServiceReports.Keys)
            {
                Console.Out.WriteLine(folder);
                foreach (var report in taskServiceReports[folder])
                {
                    Console.Out.WriteLine(folder);
                    Console.Out.WriteLine(string.Format(" - {0}: {1}", report.serviceName, report.status.realTimeState.ToString()));
                    var manifest = await Client.GetServiceManifest(report, report.folderName);

                    foreach (var db in manifest.databases)
                    {
                        //Console.Out.WriteLine(db.onPremiseConnectionString);
                        foreach (var ds in db.datasets)
                        {
                            Console.Out.WriteLine(ds.onServerName);

                        }
                    }

                }
            }
            Console.Out.WriteLine("------------------");


        }

Re: Get Data Source for ArcGIS Map Service Layers

TomBell1 — Tue, 26 Jun 2018 23:23:33 GMT

Thank you! Thank you!

Re: Get Data Source for ArcGIS Map Service Layers

Arne_Gelfert — Sun, 12 Dec 2021 16:11:27 GMT

the server copy of the MXD seems to be a very little known fact that I just recently had to explain to someone. It would be crazy to think the link between map service and MXD would otherwise be lost. What I've used is something like the below. I can run this locally if I've shared the server directory.:

import glob
for item in glob.glob('//myserver/arcgisserver/directories/arcgissystem/arcgisinput/**/*.mxd',recursive=True):
   print(item)

Re: Get Data Source for ArcGIS Map Service Layers

AndresCastillo — Thu, 09 May 2019 19:40:26 GMT

Is this the video?

https://www.esri.com/videos/watch?videoid=WxUFh0c9hNw&title=ArcGIS%20Enterprise%3A%20Architecting%20Your%20Deployment

Re: Get Data Source for ArcGIS Map Service Layers

SE_GIS_BWDB — Sun, 13 Aug 2023 06:04:45 GMT

link is dead