HP Device Manager 4.6 - Database Schema Guide

Other diagrams
Examples
Generate device information
To find the device name and status for all operating system types, use the following procedure. The Device Report function
will also generate these results, but will include more information than necessary.
1. Connect to the database server.
2. Locate the table dm_devices.
3. Write the following SQL statements, which include only the device name and if the status is on:
select device_name, active
from DB_NAME.dbo.dm_devices
where dm_devices.active = 'on';
4. View the results.
57