Skip to main content
Jul 10, 2025 8:59 PM UTC
Solved

Ability to Search the Services of a Database Thing for a specific string value

We are using ThingWorx Platform 9.6.  Is there a way to search the services attached to a database thing?  For example, I want to know each service that contains a SQL Server Table named Customers?  Is there a way to search the SQL queries within each service and return a list of all services that contain this table? 

RockoAnswer
Jul 11, 2025 6:18 AM UTC

You can run Resources["EntityServices"].ReadEntityAsJSON() and then browse the result, it's probably somewhere under effectiveShape.serviceImplementations.<SERVICENAME>.configurationTables.Query.rows[0],sql

You will have to iterate over all services and filter for the ones with handlerName="SQLQuery".

2 replies

RockoAnswer
Jul 11, 2025 6:18 AM UTC

You can run Resources["EntityServices"].ReadEntityAsJSON() and then browse the result, it's probably somewhere under effectiveShape.serviceImplementations.<SERVICENAME>.configurationTables.Query.rows[0],sql

You will have to iterate over all services and filter for the ones with handlerName="SQLQuery".

2-Explorer
Jul 15, 2025 4:37 PM UTC

Hi @SB_12787070, 

It appears that this post may answers your question.  For the benefit of other Community Members who may have the same question, it would be great if you could designate it as the Accepted Solution.

In the event that this response did not answer your question, please post your current status so that we can continue to support.

Thanks for using the PTC Community!

Regards,
Abhi