I don't do exactly what you are asking, but I do use the manifest.json to search for a resource (.gdb) in the service so I know if I need to stop the service before I replace the .gdb. Since I can search, I would think you could just list. I don't have time to clean my code up right now, but I'll add a snippet so you can see part of how I'm doing it. BTW, all the myMsgs can be replaced with print or arcpy.AddMessage ...I just have a generic function to handle both.
elif ".GPServer" in startedService:
gpServicePath = os.path.join(configServicesPath, startedService)
gpJsonPath = os.path.join(gpServicePath, "esriinfo", "manifest", "manifest.json")
myMsgs("\n Testing GP Server: {0} ...check the json file.".format(startedService))
if arcpy.Exists(gpJsonPath):
myMsgs(" Found manifest.json for {0}".format(startedService))
"""myMsgs(" ->Found...open")
jsonFile = open(gpJsonPath, 'r')
jsonData = json.load(jsonFile)
jsonFile.close()
jsonDatabases = jsonData['databases']"""
searchTerm = baseCurrentFGDB
with open(gpJsonPath) as json_data:
d = json.load(json_data)
try:
onServerConnectionStringValue = (d['databases'][0]['onServerConnectionString'])
myMsgs(" Check if {0} IN onServerConnectionStringValue".format(searchTerm))
sourceUsed = (searchTerm in onServerConnectionStringValue)
if sourceUsed:
myMsgs(" {0} is being used, add to list of services to stop".format(searchTerm))
update = True
myMsgs(" +Adding {0}".format(startedService))
updateServicesList.append(startedService)
else:
myMsgs(" Skipping...source not used for service: {0}".format(startedService))
except:
myMsgs(" Skipping...onServerConnectionStringValue not in json for {0}".format(startedService))
else:
myMsgs(" ->oops...not right {0}".format(gpJsonPath))
"""if not mxdFound:
myMsgs("\n Didn't find an mxd for {0} \n ....GP service?".format(startedService))"""
else:
myMsgs("{0} not a map or gp, what is it?\n".format(startedService))
