GLPI Reports

alan-d · 2007-11-02 12:45:55

I have GLPI installed (No OCS attached yet) and all seems to be working normally.

Does anyone know how I can print or export a list of equipment in a Room?

I can bring up separate lists for Computers, Monitors etc in each room but I can't seem to be able to bring up a full list showing the computers and what is attached to them.

Is there a way of doing this?

While I'm on the subject - us there a way of creating your own default reports to add to the existing ones?

remi · 2007-11-02 16:42:04

Plugin reports (for glpi 0.7) is probably a solution to easily add new reports.

Regards

alan-d · 2007-11-02 16:46:34

Thanks - looks like I'll have to wait for the final version of 0.7 then.

pp7 · 2007-11-09 23:42:39

or use simple scripts to read databe as this one i made today, as i also need a list of equipement in a location
give an location id as argumnet and redirect output do file.html

#!/bin/sh
location_id=$1
dbname=glpi07
end=';'
echo "<html><body><b><pre>LOCATION:"
echo "select completename from glpi_dropdown_locations where id = $location_id;" | mysql -b -N $dbname
echo "</pre></b><br>"
date
echo '<h2>----------computers-----------</h2>'
echo "select c.name,c.contact,co.name,c.serial,c.otherserial from glpi_computers c left join glpi_contacts co on co.id=c.contact_num where c.location=$location_id and c.deleted =0 $end" | mysql -H $dbname
echo
echo '<h2>----------printers------------</h2>'
echo
echo "select c.name,c.contact,co.name,c.serial,c.otherserial from glpi_printers c left join glpi_contacts co on co.id=c.contact_num where c.location=$location_id and c.deleted=0 $end" | mysql -H $dbname
echo
echo '<h2>----------monitors------------</h2>'
echo
echo "select c.name,c.contact,co.name,c.serial,c.otherserial from glpi_monitors c left join glpi_contacts co on co.id=c.contact_num where c.location=$location_id and c.deleted=0 $end" | mysql -H $dbname
echo '</body><html>'

alan-d · 2007-11-12 10:06:23

Thanks - I'll give it a try

rbrady · 2009-03-23 20:44:25

how can I get a report showing number of help tickets by category?

tbsoares · 2010-02-09 16:43:25

I really would like to know: "how can I get a report showing number of help tickets by category?"

Tks in advance!!

Maska · 2010-02-10 19:16:35

I not sure that I understand.
But try go in: Assistance -> Statistics -> By tickets -> In dropdown list select "Category" in group of "Characteristics" -> Click button "Update"

Forum GLPI-Project

Announcement

#1 2007-11-02 12:45:55

GLPI Reports

#2 2007-11-02 16:42:04

Re: GLPI Reports

#3 2007-11-02 16:46:34

Re: GLPI Reports

#4 2007-11-09 23:42:39

Re: GLPI Reports

#5 2007-11-12 10:06:23

Re: GLPI Reports

#6 2009-03-23 20:44:25

Re: GLPI Reports

#7 2010-02-09 16:43:25

Re: GLPI Reports

#8 2010-02-10 19:16:35

Re: GLPI Reports

Board footer