Cognos status and trend reports

The Cognos® reports include status and trending data about your Tivoli® Storage Manager server and clients.

These Cognos reports are available in HTML, PDF, Microsoft Excel, XML, and CSV (delimited text) formats. There are limitations when you produce reports in Microsoft Excel formats, such as timestamps not displaying. For a complete list of all limitations search for Limitations when producing reports in Microsoft Excel format at http://www.ibm.com/support/knowledgecenter/SSEP7J_10.2.0.

You can customize the data that is displayed in your reports by specifying the parameter values that you want to include or exclude. After you run the report, the parameter values that you specified are displayed.
Important: When you modify existing reports in Report Studio, be sure to save the new report with a different name. Customized, or modified reports are not supported by our technical support staff.
This list specifies the client reports that you can generate. The report descriptions are described in Table 3.
Table 1. Cognos status and trending reports
Status reports Trending reports
Table 2. Report parameters
Parameter Description
Activity type Use this parameter to select the following client activities:
  • Archive
  • Backup
  • Restore
  • Retrieve
Depending on the report you select, the following options might be available:
  • HSM-Migrate
  • Recall
  • NAS Backup
  • NAS Backup to TSM Storage
  • NAS Restore
  • NAS SnapMirror Backup
  • NAS SnapMirror Restore
Date range Use this parameter to specify one the following date ranges to display. The default is All.
  • All
  • Date range (below)
  • Today
  • Yesterday
  • The last 7 days
  • The last 30 days
  • The last 90 days
  • The last 365 days
  • The current week
  • The current month
  • The current year to date
  • The last week
  • The last month
  • The last year
Servers Use this parameter to specify single or multiple servers.
Client node name Use this parameter to specify a client for the server to report on. This parameter can also accept wildcard characters by using the percent symbol (%). The default selects all the client nodes.
Summarization type Use this parameter to select how to group or summarize the data. You can specify daily, hourly, weekly, monthly, quarterly, or yearly. The default is monthly.
Number of clients to display Use this parameter to specify the number of clients that you want to display in the report.
Table 3. Cognos status and trend reports
Report name Description Report folder
Client activity status This report provides details about client node activity (backup, archive, restore, or retrieve) over a specified time period. The report has the following properties:
  • The report displays information about the success or failure of the activity.
  • It includes the number of examined objects, number of failed objects, total bytes transferred, and more.
  • Data is displayed in a tabular table format.
  • Failed activities are highlighted in red.
 Status reports
Client activity success rate This report displays the daily success rates of every client activity, for every server that is selected, as a trend over a specified time period. For each day in the range that is specified, the graph displays the success rate. The report has the following properties:
  • You can specify a target success rate and compare it to the actual and average success rates.
  • The report shows any client activity, including manually initiated activities such as unscheduled backups.
  • This report shows only activities that occurred and does not contain information such as missed schedules.
  • Data is displayed in a line graph and in tabular table format.
  • In the table, any value below your target success rate is highlighted in red.
 Trending reports
Client backup currency This report displays the client nodes that have not backed up within a specified number of days. The report is useful to determine which client nodes have not backed up as expected. The report has the following properties:
  • Ability to choose the minimum number of days since the last backup.
  • Ability to include client nodes that never had a successful backup.
  • Data is displayed in a tabular table format.
Tip: For performance reasons, run the report in the background as it is a long running task.
 Status reports
Client backup status This report displays information about selected client nodes. The report is useful to see the days since the last backup and when the last failed backup occurred. The report has the following properties:
  • Ability to search clients by using a wildcard.
  • Ability to select nodes based on the contact information for the client node.
  • Data is displayed in a tabular table format.
 Status reports
Client schedule success rate This report displays the success rates of client schedules as a trend over a specified time period. The report has the following properties:
  • You can specify a target success rate and compare it to the actual and average success rates.
  • The report does not show unscheduled activities such as a manually initiated backup.
  • Data is displayed in a line graph and in tabular table format.
  • In the table, any value below your target success rate is highlighted in red.
 Trending reports
Client schedule status This report provides details about the results of client schedules over a specified time period. The report has the following properties:
  • Details include the node name, schedule name, completion status such as failed, missed, severed, the scheduled date, and any error or warning messages.
  • Data is displayed in a tabular table format.
  • Failed schedules are highlighted in red and missed schedules are highlighted in yellow.
 Status reports
Client storage pool usage summary This report displays the amount of storage pool space a client node is using on the server. For each selected client node, the report displays the total space that is used on the server and the total space that is used per storage pool that the node is assigned to. The report has the following properties:
  • Ability to select specific servers.
  • Ability to select specific client nodes by using the Search and select widget. For advanced searching, expand the Options list. The result of the search shows up in the Results list. Client nodes added to the Choices list are used when the report is run.
  • Details include physical MB, logical MB, and reporting MB.
  • Data is displayed in a tabular table format.
Tip: For performance reasons, run the report in the background as it is a long running task.
 Status reports
Client storage summary and details This report provides details about how much storage space client nodes are currently using. The report has the following properties:
  • Details are grouped by server and domain.
  • Ability to sort on multiple columns in ascending or descending order.
  • Details for the client nodes include storage space that is used by each type of storage. These storage space types include disk and file storage, server storage, and tape storage, where server storage is the virtual volumes that are used by the client node.
  • Data is displayed in a tabular table format, with totals at the end of table for every Tivoli Storage Manager server.
 Status reports
Client storage usage trends This report provides details about the storage usage of a client node over a specified time period. The report has the following properties:
  • Data can be summarized daily, weekly, monthly, quarterly, and yearly.
  • Details for the client nodes include storage space that is used by each type of storage. These storage space types include disk and file storage, server storage, and tape storage, where server storage is the virtual volumes that are used by the client node.
  • Report shows one client for one server at a time.
  • Data is displayed in a line chart format, and a tabular table.
 Trending reports
Current client occupancy summary This report provides details about servers, client nodes, and associated storage pools to show how much space your nodes are using. The report has the following properties:
  • Details are grouped by node name and storage pool name. Details include file space name, file space ID, occupancy date, MB, physical MB, logical MB, and number of files.
  • Data is displayed in a tabular table format.
  • Node names are links that provide more details when clicked.
 Status reports
Current storage pool summary This report displays the space that is used on the server within each storage pool. The report also displays data deduplication savings to help with evaluating the effectiveness of data deduplication. The report has the following properties:
  • Details include total space, space used, file space used, disk space used, data deduplication space saved, and % of data deduplication saved.
  • Data is displayed in a tabular table format.
 Status reports
Disk utilization trends This report displays the disk space that is used by each disk storage pool over time. Only storage pools with a device class of type DISK are displayed. The report has the following properties:
  • Details are grouped by server and storage pool name. Details include the space that is used in percentage and in MB.
  • Data is displayed in a line chart format, and a tabular table.
  • You can specify a maximum space utilization threshold. Storage pools with values greater than the threshold are highlighted in red.
  • You can specify a minimum disk utilization filter. Data points below the minimum threshold are not displayed.
 Trending reports
Highest storage space usage This report provides details about which nodes are using the most storage space. The report has the following properties:
  • Details for the client nodes include storage space that is used by each type of storage. These storage space types include disk and file storage, server storage, and tape storage, where server storage is the virtual volumes that are used by the client node.
  • Data is displayed in a tabular table format, with totals at the end.
  • Client node names are links that provide more details when clicked.
 Status reports
Node replication details This report provides node replication details, for a specified server or node, for the specific date range. Status reports
Node replication growth This report displays two line charts:
  • Total number of files that are replicated
  • Total amount of file space, in megabytes, that is replicated
 Trending reports
Node replication summary This report provides details of the node replication for the specific date range for the specified servers and nodes. Status reports
Server activity log details This report provides a table with the activity log information for a specific time period. Some of the parameters include message code, search string, and severity, where message code is a 4-digit number. For example, in message number ANE4961I, the message code is 4961. Status reports
Server database growth trends This report provides details about database growth over a specified time period. The report is displayed so you can see the total capacity versus the total space used. The report has the following properties:
  • Data can be summarized daily, weekly, monthly, quarterly, and yearly.
  • Details include total capacity and total space used.
  • Data is displayed in a bar chart format and a tabular table.
 Trending reports
Server schedule status This report provides details about the success and failure of server schedules. The report has the following properties:
  • Details are grouped by server name and include the schedule name, the schedule start date and time, and the operation status.
  • Data is displayed in a tabular table format.
  • Failed schedules are highlighted in red.
 Status reports
Server storage growth trends This report provides details about server growth over a specified time period. The report has the following properties:
  • Data can be summarized daily, weekly, monthly, quarterly, and yearly.
  • Details include date, disk, and file storage in megabytes, and tape usage counts.
  • Data is displayed in a line chart and tabular table format.
 Trending reports
Server throughput trends This report provides a line chart of the server activities. The operation bytes reported, client, migration, database backup, storage pool backup, expiration, and reclamation bytes, are calculated for the operation only, then the values reset to zero. The bytes reported for each operation is not cumulative over time. Trending reports
Storage pool deduplication savings This report provides details about the storage pools that contain deduplicated data. For each storage pool, the following information is displayed:
  • The space that is saved by data deduplication
  • The percentage of space that was saved by data deduplication
 Status reports
VE activity status This report provides details about virtual machine guest activity (backup, archive, restore, or retrieve) over a specified time period. The report has the following properties:
  • The report displays information about the success or failure of each activity for data center nodes.
  • It includes the data center node name, virtual machine name, number of objects that failed, total kilobytes that is transferred, and more.
  • Data is displayed in a tabular table format.
  • Failed activities are highlighted in red.
Important: Run this report on Tivoli Storage Manager servers that are at version 6.3.3 or later.
 Status reports
VE backup type summary This report shows the number of incremental and full backups for each selected client node. The report is useful to determine which client node backups might be having problems when the backups are always full instead of incremental. The report has the following properties:
  • It includes the data center node name, virtual machine name, the number of full backups, and the number of incremental backups, over the specified amount of time.
  • Data is displayed in a tabular table format.
Important: Run this report on Tivoli Storage Manager servers that are at version 6.3.3 or later.
 Status reports
VE current occupancy summary This report provides current details about the storage occupancy that a VE guest operating system is using on the Tivoli Storage Manager server. The report has the following properties:
  • Details are grouped by data center node and virtual machine name. Details include file space information, reporting MB, physical MB, logical MB, and number of files.
  • Data is displayed in a tabular table format.
  • Data center node names are links that provide more details when clicked by linking to the VE Node Activity Status report to get current information about the activity of the VE on the Tivoli Storage Manager server.
Important: Run this report on Tivoli Storage Manager servers that are at version 6.3.3 or later.
 Status reports
Yesterday's missed and failed client schedules This report provides details about client schedule completion status from the day before the report is run. The report has the following properties:
  • Data is displayed in a tabular table format.
  • Failed schedules are highlighted in red.
  • Missed schedules are highlighted in yellow.
 Status reports