cancel
Showing results for 
Search instead for 
Did you mean: 

Audit users & activities

Former Member
0 Kudos

Hi,

We have an Audit database setup & auditing enabled for CMS & Crystal Servers.

Audit logs are getting created but i am unable to see the user actiivities.

I tried executing sample audit reports but it doesn't bring audit information

Can somebody throw some light on how audit works..

Accepted Solutions (1)

Accepted Solutions (1)

Former Member
0 Kudos

Hi John,

1) what kind of Audit information you are looking for ?

2) The CMS server will cature only the Log in and log of informations for the Applications

create the custom report using the Acticity universe. you need to use the event id to get the log in and log of information.

Former Member
0 Kudos

I want to create a custom report based on Activity report to record user activity on CMC & any changes they make in the settings on the Server/Services.

I have activated Auditing on CMS, Webi, Crystal, All Job Servers & Processing Servers.

I am not sure how to create custom reports for capturing user activity...

Westmoreland
Advisor
Advisor
0 Kudos

Take a look here:-

/people/adrian.westmoreland/blog

it may help you.

Former Member
0 Kudos

Useing the Activty universe we can build the custom Reports .

Useing this we can build the users log in and log of information.

Using activity Universe. under the action class we have user Name,Action name , action time drag in to the result object pannel.

in the query filter pannel drag the Action name id use these id (65540;65539;65537;65538).

Answers (2)

Answers (2)

joshua_kuhn
Contributor
0 Kudos

forgot to mention.... if you're not using the default mysql database then the Activity universe you have published is probably not going to work. The universe must match the database. If using something other than MySQL, you'll need to remove the Activity universe in the system and publish the correct one to match your database.

Look in here for the others:

C:\Program Files\Business Objects\BusinessObjects Enterprise 12.0\Samples\universe

joshua_kuhn
Contributor
0 Kudos

If you're using the default mysql install, then the 'Activity' universe that is already published should work fine. In that case, the only requirements are to:

1.) configure auditing on within the SIA in the CCM.

2.) select which services and audit events you want to capture in the CMC.

For #1, you need to go into the properties of the SIA and select the configuration tab. (do this while the SIA is stopped). In the bottom section, you should have it checked and a datasource name listed.

For #2, depending on what you would like to capture, you can enable auditing on the CMC, jobservers, cacheservers, etc. Just to see if its working, enable it for at least the CMS and capture the logins. Login a few times and query the database directly to see if any new rows are getting added or not. If so, then the CMS is doing its job capturing and writing the data. Next step would be to test your reports and see if its a universe issue or maybe something within the universe connection object.

Former Member
0 Kudos

I have already done the steps you have mentioned for SQL Server.

And, I am trying to find the user activity on the Server.

Auditing is enabled for CMS & All job servers, But the Activity report is not showing any User Activity.

I am not able to see what do the user do on the server.

Can I get any custom report outside other than Auditing reports with Server ?

Or do i have to create a custome report to view user activity..?

joshua_kuhn
Contributor
0 Kudos

You can create your own custom reports or modify the the stock ones if you need. But if you're wanting to capture user interactions, the CMS service won't have it all and the jobserver is only going to capture scheduling. You might need to enable auditing on some of the other services.

Look to chapter 12 & 13 of the XI 3.1 Administrator's Guide. It describes which XI services audit which actions, describes the auditing db schema and each sample auditing report and what it displays.