SQL query :: Returns author for each connector

[atallec]

Hi,

I am looking for an SQL query that returns two colums:
1] the author name, 2] the connector name

The t_object table has an author column whereas the t_connector doesn't.

Any idea ? Thanks !

Alexandre Tallec

[Geert Bellekens]

You can't since EA doesn't store the author for connectors.
(Auditing might, I'm not sure)

You could of course return the author for the source of the connector, counting on the fact that it is probable that the other of the source object also is the one that created the connector. :-/

Geert

[qwerty]

The author is (likely) stored in one of the bincontent columns of t_snapshot - but in zipped format. For a SQL not really available.

q.

[Rodrigo Nunes]

see if it helps with this query.

select top  10 t_object.Author, t_object.Object_ID, t_connector.Name from t_object
inner join t_connector
on t_object.Object_ID = t_connector.End_Object_ID

[qwerty]

That's like Geert suggested the creator of one of the connected elements, but not of the connector itself.

q.