Reports Plugin

bwm367 · 2009-08-03 17:54:16

I posted a while ago about the reports plugin, and was just wondering if progress was being made on users being able to create custom reports?
I'm looking for something to generate a detailed list of all Computers, Monitors, etc at a particular Location. Any idea on how to do this with or without the reporting plugin?
Any third party SQL reporting tools that users here know of?

ddurieux · 2009-08-03 17:56:45

Try with search in computer list and can export in CSV or PDF

bwm367 · 2009-08-03 18:00:13

That's exactly what I've been doing, it seems to be the best way to generate reports. I was just wondering if anyone has alternatives? What do other people use?

Bug Reporter · 2009-08-03 20:19:21

I use the reports plugin. Creating new reports isn't too bad if you know how to write SQL and understand the schema, since you need to write the SQL statements yourself and place them into files. I used the reports that came with the plugin to figure out how to write custom reports. It took some time, but I got through it. This forum is a great resource also if you need help writing the query.

I don't know of any plugins that have a graphic interface at this time, like the search function embedded in GLPI. I usually write reports when I want a query to span multiple or all device types.

You can also put GLPI in debug mode to see SQL statements that get executed for different screens to get you started.

bwm367 · 2009-08-04 16:41:07

Thanks for the advice.

jasafpro · 2009-08-07 18:50:52

I created a new report that I think would be helpful to others. Would I just use the code tags and post it here or is there a specific place to submit some code. Its 200+ lines.

The report itself creates a Time per ticket per User's Followup. Also it uses Activity for tracking time that isn't a ticket such as meetings and creates totals for each entity.

remi · 2009-08-07 21:03:52

You can send it to the devel ML

http://www.glpi-project.org/spip.php?article57

+

jasafpro · 2009-08-13 19:25:02

Remi

I tried to send it to the dev list, but I get a rejected message. Do I have to be a subscriber to post? I am not a developer, I would just like to get what I have into more capable hands

remi · 2009-08-13 19:31:34

Yes you need to subscribe to be able to post.

+

z_haseeb · 2010-01-29 15:07:25

i am new in linux.....i have got a report plugin for glpi . how can i install it

GLPI plugin
https://forge.indepnet.net/projects/list_files/reports

thanks

z_haseeb · 2010-01-29 15:28:12

thanks i have done it

aabc2 · 2012-08-28 10:56:49

I wrote my report, but it's not working:
<?php

$USEDBREPLICATE= 1;
$DBCONNECION_REQUIRED= 0;

define('GLPI_ROOT', '../../../..');
include(GLPI_ROOT."/inc/includes.php");

$report = new PluginReportsAutoReport();

$report->setColumns(array(new PluginReportsColumn('cname', $LANG['common'][1],
new PluginReportsColumn('dname', $LANG['common'][2],
new PluginReportsColumn('device', $LANG['common'][3],
new PluginReportsColumn('device', $LANG['common'][4],
new PluginReportsColumn('name', $LANG['common'][5],
new PluginReportsColumn('totalsize', $LANG['common'][6],
new PluginReportsColumn('freesize', $LANG['common'][7])));
$query = "SELECT
`glpi_computers`.`name` AS "Komputer",
`glpi_computerdisks`.`name` AS "Nazwa",
`glpi_computerdisks`.`device` AS "Partycja",
`glpi_computerdisks`.`mountpoint` AS "Punkt montowania",
`glpi_filesystems`.`name` AS "Plik systemowy",
`glpi_computerdisks`.`totalsize` AS "Rozmiar",
`glpi_computerdisks`.`freesize` AS "Wolne miejsce"
FROM `glpi_computerdisks`
LEFT JOIN `glpi_filesystems` ON ( `glpi_filesystems`.`id` = `glpi_computerdisks`.`filesystems_id` )
LEFT JOIN `glpi_computers` ON ( `glpi_computers`.`id` = `glpi_computerdisks`.`computers_id` )".
getEntitiesRestrictRequest(" WHERE ", "glpi_computerdisks") ."
ORDER BY `glpi_computers`.`name`, `glpi_computerdisks`.`freesize`";

$report->setGroupBy(array(`glpi_computers`.`name`));
$report->setSqlRequest($query);
$report->execute();
?>

do you know why?

Forum GLPI-Project

Announcement

#1 2009-08-03 17:54:16

Reports Plugin

#2 2009-08-03 17:56:45

Re: Reports Plugin

#3 2009-08-03 18:00:13

Re: Reports Plugin

#4 2009-08-03 20:19:21

Re: Reports Plugin

#5 2009-08-04 16:41:07

Re: Reports Plugin

#6 2009-08-07 18:50:52

Re: Reports Plugin

#7 2009-08-07 21:03:52

Re: Reports Plugin

#8 2009-08-13 19:25:02

Re: Reports Plugin

#9 2009-08-13 19:31:34

Re: Reports Plugin

#10 2010-01-29 15:07:25

Re: Reports Plugin

#11 2010-01-29 15:28:12

Re: Reports Plugin

#12 2012-08-28 10:56:49

Re: Reports Plugin

Board footer