Acronis® Backup & Recovery™ 10 Management Server reports Technical white paper
Table of Contents 1 Report data................................................................................................................................ 3 2 Time format ............................................................................................................................... 4 3 Relationship between views ...................................................................................................... 4 4 Relationship diagram ..........................................
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 wellstructured centralized overview of product performance and statistics throughout the enterprise.
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.
Backup plans, backup policies, and tasks A backup plan consists of one or more tasks. Backup plans can be local or centralized. A local backup plan is created on a machine directly, whereas a centralized backup plan is created as a result of deploying a backup policy. Some tasks, such as recovery tasks and tasks running on Acronis Backup & Recovery 10 Storage Node, do not belong to any backup plan.
4 Relationship diagram The following diagram shows the relationship between the report views. Only the columns that uniquely identify the entry and establish the relationships are shown here. 5 Current state reports 5.1 Machines 5.1.1 Description The Machines view represents all physical and virtual machines. You can differentiate between the types of machines by using the ManagedEntityType column. 5.1.
Note that the function GETUTCDATE is used here instead of GETDATE, because all times in the databases are in the UTC format.
The following query returns the list of all offline machines that run any of the Windows Server operating systems: SELECT * FROM Machines WHERE OperatingSystem LIKE '%Windows%Server%' AND Availability = 'OFFLINE' The following query returns the list of virtual machines that are hosted on the ESX/ESXi host with IP address 10.1.2.3 and are managed by Agent for ESX/ESXi: SELECT Machine.Name, Machine.Availability, Machine.LastBackup, Machine.
VIRTUAL SERVER – This value is reserved for use in future versions. Please disregard any rows that currently have this value. ManagedEntityID – The unique identifier of the machine HostType – Reserved for use in future versions. Currently, the value in this column is always AGENT NextBackupStartTrigger – The types of backup plan schedules on the machine: HostID – For a physical machine: the unique identifier of the agent that is installed on the physical machine.
5.2.3 Column values The Tasks view contains the following columns: Name – The name of the task Machine – The name of the machine on which the task exists ExecutionState – The current execution state of the task: IDLE – The task is idle. WAITING – The task is ready to start, but is waiting until a condition is met or until another task running on the same machine has finished. RUNNING – The task is in the process of execution.
HostType – The component that runs the task: AGENT – Any Acronis Backup & Recovery 10 Agent STORAGE NODE – Acronis Backup & Recovery 10 Storage Node ID – The unique identifier of the task BackupPlanID – The unique identifier of the backup plan to which the task belongs—or NULL if the task does not belong to any backup plan HostID – The unique identifier of the component that runs the task Note for Virtual Edition: On a Hyper-V host, the value in this column will be the same for both the task
Name in the view Name in the GUI Task description FILERESTORETASK Recovery (file) Recovers files from a file backup or from a disk backup INVENTORYTASK Inventorying The inventorying task on a storage node: performs inventorying of tapes in a tape library LOCATION VALIDATION Validation (vault) Validates a vault MANAGEASZTASK ASZ management Manages Acronis Secure Zone—for example, changes its size RESCANTASK Rescan The rescan task on a storage node: updates the database that contains informat
The following query returns failed backup policies that perform file-level backups: SELECT * FROM Policies WHERE Status = 'ERROR' AND SourceType = 'CENTRALIZED FILE BACKUP' 5.3.
The following query returns all failed backup plans that back up virtual machines: SELECT * FROM BackupPlans WHERE ManagedEntityType = 'VIRTUAL MACHINE' AND Status = 'ERROR' 5.4.3 Column values The BackupPlans view contains the following columns: Name – The name of the backup plan.
Comments – Backup plan comments. For a centralized backup plan, the value in this column is the same as in the Comments column for the corresponding backup policy. ManagedEntityType – The type of the machine whose identifier is given in the ManagedEntityID column: PHYSICAL MACHINE – The machine is a physical machine. VIRTUAL MACHINE – The machine is a virtual machine.
5.5.3 Column values The ArchivesAndBackups view contains the following columns. In this description, “archive” refers to the archive that contains the given backup; “corresponding backup plan” refers to the backup plan under which the backup was created: Name – The name of the archive ArchiveType – The type of archive: FILE – The archive contains file backups. IMAGE – The archive contains disk backups. ArchiveCreationTime – The date and time when the archive was created.
BackupComments – The backup comments: in the GUI, the contents of the Archive comments field of the backup plan under which the backup was created IsSectorBySectorBackup – Equals 1 if the backup is sector-by-sector (as opposed to a backup performed by taking a disk snapshot); otherwise, equals 0 IsLiveLinuxBackup – Equals 1 if the backup was created by Agent for Linux; otherwise, equals 0 BackupOccupiedSpace – The size actually occupied by the backup BackupUniqueDataSize – The amount of backe
5.6 Vaults report 5.6.1 Description The Vaults view contains the centralized vaults—both managed and unmanaged. The vault type (whether the vault is managed or not) is determined by the IsManaged column. The HostID column refers to the storage node that currently manages the vault (for an unmanaged vault, the value in this column is NULL). 5.6.
HostID – The unique identifier of the storage node that manages the vault. For an unmanaged vault, the value in this column is NULL. 6 Historical reports 6.1 Vaults statistics report 6.1.1 Description The GetVaultsStatistics function returns a table containing the statistics for all managed vaults that existed within a period you specify. The VaultID column in this table identifies the vault whose statistics are presented.
6.1.
IsDeduplicated – Equals 1 if the managed vault is deduplicated; otherwise, equals 0 6.2 Task activities report 6.2.1 Description Each run of a task, from start to finish, corresponds to a single task activity. Task activities are represented by the TaskActivities view containing all the task activities occurred during the period that can be deduced from logs. The retention of logs reduces the amount of information available to this view. In case the logs are corrupted, this view may be inconsistent.
ManagedEntityType – The same as the ManagedEntityType column of the Tasks view BackupPolicy – The name of the backup policy (for centralized tasks) or the local backup plan (for local tasks) on which the task is based. If the task does not belong to a backup plan, the value in this column is an empty string (''). Machine – The name of the physical machine on which the task exists.
Tasks • 9 Index A Time format • 4 V Vaults report • 18 Archives and backups • 15, 20 B Backup plans • 13 C Column values • 8, 10, 13, 14, 15, 16, 18, 20, 21, 22 Current state reports • 6 D Description • 6, 9, 12, 13, 15, 18, 19, 21 H Historical reports • 19 L List of task types • 10, 11 M Machines • 6 O Original data size • 17, 20 P Policies • 12 Q Query samples • 6, 9, 12, 13, 15, 18, 19, 21 R Relationship between views • 4 Relationship diagram • 6 Report data • 3 T Task activities report •
