Forum GLPI-Project

artmin

Member

Registered: 2010-09-10

Posts: 1

Custom reports in glpi_infocoms of Computers, Printers, etc.

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

yllen

GLPI-DEV

From: Sillery (51)

Registered: 2008-01-14

Posts: 15,278

Re: Custom reports in glpi_infocoms of Computers, Printers, etc.

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)