Querying All Hardware Inventory Items of a Device

To extract all active hardware inventory items of device XYZ, use the following query. (Enter the entire MySQL command syntax on the same line.)

mysql> SELECTdev.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_onFROMdemo.hardware_inventory hw      INNER JOINdemo.devices dev  ONhw.device_id = dev.id WHEREhw.deleted_on = 0   ANDdev.deleted_on = 0   ANDdev.name = 'XYZ';