Skip to Content
0
Former Member
Jul 23, 2010 at 02:11 AM

Auditing User name and activity duration

20 Views

Hi all

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