Book a Demo

Author Topic: Getting author of modification  (Read 4950 times)

mvngomes

  • EA Novice
  • *
  • Posts: 12
  • Karma: +0/-0
    • View Profile
Getting author of modification
« on: March 12, 2013, 12:32:15 am »
Hi all,

I'm trying to build a search where, besides the modification date (t_object.ModifedDate), the name of the user that performed the modification is displayed. Any pointers on where this information might be stored?

Regards,
Mateus

qwerty

  • EA Guru
  • *****
  • Posts: 13584
  • Karma: +397/-301
  • I'm no guru at all
    • View Profile
Re: Getting author of modification
« Reply #1 on: March 12, 2013, 02:08:48 am »
You might get it from the audit log since the element only holds the creator.

q.

mvngomes

  • EA Novice
  • *
  • Posts: 12
  • Karma: +0/-0
    • View Profile
Re: Getting author of modification
« Reply #2 on: March 12, 2013, 02:36:16 am »
Thank you for the tip, but could you please be more specif on what you mean by audit logs? I've been searching the tables without any success... or are they somewhere else?

mvngomes

  • EA Novice
  • *
  • Posts: 12
  • Karma: +0/-0
    • View Profile
Re: Getting author of modification
« Reply #3 on: March 12, 2013, 02:49:35 am »
I do own Inside EA and it says the t_snapshot table contains that info; but this table is empty in my project  :(

qwerty

  • EA Guru
  • *****
  • Posts: 13584
  • Karma: +397/-301
  • I'm no guru at all
    • View Profile
Re: Getting author of modification
« Reply #4 on: March 12, 2013, 10:59:39 am »
You need to turn on auditing first by Project/Audit view. Once it's turned on you get all changes audited in that table.

q.

mvngomes

  • EA Novice
  • *
  • Posts: 12
  • Karma: +0/-0
    • View Profile
Re: Getting author of modification
« Reply #5 on: March 12, 2013, 07:37:11 pm »
I'll check that out. Once again, thank you for the pointers!

Geert Bellekens

  • EA Guru
  • *****
  • Posts: 13523
  • Karma: +574/-33
  • Make EA work for YOU!
    • View Profile
    • Enterprise Architect Consultant and Value Added Reseller
Re: Getting author of modification
« Reply #6 on: March 12, 2013, 11:50:39 pm »
Without the auditing option only the user who created something is stored, not the user that modified something.

Geert