i want to create statistics to count ticket based on ci

[denbagusjkt]

i want to create statistics to count ticket based on config item. for example, i want to create report that count ticket based on server A (CI). I try to create new stats, but still cannot found this feature. I know we can create stats based on CI or ticket (with dynamic-object option), but not for both (ticket and CI combined).

[denbagusjkt]

is there another reporting module instead of statistics

[jojo]

SQL via external tools

[denbagusjkt]

what do you mean about eksternal tools? do you mean is another application that use otrs database? otrs table is very complicated to me to understand how its work. may be it is last choice for mo to do, before using soap webservice.

is the any example to hack statistics module to do that, specifically by adding link-object for filtering. I am perl newbie, but absolutely understand php programming.

[jojo]

The OTRS database is well documented and quite simple.

You can use all external reporting tools like Jasper Reports, Birt etc