Sample Audit Model and Audit Reports

IBM® Cognos® software includes a sample model and sample audit reports that you can use.

Sample Audit Model

IBM Cognos software includes a sample audit model in Framework Manager. The default location is c10_location/webcontent/samples/models/Audit/Audit.cpf.

Sample Audit Reports

The following table lists the sample audit reports and describes the content of each report.

The default location for the deployment file, IBM_Cognos_Audit.zip is c10_location/webcontent/samples/content/IBM_Cognos_Audit.zip.

Before you can use them, you must set up the sample audit reports.

Table 1. Sample audit reports

Audit report name

Description

Weekly action details by user

This active report uses a prompt to show weekly details of user actions that have been logged for the selected value. The default value is DATASET, that is logged by using My Data Sets functionality.

Agent execution history by user

Lists the agents that were run by user, date, and time. It includes a bar chart.

You can select a date and time range.

Daily average and poor exceptions - all services

Shows how to monitor daily average and poor exceptions of thresholds set in IBM Cognos Administration for all services using an agent.

An email with attached report output is sent to the administrator when average and poor exceptions occur.

To run this report properly, you must first set thresholds in IBM Cognos Administration. To receive an email, you must specify a mail server account.

Daily metric exceptions

Lists daily metric exceptions for all services.

Execute reports by package and report

Lists the reports that were run, by package. It also includes the user, timestamp, and execution time in milliseconds for each report.

You can select a date and time range, one or more users, one or more packages, and one or more reports.

Execute reports by tenant

Lists the tenant IDs and tenant users. This report provides package, report, and time stamp information.

Execute reports by user

Lists the reports that were run, by user and by package. It also includes the timestamp and execution time in milliseconds for each report.

You can select a date and time range, one or more users, one or more packages, and one or more reports.

Execution history by user

Lists the reports that were run alphabetically, along with the package and timestamp, by user, since the logging database was created.

It includes the total number of reports each user ran and the total number of times each user ran each report. It also includes the total number of reports run by all users.

You can select one or more users for the report. After you run the audit report, you can choose to view the statistics for a particular report or for all reports.

Failed report executions - by package

Lists report failure executions by package and includes a pie chart, which also shows the failed percentage of each package.

Failed service requests detect agent - all services

Detects preset thresholds for service request failures that are exceeded.

An email is sent to the administrator with service failure metrics information. The report Service requests metrics - day report is run.

To run this report properly, you must first set thresholds in IBM Cognos Administration. To receive an email, you must specify a mail server account.

Logon operations by time stamp

Shows logon and logoff timestamps and operations, by user.

It also includes the total number of logons and the total number of logons for each user.

You can select the time period and one or more users for the report.

Logon operations by tenant

Lists the logon actions for each tenant ID and provides the total number of logons for each user and tenant ID.

Logon operations by user name

Shows logon and logoff timestamp by user, along with the type of logoff operation that occurred.

It includes the total number of logons and the total number of logons for each user.

You can select one or more users for the report.

Migration exceptions

A list report shows exceptions for migration tasks.

Operations by selected object and users

Shows the operations that are performed on target objects, by user. It includes the target object path, timestamp, and the status of the operation.

You can select one or more objects, operations, or users for the report.

Report execution history (detailed report)

Lists reports alphabetically along with the associated package and the timestamp for each time the report was executed.

It also shows the total number of times each report was executed and the total number of reports that were executed.

It also includes a color-coded pie chart that gives an overview of how often the reports are used.

Report execution and user logon history

This active report displays the report execution history and user logon information for a specified period of time.

Report execution history (summary report)

Lists reports alphabetically along with the timestamp for each time the report was run since the logging database was created.

Report execution history by tenant

Lists the executed reports, timestamps, and the associated package names for a tenant. This report provides a summary of total activity and the report can by filtered for a specific tenant.

Report usage

Lists reports by frequency of use. For each report, it lists the user and the number of times it was run by the user since the logging database was created.

This report can help you determine if there are any reports that are not being used. If so, you may want to remove them.

Service requests metrics - day report

Shows percentage of successful and failed requests for IBM Cognos services for the current day. Includes a bar chart.

User session - abnormal termination

Shows logon date and time of abnormally terminated user sessions. It also includes a total of session termination for all dates.

You can select a date and time range.

User session - details

Shows user session details, including the logon time, logoff time, logoff operation, and session duration.

It also includes the total amount of session time for each user and the total amount of session time for all users.

You can select a date and time range and one or more users.

User session - logon errors for past 30 days chart

This audit report shows a bar graph of logon failures for the past 30 days.

User session - summary

This audit report shows the average session duration by user. It also shows the total average session duration by user.

You can select a date and time range and one or more users.

View reports by package for past 30 days

This active report displays report execution for the past 30 days. The report includes a cascading prompt.

View reports by package and report

This report lists users, reports, timestamps, and packages for the tenant that you select.

Report execution by mobile client type

This report lists reports that were run by different mobile client types. For each listed report, the sample report shows the mobile user agent that was used to run the report, and the total number of times when the report was run by each client. You can select the date and time range when running the report.

Report execution by mobile user

This report lists reports that were run by a specific mobile user. For each user, the report specifies the mobile user agent, the types of reports that were run, and the time when the report was run. You can select the user, date, and time range when running the report.

Scheduled mobile report delivery

This report shows the name of the scheduled report, the report mobile recipients, and the number of times when the report was run during the scheduled time. You can select the date and time range when running the report.

Logon operations by mobile user

This active report shows logon and logoff operations for each mobile user and the total number of logon operations for all users for the past seven days. You can drill down on the dates to see the number of logon and logoff operations at a specific hour of day.