You are not logged in.

Announcement

 Téléchargez la dernière version stable de GLPI      -     Et vous, que pouvez vous faire pour le projet GLPI ? :  Contribuer
 Download last stable version of GLPI                      -     What can you do for GLPI ? :  Contribute

#1 2006-01-28 19:21:26

jellobui
Member
Registered: 2006-01-22
Posts: 16

How to query computer with connected printer, monitor, & devices?

I installed the myODBC driver and wanted to create a query in Excel a list of computers along with their connected Printer, Monitor and Devices but having difficulties locating the right relationship between these tables.

Can someone points me out what how are the relationship schema between the glpi_computer with glpi_printer - glpi_monitor -glpi_peripherals and how to properly query them.

In the documenation website all these tables seem to interconnect through glpi_connect_wire table but I can seem to figure the correlation.

Thanks?

Offline

Board footer

Powered by FluxBB