Global project Management

[Typia]

Hi guys,
we currently use EA12 with a SQL Server DB as project repository.

Is there any way to have a global view for the projects to check last updated time, last user to update the project and so on ?

Many thanks

[qwerty]

Either you write a dedicate search for that (there are a couple pre-defined ones). Or you stick to the audit feature (see the help).

q.

[Typia]

Either you write a dedicate search for that (there are a couple pre-defined ones). Or you stick to the audit feature (see the help).

q.

Thanks a lot for your help (again)
audit feature may suit but I need to have a global view for projects and see which one where updated lately and eventually who updated it.
With audit feature I have to open each project and go through it, which would be a pain (unless I misunderstood)
I tried to make direct sql searches on the server but only result i get are database structure changes and not data modification.
Where could I find the predefined searches you're talking about ?

[qwerty]

E.g. (Ctrl-F) Common Searches/Recently ...

Each search is over one single repository. If you open EA projects externally (EAP is MSAccess), you can run a SQL for the ModifiedDate columns in various tables.

q.

[Paolo F Cantoni]

Without additional functionality, you can't tell WHO modified something last.

EA only records the original author.  It records the modified date, but not the updater.  In an enterprise setting, the original author is almost of no consequence, but knowing who last updated it is.

We have previously requested that EA provide an option to record the last updater in the author field, but so far to no avail.  Why not submit another request?

Auditing imposes a load on the system (and perhaps my be overkill for most needs)

HTH,
Paolo

[qwerty]

An alternative could be to (anyway recommended) turn on security with Require User Lock to Edit and write a trigger on t_seclocks.

q.