ACRONIS BACKUP RECOVERY 10 MANAGEMENT SERVER REPORTS - Installation Manual Download Page 20

20

 

Copyright © Acronis, Inc., 2000-2009 

 

 

6.1.3

 

Column values 

The 

GetVaultsStatistics

 function returns a table that contains the following columns: 

 

Date

 – The point in time for which the statistics are presented 

 

FreeSpace

 – The amount of free space in the managed vault—normally, the amount of free space 

on the device that stores the managed vault 

 

OccupiedSpace

 – The space occupied by all archives that are stored in the managed vault, plus 

the size of the vault database and—for deduplicated vaults—the size of the deduplication data 
store 

 

NumberOfArchives

 – The number of archives that are stored in the managed vault 

 

NumberOfBackups

 – The total number of backups that are contained within the archives in the 

managed vault 
The following four columns contain information about the size of the data in the archives, in 
bytes. It is calculated based on the archive sizes shown in the 

ArchivesAndBackups

 view (p. 15). 

 

OriginalDataSize

 – The sum of the values in the 

ArchiveOriginalDataSize

 column for all archives 

that are stored in the managed vault 

 

ArchiveDataSize

 – The sum of the values in the 

ArchiveBackedUpDataSize

 column for all archives 

that are stored in the managed vault  

 

UniqueDataSize

 – The sum of the values in the 

ArchiveUniqueDataSize

 column for all archives 

that are stored in the managed vault. For a non-deduplicated vault, the value in this column is 

NULL

 

DeduplicatedArchiveSize

 – The amount of data in the archives that was removed as a result of 

deduplication. For a non-deduplicated vault, the value 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 ratios for the contents of the 
managed vault. Smaller ratios mean higher storage efficiency. 
These ratios are calculated based on the sizes shown in the previous four columns. 

 

TotalRatio

 – The value in 

OccupiedSpace 

divided by the value in 

OriginalDataSize

. This ratio 

shows the space actually occupied by the archives as compared with the overall size of the sets of 
data that can be recovered from these archives. For an example on original data size, see Original 
data size (p. 17). 

 

BackedUpDataRatio

 – The value in 

ArchiveDataSize

 divided by the value in 

OriginalDataSize

. This 

ratio shows how the use of incremental and differential backups has reduced the space needed 
to store the sets of data in the archives. 

 

DeduplicationRatio

 – The value in 

UniqueDataSize

 divided by the value in 

ArchiveDataSize

. This 

ratio shows how deduplication alone has reduced the space needed for the archives. For a non-
deduplicated vault, the value in this column is 

NULL

 

CompressionRatio

 – The value in 

OccupiedSpace

 divided by the value in 

ArchiveDataSize

. This 

ratio shows how deduplication (for deduplicated vaults) and archive compression have reduced 
the space needed for the archives. 

 

VaultName

 – The name of the managed vault 

 

VaultID

 – The unique identifier of the managed vault 

 

StorageNodeName

 – The name of the computer on which the storage node that manages the 

vault is installed 

 

StorageURI

 – The same as the 

StoragePath 

column of the 

Vaults

 view 

 

IsEncrypted

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

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: