Auditing User name and activity duration

[Former Member]

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

[Former Member · Accepted solution]

There are set of in-built audit reports (both webi and crsystal) which come bundled with activity universe.

You may use them to get the required info. One of such report is "User Activity per Session" which asks for 'start date', 'end date' and 'user' as input parameters and shows the user activity during the selected period.

You can modify this base query and generate your own report if the standard report doesn't satisfy your need.

Thanks,

Chandra

[Former Member]

Hi Tootia, the AUDIT_EVENT.User_Name should give you the user ID of the person accessing the report. How do your users access Infoview? Do they use the Enterprise authentication or you have a custom authentication method?

And yes, I noticed that the AUDIT_EVENT.Duration field is never populated. It might be a bug of the system. Since I don't need that information, I simply remove it from my query.

-

---

If you are using the BusinessObjects tool, you should join [ASUG|www.asug.com]

[Former Member]

Thanks Simon. Our users are not Enterprise like, they are Wondow AD type users. Now I can see them in the query result

However as you mentioned there is no value in Duration column which is a pity.