ACRONIS BACKUP RECOVERY 10 MANAGEMENT SERVER REPORTS -, Installation Manual

Page: 21 / 23

Copyright © Acronis, Inc., 2000-2009 21
 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.
By joining this view and the view of a current report, you can get a more thorough report. For
example, by using the
PolicyID column, you can get information about both the task activities and
their backup plans.
Keep in mind, however, that, because this is the view of a historical report, it may include tasks
which, together with the corresponding backup plans, no longer exist. This means that such backup
plans are not present in the report views for current reports.
6.2.2 Query samples

The following 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.example.com' AND
Result = 'FAILED' ORDER BY StartTime

The following query returns the failure/success statistics of all tasks for the last 30 days:
SELECT
TaskID,
TaskName,
SUM(CASE WHEN Result = 'SUCCEEDED' THEN 1 ELSE 0 END) SuccessCount,
SUM(CASE WHEN Result = 'SUCCEEDED WITH WARNINGS' THEN 1 ELSE 0 END)
WarningCount,
SUM(CASE WHEN Result = 'FAILED' THEN 1 ELSE 0 END) FailureCount
FROM
TaskActivities
WHERE
DATEDIFF(d, FinishTime, GETUTCDATE()) < 30
GROUP BY TaskID, TaskName
ORDER BY TaskName ASC
6.2.3 Column values
The TaskActivities view contains the following columns:
 TaskName – The same as the Name column of the Tasks view (p. 10)

Owner – The same as the Owner column of the Tasks view
 ManagedEntityName – For tasks that belong to a backup plan: the name of the physical or virtual
machine which the task backs up or whose backups it validates. For other types of tasks: an
empty string (
''
).
Known issue: For tasks of a local backup plan that exists on an Agent for ESX/ESXi virtual appliance, the
value in this column is the name of the virtual appliance.