Author Topic: Any way to check last modifier ?  (Read 2705 times)

Typia

  • EA User
  • **
  • Posts: 69
  • Karma: +0/-0
    • View Profile
Any way to check last modifier ?
« on: June 23, 2021, 10:36:27 pm »
Hi guys,
I may not have looked the right place but I can't find last modifier on an object, only author.
Even in the database on t_object and t_diagram tables I only find Author, createddate and modifieddate fields.

Where can I have information for last modifier ?

Geert Bellekens

  • EA Guru
  • *****
  • Posts: 11251
  • Karma: +415/-33
  • Make EA work for YOU!
    • View Profile
    • Enterprise Architect Consultant and Value Added Reseller
Re: Any way to check last modifier ?
« Reply #1 on: June 23, 2021, 10:42:52 pm »
That info is normally not stored.

You could turn on auditing (be careful, this comes with a cost, your database will start to grow)
Or you could use versioning. In that case you can track the last modifier in the version control system.

Geert

Typia

  • EA User
  • **
  • Posts: 69
  • Karma: +0/-0
    • View Profile
Re: Any way to check last modifier ?
« Reply #2 on: June 23, 2021, 10:45:19 pm »
Thanks for your reply,
currently the only versioning system we use is git and it's not supported by EA.
I'll try auditing and track the size growth.

qwerty

  • EA Guru
  • *****
  • Posts: 12334
  • Karma: +347/-287
  • I'm no guru at all
    • View Profile
Re: Any way to check last modifier ?
« Reply #3 on: June 23, 2021, 10:50:50 pm »
For a more decent DB you could write a trigger to support you with that. On EAP you could utilize an add-in that takes the current user and stores name and element guid in a separate table.

q.

satrman

  • EA User
  • **
  • Posts: 25
  • Karma: +0/-0
    • View Profile
Re: Any way to check last modifier ?
« Reply #4 on: June 23, 2021, 11:37:40 pm »
Data is stored in t_snapshot table - in case of data growth concern, you can make db job to cleanup the older records (t_snapshot has no created_datefield, but our DB admin added one).
Older records can be deleted also via UI.
As far as performance issues are concerned, we had to turn off auditting of xmi import/export. The tradeoff is, that if you use "copy full structure for duplication" feature, there will be no audit records on created copy (does XMI/XML export/import in the background).

Geert Bellekens

  • EA Guru
  • *****
  • Posts: 11251
  • Karma: +415/-33
  • Make EA work for YOU!
    • View Profile
    • Enterprise Architect Consultant and Value Added Reseller
Re: Any way to check last modifier ?
« Reply #5 on: June 23, 2021, 11:48:14 pm »
My personal experience is that everyone

- Claims to need it when they start using EA.
- They enable it and allow it to fill up the snapshot table for a few years.
- Nobody ever looks at the actual auditing data
- Eventually they figure that out and disable the feature and clear the logs.

Seen this same pattern at quite a few clients actually :D

Geert

satrman

  • EA User
  • **
  • Posts: 25
  • Karma: +0/-0
    • View Profile
Re: Any way to check last modifier ?
« Reply #6 on: June 24, 2021, 12:13:39 am »
My personal experience is that everyone

- Claims to need it when they start using EA.
- They enable it and allow it to fill up the snapshot table for a few years.
- Nobody ever looks at the actual auditing data
- Eventually they figure that out and disable the feature and clear the logs.

Seen this same pattern at quite a few clients actually :D

Geert
Well there are several disadvantages of auditting in EA:
1) unfriendly UI
2) unfortunate solution of datetime filters (if you don't use them, you just timeout yourself without any warning in advance)
3) it is (to me) impossible to query data from t_snapshot (as it is txt=>zip=>base64=>blob sparx style)
4) it is very hard to find info on connectors (one need to get connector guid and use Search feature to obtain info on certain connector)

However after few weeks of struggle, it became a helpfull tool for us, as there is no other way we could find "modifiers" of objects/diagrams. Not even mentioning operations/attributes which don't have author and created/modified date info at all.

qwerty

  • EA Guru
  • *****
  • Posts: 12334
  • Karma: +347/-287
  • I'm no guru at all
    • View Profile
Re: Any way to check last modifier ?
« Reply #7 on: June 24, 2021, 01:14:59 am »
I have the same idea as Geert. So I always wonder why people actually use it in practice. It's not that they used to work for NSA half of their life?

q.

bknoth2

  • EA User
  • **
  • Posts: 128
  • Karma: +2/-0
    • View Profile
Re: Any way to check last modifier ?
« Reply #8 on: June 24, 2021, 01:19:51 am »
We've used auditing on requirements. It can be helpful to what changes have been made.

qwerty

  • EA Guru
  • *****
  • Posts: 12334
  • Karma: +347/-287
  • I'm no guru at all
    • View Profile
Re: Any way to check last modifier ?
« Reply #9 on: June 24, 2021, 02:10:23 am »
Which means you're doing RM with EA and not using any of these RM tools (like that dreaded DOORS). I always thought that EA could be used, but you have to deal with so many traps that the tradeoff is too big from my POV. Anyhow, thanks for sharing!

q.