Copyright © Acronis, Inc., 2000-2009
3
This document covers report views—a newly-introduced feature of the advanced editions of Acronis®
Backup & Recovery™ 10.
These views are stored in a Microsoft SQL Server database which is used by Acronis Backup &
Recovery 10 Management Server. Each view is similar to a database table.
By executing Structured Query Language (SQL) queries against these views, you can get a well-
structured centralized overview of product performance and statistics throughout the enterprise.
Report views complement the reporting graphical user interface (GUI), which is now available in
Acronis Backup & Recovery 10 Management Console when it is connected to the management
server. An advantage of using the views is that you are free to run any custom queries—not
necessarily covered by the reporting GUI—or to export the result to any format supported by Data
Transformation Services (DTS).
The primary objective of this document is the description of the views and presentation of sample
queries for getting some useful reports.
1
Report data
Where the report data is taken from
Reports are built based on the data that the management server retrieves from the machines that are
registered on it. The data is retrieved periodically (normally, every 2 minutes), so there might be
some minor latency between the actual data and the data in the reports.
The retrieved data is stored in the management server's databases.
Types of reports
There are two types of reports:
Current
Historical
Current reports reflect the current state of tasks, backup plans, backup policies, machines, archives,
backups, and vaults. You can also view all this information in the Acronis Backup & Recovery 10
Management Console.
Historical reports are built based on the logs that the management server has collected from the
registered machines over time. They provide information about vaults' statistics (for example, the
history of the managed vaults' space usage) and task activities (for example, the result with which a
task finished each time).
Historical reports enable you to obtain information that is not shown in the management console,
such as how the free space in a managed vault changed within the reporting period.
SQL server instances used by the management server
The management server uses two instances of Microsoft SQL servers, called the operational SQL
server instance and the reporting SQL server instance. Both instances are specified during the
management server installation.
