Author Topic: EA Auditing  (Read 730 times)

Shailen

  • EA Novice
  • *
  • Posts: 10
  • Karma: +0/-0
    • View Profile
EA Auditing
« on: June 19, 2009, 11:34:17 am »
Quick EA question regardining auditing.  I have a model that comprimises of many attachments to documents.  I've created a document index detailing all the attached documents throughout my model. The model is quite big, so the index lets a user access the document if they don't know which business process it would be associated to.  I want to run and audit that tells me exactly where all the documents are located within my EA model.  Also I would like it to tell me if there are any documents that is listed in my index but not associated in my model.  How can I do this?

Thank You.

Dermot

  • EA Administrator
  • EA User
  • *****
  • Posts: 585
  • Karma: +6/-0
    • View Profile
Re: EA Auditing
« Reply #1 on: June 22, 2009, 03:04:16 pm »
Are you storing these as Linked Documents/Document Artifacts or linked via Element.Files?

Shailen

  • EA Novice
  • *
  • Posts: 10
  • Karma: +0/-0
    • View Profile
Re: EA Auditing
« Reply #2 on: June 23, 2009, 06:55:19 am »
We are storing them as linked documents/document artifacts


Dermot

  • EA Administrator
  • EA User
  • *****
  • Posts: 585
  • Karma: +6/-0
    • View Profile
Re: EA Auditing
« Reply #3 on: June 23, 2009, 03:02:00 pm »
Try doing a Ctr-F Custom SQL search on the table: t_document - using something like:

SELECT ea_guid as CLASSGUID, Object_Type as CLASSTYPE, Name
FROM t_object, t_document
where t_object.ea_guid =  t_document.ElementId and t_document.Doctype ='ModelDocument'

The context menu of the result set does allow for reporting the results.