php script to monitor OTRS queue size from SNMP
February 18th, 2014 Posted in Linux, MySQL, PHP & PW最近公司上线OTRS，感觉还不错，顾问居然还给了数据库的结构图，闲下来就写了这个php脚本给Opsview用来监控OTRS支持队列的大小。别问我为什么用php…因为我实在是不会pel….
测试环境：
|
1 2 3 4 |
DISTRIB_ID=Ubuntu DISTRIB_RELEASE=12.04 DISTRIB_CODENAME=precise DISTRIB_DESCRIPTION="Ubuntu 12.04.4 LTS" |
废话不说，先帖脚本：
|
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 |
#!/usr/bin/php <?php # Tomas Tang on 18/02/2014 # Check the OTRS support queue size # Disable error report error_reporting(0); # get arguments $procname = $argv[0]; $queuename = $argv[1]; $warnlevel = $argv[2]; $critilevel = $argv[3]; # keep it for future develop #$QUEUE = array( # "allnew", # "escalated", # "second_level_support", # "first_level_support", #); # set query SQL and help if("$queuename"=='allnew'){ # all the tickets with state new but not in delete queue $sql = "select count(1) from ticket where ticket_state_id=1 and queue_id!=3;"; }elseif("$queuename"=='escalated'){ # not in use yet, to be finished $sql = "select count(1) from ticket where ticket_state_id=1 and queue_id!=3;"; }elseif("$queuename"=='first_level_support'){ # all tickets which are not (pending to) closed $sql = "select count(1) from ticket where ticket_state_id in (1,4,6,11) and queue_id=5;"; }elseif("$queuename"=='second_level_support'){ # all tickets which are not (pending to) closed $sql = "select count(1) from ticket where ticket_state_id in (1,4,6,11) and queue_id=6;"; }else{ echo "Usage: $procname <QueueName> <WarnNumber> <CriticalNumber>\n"; echo " QueueName: Queueu name to query, right now only in \"allnew\",\"escalated\",\"first_level_support\" and \"second_level_support\"\n"; echo " WarnNumber: Tickets quantity start to be warn, required\n"; echo " CriticalNumber: Tickets quantity start to be critical, must greater than WarnNumber, required\n"; exit(3); } # Double check query SQL if(empty($sql)){ echo "UNKNOWN - Unknown error\n"; exit(3); } # Check arguments again. if(!is_numeric("$warnlevel")||!is_numeric("$critilevel")){ echo "UNKNOWN - Incorrect arguments.\n"; exit(3); }elseif($warnlevel>=$critilevel){ echo "UNKNOWN - Incorrect warn/critical level.\n"; exit(3); } # connect to database $conn = @mysql_connect("localhost","readonly","readonly") or die("Cannot connect to DB"); mysql_select_db("otrs",$conn); # fetch data $result = mysql_query("$sql",$conn) or die("Query failed"); $result = mysql_result($result,0); # close db mysql_close($conn); if ($result>=$critilevel){ echo "CRITICAL - Queue size is $result, queue is huge!!!\n"; exit(2); }elseif($result>=$warnlevel){ echo "WARN - Queue size is $result, queue is big!\n"; exit(1); }else{ echo "OK - Queue size is $result, queue is OK.\n"; exit(0); } ?> |
脚本本身没什么好看的，不过最开始用来传参的东西还是蛮好玩的，这种脚本不能跟在web里面一直的传参，只能通过这个叫$argv的数组。
把脚本保存为
修改/etc/snmp/snmpd.conf，加上下面几行
|
1 2 3 |
exec otrs_new_tickets /usr/local/bin/check_otrs_queue allnew 15 20 exec first_level_support /usr/local/bin/check_otrs_queue first_level_support 30 50 exec second_level_support /usr/local/bin/check_otrs_queue second_level_support 10 15 |
最后就是使用check_snmp_exec.sh检测了~~~