Hi,

it would be nice to have something like "Export a List of Hardware" from Devices via Button in Devices App GUI.

In SQL we have tested something like this:

Show all Devices which are Online:

SELECT d.id, d.hw_id, d.product, dc.category_id, c.name FROM devices d LEFT JOIN device_categories dc ON d.id = dc.device_id LEFT JOIN categories c ON dc.category_id = c.id WHERE Xonline= 't';

Show all Devices , including offline Devices:

SELECT d.id, d.hw_id, d.product, dc.category_id, c.name FROM devices d LEFT JOIN device_categories dc ON d.id = dc.device_id LEFT JOIN categories c ON dc.category_id = c.id

Maybe with this SQL Statement in the Backend it would be easy to create a Button for this.

For us this would be an easy way to get something like an Inventar, without write a special App for this "little" feature.

Best Regards,

Peter