background image

22

 

Copyright © Acronis, Inc., 2000-2009 

 

 

 

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. 

For tasks belonging to a backup plan that backs up virtual machines, the value in this column is 
the name of the physical machine where the agent managing the virtual machine (such as Agent 
for ESX/ESXi) is installed, whereas the value in the 

ManagedEntityName

 column is the name of 

the virtual machine. 

 

StartTime

 – The date and time when the task activity started 

 

FinishTime

 – The date and time when the task activity finished, regardless of the result 

Tip: 

Based on the values in the 

FinishTime 

and 

StartTime 

columns, you can determine 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 few seconds due to logging latency. 

 

Result 

– The result of the task activity. The possible values here are the same as those in the 

LastResult

 column of the 

Tasks 

view.  

 

ID

 – The unique identifier of the task activity 

 

TaskID

 – The same as the 

ID 

column of the 

Tasks 

view. 

 

ManagedEntityID

 – The same as the 

ManagedEntityID 

column of the  

Tasks

 view, except that the 

identifier 

00000000-0000-0000-0000-000000000000

 is used here instead of 

NULL

 

 

PolicyID

 – The unique identifier of the backup policy on which the task is based. If the task is not 

based on a backup plan, the value in this column is 

00000000-0000-0000-0000-000000000000

Note:

 For a local backup plan, this column identifies an equivalent of the backup policy, which uniquely 

corresponds to the backup plan. Through this column, the 

TaskActivities 

view is linked with the 

BackupPlans

 view (p. 14)—see the 

PolicyID

 column in that view. 

 

HostID

 – The same as the 

HostID 

column of the 

Tasks 

view 

 

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: