Regarding Audit

[archana_bonkanp]

Can anyone explain me how to implement audit ,i have gone through the site
http://wiki.alfresco.com/wiki/Audit#Auditing_flow but im not geting an clear idea
when i apply the template the information which i cant understand is displayed
can any one help in these

[jbarmash]

I am not sure what you mean by "implement audit".  Alfresco supports auditing internally.  Once you enable it, it starts writing to database audit tables.  This happens in many core services, on the code level (through Java annotations). 

Then you can write SQL queries to pull out the information you care about. 

Did you enable auditing on your system?  If so, explore the entries that are being made into the DB and play around with some SQL.

[archana_bonkanp]

"implement audit" is i want to get the information of the user who edited the file,deleted the file and the whatever actions done on a particular file.

i have enabke audit,when applied a template it gives some technical information,but endusers who uses the system needs only the information like edited,deleted the file,he is no way concerned with other technical information

[andy]

Hi

You need your own simplified audit template.
Use the existing one as a base.

Andy

[archana_bonkanp]

but the audit template doesnt give information of deleted contents

[andy]

Hi

You are correct. Some APIs for delete only require the node ref so the parent is not recorded anywhere. The audit service does not have a good API for general queries at the moment. You can get delete information from the DB - but again it will be a bit of a pain to link it up. The wiki was some mysql DB magic to generate paths that may help you.

In the longer term, audit needs to have the option to record path and the user friendly name path.

Andy

[etzapata]

Hi Andy,

I have turned on auditing but I don't know where in MySQL tables that says who uploads, review/read, and approve a certain document and when. I have searched in the wiki regarding audit but the samples given where limited to:

1. when a user logs in,
2. who among the users have never logged in.

I was required to submit a report regarding the following:

1.  Who uploads the document and When?
2.  Who edits/reviews the document and When?
3.  Who approves the document and When?

Where can I find these information? Please help.
Thank you very much.

EriCtZ

[etzapata]

Hello everyone,

I also have another question (my problem above has not been answered yet), since turning ON the audit trail will affect the performance of the system, is it possible to just audit the folders that needs to be audited? For example, I have different folders in Company Home: Daily Reports, Images, ISO, Clearing, etc. How do I configure the audit to audit only the things that happen in ISO folder? If everything is audited, it will greatly affect our database as well. I have read the wiki regarding audit but it does not give me a clearer view.

Also, I have queried the following script in MySQL but it says nothing (0 rows fetched).

select * from alf_audit_fact fact
  join alf_audit_date date on fact.audit_date_id = date.id
  join alf_audit_source source on fact.audit_source_id = source.id
  where Service='FileFolderService' and method='move' and fail='0' and return_val like '%isFolder=false%';

I am sure I have turned ON auditing and am sure that many documents have been moved from one folder to another.
How do I make this work?

I was already asked to submit a report as to who approves, who rejects, when and how many (as for our workflow).
If anyone can help me, I'd really be ver grateful.
Thank you very much.

EriCtZ

[archana_bonkanp]

Hi All,

I have a folder "Corporate Information" folder in CompanyHome, when we direct open the application can we directly root to the Corporate Information folder instead of MyDashboard or CompanyHome.If yes,please let us know.

Atleast we tried directly to route to CompanyHome instead of MyDashboard.
But its not working correctly.'
Please help.

[etzapata]

Hi all,

Is there anyone knew where I can find the table in Mysql that says who approves the document, who reads, who deletes, etc? I have turned auditing ON but still i cant find the table of the stated audit trail.

Please help…

EriCtZ