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.