You are not logged in.
Good night.
I am doing some Excel reports in GLPI and everything works perfectly, except for the fact that I could get some management reports, in particular is not or have not learned that tables should be in consultation with glpi_computers glpi_infocoms, i use:
select infc.items_id, comp.*, infc.*
from glpi_computers as comp
glpi_infocoms as infc inner join on (comp.entities_id = infc.entities_id and comp.id = infc.items_id)
WHERE itemtype = 'Computer'
Let me know if there any other way without having to specify the type (computer, peripherals, etc) in the where clausule.
For your attention, thank you!
Heeelppp!..
---
Martin
Offline
Look at financial reports in plugin Reports (in debug mode you can see SQL request)
CentOS 6.5 - CentOS 7.x
PHP 5.6 - PHP 7.x - MySQL 5.6 - MariaDB 10.2 + APC + oOPcache
GLPI from 0.72 to dev version
Certifiée ITIL (ITV2F, ITILF, ITILOSA)
Offline