4
Copyright © Acronis, Inc., 2000-2009
By default, the management server is installed together with Microsoft SQL Server 2005 Express, and
the
ACRONIS
instance of this SQL server is used as both the operational and the reporting SQL server
instance.
Accessing the report views
The report views (and necessary functions) for all reports are stored in the
acronis_reports
database
on the reporting SQL
server instance. You can access the report views and execute queries against
them by using any management tool that works with that server instance.
For Microsoft SQL Server 2005 Express, you can use Microsoft SQL Server Management Studio
Express—a free management tool available from the Microsoft Web site at:
http://www.microsoft.com/downloads/details.aspx?FamilyID=c243a5ae-4bd1-4e3d-94b8-
5a0f62bf7796&displaylang=en
If the reporting SQL server instance and the management tool you are using are installed on different
computers, you may need to configure the SQL server instance to allow remote connections. For
Microsoft SQL Server 2005 Express, you will find the configuration instructions in the following article
from the Microsoft Support Web site: http://support.microsoft.com/kb/914277
2
Time format
All dates and times in the report views are stored in the Coordinated Universal Time (UTC) format.
3
Relationship between views
Each entry in the report views has its unique identifier. Each view also contains columns that establish
a relationship between dependent entries. For example, the
Tasks
view contains a column that
identifies the backup plan to which a particular task belongs.
Machines
Information about all physical machines and virtual machines that can be centrally managed by
Acronis Backup & Recovery 10 is stored in the
Machines
view.
A machine where at least one Acronis Backup & Recovery 10 agent is installed is considered as a
physical machine.
A virtual machine is a machine that is managed by Agent for ESX/ESXi or Agent for Hyper-V.
A machine where Agent for ESX/ESXi is installed—which technically is a ESX/ESXi virtual appliance—is
considered as a physical machine, according to the above definition of a physical machine.
The unique identifier of a machine is given in the
ManagedEntityID
column of the
Machines
view.
(“Managed entity” is a term used internally in the product.)
The
HostID
column contains the unique identifier of the physical machine or of the virtual machine's
host.
The
ManagedEntityID
column is also present in the
Tasks
,
BackupPlans
, and
ArchivesAndBackups
views. This enables you, for example, to determine the machine on which a given backup plan exists.
