HP Device Manager 4.6 - Database Schema Guide

Use the following procedure to determine which devices do not use auto-map FTP based on the results of the previous
procedure.
1. Locate the table dm_repo_mapping.
2. Join the tables dm_devices and dm_repo_mapping using the following SQL statements:
Select dm_devices.device_NAME, dm_devices.active
from DB_NAME.dbo.dm_devices, DB_NAME.dbo.dm_repo_mapping
where dm_devices.active = 'on' and dm_devices.device_id = dm_repo_mapping.map_key
and dm_repo_mapping.category = 3;
3. View the results.
Generate all device inventory information
1. Locate the Device-related tables, which include the dm_devices table and the inventory-related tables.
2. Write the following SQL statements. You can use left join to connect all the tables you need. Left join will generate the
related results.
-- You can replace the "*" with specified columns you care about
select * from DB_NAME.dbo.dm_devices
-- append hardware information
left join DB_NAME.dbo.dm_inv_hardware
on dm_devices.device_id = dm_inv_hardware.device_id
-- append software information
left join DB_NAME.dbo.dm_inv_software
on dm_devices.device_id = dm_inv_software.device_id
-- append ewf information
left join DB_NAME.dbo.dm_inv_ewf
on dm_devices.device_id = dm_inv_ewf.device_id
-- append display information
left join DB_NAME.dbo.dm_inv_display
on dm_devices.device_id = dm_inv_display.device_id
-- … (you can keep appending the table)
-- If you want devices with specified device ID information, you can add a “where” clause:
where dm_devices.device_id = "xxxxx";
3. View the results.
58