background image

16

 

Copyright © Acronis, Inc., 2000-2009 

 

 

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. It does not change 

upon adding or deleting backups in the archive. 

 

ArchiveOwnerName

 – The name of the user who owns the archive. This is the user whose 

credentials are used to access the managed vault where the archive is stored. 

 

MachineName

 – The name of the machine on which the corresponding backup plan ran. 

The following four columns show the different notions of size (in bytes) for the archive, which are 
calculated based on the corresponding sizes of the backups stored in it: 

 

ArchiveOccupiedSpace

 – The sum of the values in the 

BackupOccupiedSpace

 column for all 

backups in the archive 

 

ArchiveBackedUpDataSize

 – The sum of the values in the 

BackupDataSize

 column for all backups 

in the archive 

 

ArchiveUniqueDataSize

 – The sum of the values in the 

BackupUniqueDataSize

 column for all 

backups in the archive 

 

ArchiveOriginalDataSize

 – The sum of the values in the 

BackupOriginalDataSize

 column for all 

backups in the archive 

 

NumberOfFullBackups

 – The number of full backups that are stored in the archive 

 

NumberOfIncrementalBackups

 – The number of incremental backups that are stored in the 

archive 

 

NumberOfDifferentialBackups

 – The number of differential backups that are stored in the 

archive 

 

ArchiveComments

 – The archive comments: in the GUI, the contents of the 

Archive comments

 

field of the backup plan under which the archive is created 

 

IsEncrypted

 – Equals 1 if the archive is encrypted; otherwise, equals 0 

 

EncryptionAlgorithm

 – Encryption level for the archive. Archives can be encrypted by using the 

Advanced Encryption Standard (AES), with a key size of 128, 192, or 256 bits. 

 

NONE 

– The archive is not encrypted. 

 

AES128

 – The archive is encrypted by using a 128-bit key. 

 

AES192

 – The archive is encrypted by using a 192-bit key. 

 

AES256

 – The archive is encrypted by using a 256-bit key. 

 

ArchiveOwnerUID

 – The unique identifier of the user who owns the archive 

 

BackupType

 – The type of backup: 

 

FULL 

– Full backup 

 

INCREMENTAL 

– Incremental backup 

 

DIFFERENTIAL 

– Differential backup 

 

BackupCreationTime

 –

 

The date and time when the backup was created 

Summary of Contents for BACKUP RECOVERY 10 MANAGEMENT SERVER REPORTS -

Page 1: ...Technical white paper Acronis Backup Recovery 10 Management Server reports...

Page 2: ...y samples 12 5 3 3 Column values 13 5 4 Backup plans 13 5 4 1 Description 13 5 4 2 Query samples 13 5 4 3 Column values 14 5 5 Archives and backups 15 5 5 1 Description 15 5 5 2 Query samples 15 5 5 3...

Page 3: ...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...

Page 4: ...ormat 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 al...

Page 5: ...he corresponding entry In the Tasks view the BackupPlanID column stores the unique identifier of the backup plan to which the task belongs In the BackupPlans view for centralized backup plans the Poli...

Page 6: ...virtual machines You can differentiate between the types of machines by using the ManagedEntityType column 5 1 2 Query samples The following query returns all critical physical and virtual machines t...

Page 7: ...cessful backup for all physical and virtual machines the times are shown in the local time zone that of the SQL server SELECT Name ManagedEntityType DATEADD hh DATEDIFF hh GETUTCDATE GETDATE LastBacku...

Page 8: ...arning during the backup but there are no errors ERROR At least one backup task has failed UNKNOWN No backup tasks have yet run on the machine MachineAddress For a physical machine the IP address of t...

Page 9: ...Note The backup plans that back up a virtual machine exist on the physical machine whose agent manages the virtual machine NextBackupStartTime When the value in the NextBackupStartTrigger column is O...

Page 10: ...nly start it manually LastFinishTime The time when the task last finished regardless of the last result OwnerUID The unique identifier of the user who owns the task Owner The name of the user who owns...

Page 11: ...machine ARCHIVE VALIDATION Validation archive Validates an archive ASRM ACTIVATION TASK ASRM activation deactivation Activates or deactivates Acronis Startup Recovery Manager ASRM ATTACHLOCATIONTASK V...

Page 12: ...xisting VM Recovers volumes to an existing virtual machine RESTORE VOLUMES NEW VM Recovery new VM Recovers volumes to a new virtual machine SLICE VALIDATION Validation backup Validates a backup STORAG...

Page 13: ...cumulative status of the policy statuses on all machines the policy is applied to OK The policy status on all machines is OK WARNING There is a machine on which the policy status is Warning and there...

Page 14: ...e UNKNOWN is shown when the value VIRTUAL DISK BACKUP should be shown This issue will be fixed in the next product updates Origin The origin of the backup plan LOCAL Local backup plan CENTRALIZED Cent...

Page 15: ...scription The ArchivesAndBackups view contains the list of all backups in all archives from all the managed vaults It is possible to track the relationship of an archive to the managed vault Each entr...

Page 16: ...n for all backups in the archive ArchiveUniqueDataSize The sum of the values in the BackupUniqueDataSize column for all backups in the archive ArchiveOriginalDataSize The sum of the values in the Back...

Page 17: ...dentifier of the archive VaultID The unique identifier of the managed vault in which the archive is stored HostID The unique identifier of the agent that ran the corresponding backup plan ManagedEntit...

Page 18: ...wnerName The name of the user who created the vault OwnerUID The unique identifier of the user who created the vault Comments The vault comments StoragePath The path to the folder where the archives a...

Page 19: ...tics as of 01 00 02 00 and 03 00 on January 1 2010 UTC SELECT FROM dbo GetVaultsStatistics 1 1 2010 01 00 00 000 1 1 2010 03 00 00 000 3600 The management server updates statistics about the managed v...

Page 20: ...lue in this column is 0 For a deduplicated vault the value in this column is the value in ArchiveDataSize minus the value in UniqueDataSize The following four columns contain information about data ra...

Page 21: ...ollowing query returns all the tasks that failed on the machine webserver example com within the past week SELECT FROM TaskActivities WHERE DATEDIFF m FinishTime GETUTCDATE 7 AND Machine webserver exa...

Page 22: ...ne the duration of a task activity including that of the latest one The duration of the latest task activity is also stored in the Duration column of the Tasks view These two values might differ by a...

Page 23: ...on 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 R...

Reviews: