HP Device Manager 4.5 - Database Schema Guide

65
Generate unsuccessful task information
We need task information where the status is NOT “success”. We cannot generate this kind of report using
the HPDM Task Report function because, currently, a criterion can only be set once.
Let’s write an SQL statement to do it:
1. Locate the
Task-related tables category and the table named dm_device_subtasks.
2. Write the SQL statement:
select * from DB_NAME.dbo.dm_device_subtasks
where dm_device_subtasks.status != 'success';
3. The results should be as shown below:
Display task count grouped by task status
1. Locate the table dm_device_subtasks.
2. Write the SQL statement:
select status, count(status) from DB_NAME.dbo.dm_device_subtasks group by status;
3. The results should be as shown below: