HP Device Manager 4.6 - Database Schema Guide

Generate unsuccessful task information
The HPDM Task Report function cannot be used to generate task information where the status is not success, because a
criterion can only be set once. To find this task information, use the following procedure.
1. Locate the dm_device_subtasks table.
2. Write the following SQL statement:
select * from DB_NAME.dbo.dm_device_subtasks
where dm_device_subtasks.status != 'success';
3. View the results.
Display the task count grouped by task status
1. Locate the table dm_device_subtasks.
2. Write the following SQL statement:
select status, count(status) from DB_NAME.dbo.dm_device_subtasks group by status;
3. View the results.
59