Report which Services are using Enterprise Geodatabase Data Stores
I've seen organizations have many Data Store connections created for ArcGIS Server. It's difficult to know which services are referencing which Data Store connection, and it may be necessary to update these Data Store connections. For example, if your SQL Server database is migrated to a new instance, you will want to create a new SDE connection file to this instance, and update the Data Store connections. More information about this can be found here.
The attached script will iterate through all services and report which Data Store connection they are referencing. This can be helpful to clean up Data Store connections not being used, and finding which ones will need to be updated.
The script will need to be executed by a user that has access to the \arcgissystem\arcgisinput directory. Example of report:
Note: If a service is listed twice in the CSV report, this indicates the service has data referencing multiple Data Store connections.
