cancel
Showing results for 
Search instead for 
Did you mean: 
cancel
Showing results for 
Search instead for 
Did you mean: 

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

koushal
12-Amethyst

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

Hi All,

 

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

1 ACCEPTED SOLUTION

Accepted Solutions
wposner-2
12-Amethyst
(To:koushal)

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.

View solution in original post

5 REPLIES 5

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
12-Amethyst
(To:koushal)

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
23-Emerald II
(To:koushal)

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

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) {}
}

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

Announcements