Layer7 API Management

I'm looking for a way to search through all the Web API on our gateway for a specific string in the Route via HTTP assertions. In short, I'm looking for all the Web APIs routing to a certain address.

Is there a way to do this without manually copy/pasting each Web APIs' assertions into a text file?

Try this database query. This would return all the policies containing the string(not restricted to what's on routing assertion).

select a.name,a.routing_uri,b.name from published_service a,policy b where a.policy_goid=b.goid and b.xml like '%searchstring%';

Worked like a charm! Thank you!