check_otrs.php

• php for cli
• php with mysql support

Tested with otrs-version 2.0.4.

check_otrs.php v0.1 (29 Dezember, 2008)

Count tickets in otrs

Usage:check_otrs.php -H host -u user -p pass -d dbname -q queuename -t type [-w ] [-c ] [-l ] [-h]

Options:

-h
Print help screen
-H
MySql hostname
-u
MySql user
-p
MySql pass
-d
MySql db-name
-q
Queue to query
-t
Type to query by typing the ID (for example 4 = open tickets in default configuration)
You also can use "*" for all types, by using double quotes. [default]

-w
Warning
-c
Critical
-l
Query to mysql database from otrs to inform about available queues or types.
MySql information are required.

Example:

check_otrs.php -H 192.168.1.2 -d otrs -u someuser -p somepass -t 4 -q Hardware::Drucker -w 5 -c 9
8 Tickets in queue Hardware::Drucker from type open|Hardware::Drucker=8;5;9;0;

check_otrs.php -H 192.168.1.2 -d otrs -u someuser -p somepass -q Hardware::Drucker
751 Tickets in queue Hardware::Drucker from type |Hardware::Drucker=751;0;0;0;

check_otrs.php -H 192.168.1.2 -d otrs -u someuser -p somepass -l type
1 new
2 closed successful
3 closed unsuccessful
4 open
5 removed
6 pending reminder
7 pending auto close+
8 pending auto close-
9 merged

check_otrs.php -H 192.168.1.2 -d otrs -u someuser -p somepass -l queue
1 Raw
2 Drucker
3 System::Linux