I am a newbie in BOE administration and recently need to report the stastics of users activity to the managers. I have enabled Auditing on CMC and WebI and wrote the query below to get some information from the tables:
SELECT b.User_Name, e.Event_Type_Description, b.Object_CUID, d.Detail_Type_Description, b.Duration, c.Detail_Text FROM CMS_Audit.dbo.SERVER_PROCESS a INNER JOIN CMS_Audit.dbo.AUDIT_EVENT b ON a.Server_CUID = b.Server_CUID INNER JOIN CMS_Audit.dbo.AUDIT_DETAIL c ON b.Event_ID = c.Event_ID INNER JOIN CMS_Audit.dbo.DETAIL_TYPE d ON c.Detail_Type_ID = d.Detail_Type_ID INNER JOIN CMS_Audit.dbo.EVENT_TYPE e ON e.Event_Type_ID = b.Event_Type_ID
However Username is either 'Administrator' or 'System account'. How can I get the real user name like 'JSmith'? Having System account as user name doesn't help me at all.
Also the duration colmn is null for all records. why is that so??
Thanks in advance.
Edited by: Tootia on Jul 23, 2010 4:13 AM