How can I find the Thing associated with a Value Stream?

[dbologna]

I am using Thingworx 8.5 and I have the number of some Value Streams, how can I find the name of the Thing associated with those ValueStreams?
Thanks
Dimitri

[Rocko]

Not sure what you mean by "the number" of some value streams, I suppose you mean the name?

In 8.5, it's probably the fastest to export all things to Entities.xml and searching for the VS name.

You could probably also run a SQL against the DB querying for all distinct entity_id for your VS, but then you might miss the ones that have the VS assigned, but not currently an entry in it (e.g. due to purging).

[dbologna]

Thanks for the reply. Extracting all the Things in XML format and then searching for the ValueStream value seems like a cumbersome procedure to me. The strange thing is that from Console, opening a ValueStream, there is the 'View Relationship' and 'Used This Entity' tabs that should refer to a service that returns where this object is used. Wouldn't it be enough to know the name of this service or at least understand what it does to extract the information that is presented?
Thanks

Dimitri

[Rocko]

I said it's the fastest option, not the most elegant one (think a smiley here it gets filtered out)

TBH, 8.5 is quite old and I am not sure what is already in there or not. Newer versions to have this relationship tab and once you enable "referenced by" in the relationship subsystem you could use that to show the dependencies. Check the documentation for that here: https://support.ptc.com/help/thingworx/platform/r9.5/en/index.html#page/ThingWorx/Help/Composer/Relationships.html#

The GetWhereUsed service might help you, but again - I am not sure how much of that is already implemented or made available in 8.5

I am pretty confident though that this relationship is unidirectional and that any solution would have to iterate over the things.

[nmutter · Accepted solution]

The service it uses is GetIncomingDependenciesAsNetwork:

You might need to filter these results - not sure how many other dependencies there may be using this ValueStream

Is this what you searched? Not so sure

This is with TWX 9.6 - so service name may differ? but you can check in network tab when visiting the mashup if its not this one for twx 8.5