Querying All Hardware Inventory Items of a Device

To extract all active hardware inventory items of device XYZ, use the following query:

mysql> SELECT                            dev.name,

                            dev.model,

                            hw.name,

                            hw.version,

                            hw.part_number,

                            hw.serial_number,

                            hw.description,

                            hw.chassis_id,

                            hw.module,

                            hw.submodule,

                            hw.subsubmodule,

                            hw.last_scanned,

                            hw.created_on

            FROM                demo.hardware_inventory hw 

     INNER JOIN                            demo.devices dev 

                 ON            hw.device_id = dev.id

         WHERE                    hw.deleted_on = 0 

              AND                dev.deleted_on = 0 

              AND                dev.name = 'XYZ';