Can we list Thingworx entities which are created by a specific user in Thingworx ?

[koushal]

Hi All,

I just want to list out those entities which are created by a a specific user. Is we have something in Thingworx?

[raluca_edu]

Hi,

There is no out of the box service for that.

I don't know if it helps, but you can see owner if you export entities in xml format.

Raluca Edu

[wposner-2 · Accepted solution]

If you have direct access to the TWX DB you could create a secondary JDBC connection to it and then write a query on your new DB thing that looks in the public.thing_model table to get you this information.

[slangley]

Hi @koushal.

If one of the previous responses answered your question, please mark the appropriate one as the Accepted Solution for the benefit of others with the same question.

Regards.

--Sharon

[CarlesColl]

Hi,

If wan't be super speedy, but you can do as follow:

var result = Resources["SearchFunctions"].SearchAll().thingResults;
result.AddField({name: "owner", baseType: "STRING" });
var creator
for each(row in result.rows) {
    try {
        creator =  eval(row.parentName)[row.name].GetConfigurationChangeHistory().Find({ changeAction: "CREATE" });
        if (creator!==null) {
            row.owner = creator.user;
        }
    } catch(error) {}
}

[CarlesColl]

Sorry, this is to get all entities owner, you just need to filter by the desired user and you are done.