topic Re: How to determine which map services are using a specific data store? in ArcGIS Enterprise Questions

How to determine which map services are using a specific data store?

DurhamGIS — Mon, 22 Jun 2020 20:51:05 GMT

We're trying to track down the map services that are using a specific data store. It seems the closest I can get to that information is with the ArcGIS Data Store command utility's describedatastore (ArcGIS Data Store command utility reference—ArcGIS Data Store (Windows) Installation Guide | ArcGIS Enterprise) command which is limited to the number of current feature layer connections and nothing more. Is it possible to get these details some other way?

Re: How to determine which map services are using a specific data store?

DerrickWong — Tue, 23 Jun 2020 01:44:51 GMT

Hi Durham GIS‌

https://machinename/arcgis/admin

under services > Hosted, navigate to the service of interest.

e.g.

If you click on the edit button at the bottom:

In the JSON, under database > datasource, you should see something like AGSDatastore_ds_xxxxxx

Take note of the above mentioned datastore "id".

Now go into data > items > enterpriseDatabases > <datastore id> and click on edit.

In the JSON, under machines, you should be able to see where the datastore was installed. The service would reside on this datastore on this machine.

Hope that helps.

Regards,

Derrick

Re: How to determine which map services are using a specific data store?

DurhamGIS — Tue, 23 Jun 2020 13:16:41 GMT

Thanks Derrick, I really appreciate the guidance and screen grabs. I checked some hosted FeatureServer services and can see the datastore information but this information doesn't seem to be available for MapServer services.

Re: How to determine which map services are using a specific data store?

JoeCatanzarita — Tue, 23 Jun 2020 13:24:03 GMT

Durham GIS‌

This may be worthwhile to wait and verify from Derrick, however I don't believe Map Services are stored in your ArcGIS Data Store. Hosted content is stored in the ArcGIS Data Store, i.e. Hosted Feature Layers, outputs from Portal Analysis Tools, etc.

Here is some information on Data Store: What is ArcGIS Data Store?—ArcGIS Data Store (Windows) Installation Guide | Documentation for ArcGIS Enterprise

When it comes to Map Services, either you're copying the data directly to ArcGIS Server or you're going to be using a registered connection. If using the registered connection, Server will read the Map Service based on what's being referenced via the source database.

The above workflow seems to be applicable to only Hosted layers.

Best,

Joe

Re: How to determine which map services are using a specific data store?

DurhamGIS — Tue, 23 Jun 2020 13:43:32 GMT

My interest is in the registered data store details. We have several of them with some possible duplication based on the name that was given during the registration process. We didn't want to unregister any data stores without knowing what services are using them.

Re: How to determine which map services are using a specific data store?

DerrickWong — Tue, 23 Jun 2020 15:53:22 GMT

Hi Joe Catanzarita‌

You are correct, the relational datastore stores the Portal's hosted feature layer data. When Durham GIS‌ mentioned ArcGIS DS, i assumed he meant the hosted feature services.

Durham GIS‌, if you were referring to the services published from your Enterprise GeoDatabase, you can navigate to:

...\arcgisserver\directories\arcgissystem\arcgisinput\XXX\extracted\v101 where XXX is the map service name.

The folder will match the structure in the ArcGIS Server REST endpoint:

The mxd (if published via ArcMap) will tell you where the source data resides..

Hopefully, that's what you are looking for.

Regards,

Derrick

Re: How to determine which map services are using a specific data store?

DurhamGIS — Tue, 23 Jun 2020 20:34:18 GMT

That is helpful to know but I was hoping for a REST API solution if possible in order to automate.

Re: How to determine which map services are using a specific data store?

RandyKreuziger1 — Wed, 24 Jun 2020 00:19:04 GMT

I also wish there were a way to rename a registered data store! Publishers have found it very easy to register a enterprise database when publishing but they don't follow our agency's naming scheme. Most publisher register data stores have very vague name and many don't distinguish between dev, test and prod data sources.

Re: How to determine which map services are using a specific data store?

DerrickWong — Thu, 25 Jun 2020 02:52:05 GMT

Hi Durham GIS‌

There isn't one that I am aware of unfortunately. You can however automate it using python/java/C# and their respective ArcGIS API; Have your script loop through the root folder and read each mxd and generate a report for you.

Hope that helps.

Derrick

If this answer was helpful please mark it as helpful. If this answer solved your question please mark it as the answer to help others who have the same question.

Re: How to determine which map services are using a specific data store?

VishApte — Sun, 28 Jun 2020 12:14:38 GMT

If you really want REST API based solution, there is a manifest.json end-point for each map service. e.g.

https://server.FQDN.com:6443/arcgis/admin/services/FOLDER/SERVICE.MapServer/iteminfo/manifest/manifest.json?f=json&token…

This gives you details of database/FGDB connections and layers for each. e.g.

{
"databases": [
{
"byReference": true,
"onServerWorkspaceFactoryProgID": "esriDataSourcesGDB.SdeWorkspaceFactory",
"onServerConnectionString": "ENCRYPTED_PASSWORD=3345435we23232543546456567;SERVER=DBSERVER;INSTANCE=sde:sqlserver:DBSERVER;DBCLIENT=sqlserver;DB_CONNECTION_PROPERTIES=DBSERVER;DATABASE=TESTDB;USER=dbadmin;AUTHENTICATION_MODE=DBMS;BRANCH=sde.DEFAULT",
"onPremiseConnectionString": "ENCRYPTED_PASSWORD=3345435we23232543546456567;SERVER=DBSERVER;INSTANCE=sde:sqlserver:DBSERVER;DBCLIENT=sqlserver;DB_CONNECTION_PROPERTIES=DBSERVER;DATABASE=TESTDB;USER=dbadmin;AUTHENTICATION_MODE=DBMS;BRANCH=sde.DEFAULT",
"onServerName": "sde.DEFAULT (DBSERVER)",
"onPremisePath": "",
"datasets": [
{
"onServerName": "ServiceTerritory"
},
{
"onServerName": "StructureBoundary"
},
{
"onServerName": "WaterDevice"
},
{
"onServerName": "StructureLine"
},
{
"onServerName": "WaterJunction"
},
{
"onServerName": "WaterAssembly"
},
{
"onServerName": "StructureJunction"
},
{
"onServerName": "WaterLine"
},
{
"onServerName": "WaterSubnetLine"
},
{
"onServerName": "WaterDistribution"
},
{
"onServerName": "HydrantMaintenanceInspection"
},
{
"onServerName": "ValveInspection"
}
]
}
],
"resources": [
{
"onPremisePath": "D:\\TEST\\General\\UtilityNetwork\\WaterNetwork\\V2.4\\WaterDistributionUtilityNetwork.aprx",
"clientName": "DBSERVER",
"serverPath": "D:\\AGSEnterprise\\Server\\directories\\arcgissystem\\arcgisinput\\UN\\NapervilleWater.MapServer\\extracted\\p20\\NapervilleWater.msd"
}
]
}

Re: How to determine which map services are using a specific data store?

DerrickWong — Mon, 29 Jun 2020 01:10:54 GMT

Hi Vish Apte‌

Ah yeah, the manifiest.json. Yeah, querying this via REST will definitely work.

Cheers Vish.

Regards,

Derrick

Re: How to determine which map services are using a specific data store?

JonasPersson — Tue, 14 Dec 2021 08:35:10 GMT

Hi VishApte

My experience with the manifest is that you cannot find information on which mapserver layer id that correspond to which dataset. Also, the order of the datasets in the manifest does not correspond to the order of the layers in the map service, even for a simple service using a single database and no group layers.

Do you have a simple way to do this? The only way i've found is to download a complete service backup, extract it and the MSDs inside, then traverse the xml-files inside to connect the layer id with the correct dataset.

Thanks!

Re: How to determine which map services are using a specific data store?

Trevor_Hart — Thu, 24 Mar 2022 07:22:42 GMT

Hi @DurhamGIS sorry to revive an old thread but you should check out Qonda Reports. It does exactly what you are asking. https://getqonda.com/