A script based query to give ISDN Calls In and Out from the SNMP Transmission MIB. I've successfully used this for with Cisco 7206 with PRI and 1603 with BRI.

Available Graphs are for ISDN Calls In & Out and Connected ISDN Calls In & Out expressed in Calls per Minute.

Full Details

ZIP of XML for Query and Tempate Import + Script

The script file (query_host_isdncalls.php) should be copied to cacti/scripts directory.
The query xml (host_isdncalls.xml) should be copied to cacti/resource/script_query directory.

Example Query Output...


Deano

I'm having trouble getting this working on a Windows Server.

The Data Query debug indicates

+ Running data query [10].
+ Found type = '4 '[script query].
+ Found data query XML file at 'C:\Websites\Cacti/resource/script_queries/host_isdncalls.xml'
+ XML file parsed ok.
+ Executing script for list of indexes 'c:\php\php.exe -q C:\Websites\Cacti\scripts\query_host_isdncalls.php XXX.XXX.XXX.XXX XXXX 1 index'
+ Executing script query 'c:\php\php.exe -q C:\Websites\Cacti\scripts\query_host_isdncalls.php XXX.XXX.XXX.XXX XXXX 1 query index'
+ Executing script query 'c:\php\php.exe -q C:\Websites\Cacti\scripts\query_host_isdncalls.php XXX.XXX.XXX.XXX XXXX 1 query chcount'
+ Executing script query 'c:\php\php.exe -q C:\Websites\Cacti\scripts\query_host_isdncalls.php XXX.XXX.XXX.XXX XXXX 1 query status'
+ Executing script query 'c:\php\php.exe -q C:\Websites\Cacti\scripts\query_host_isdncalls.php XXX.XXX.XXX.XXX XXXX 1 query ifDescr'
+ Executing script query 'c:\php\php.exe -q C:\Websites\Cacti\scripts\query_host_isdncalls.php XXX.XXX.XXX.XXX XXXX 1 query ifName'
+ Executing script query 'c:\php\php.exe -q C:\Websites\Cacti\scripts\query_host_isdncalls.php XXX.XXX.XXX.XXX XXXX 1 query ifAlias'
+ Executing script query 'c:\php\php.exe -q C:\Websites\Cacti\scripts\query_host_isdncalls.php XXX.XXX.XXX.XXX XXXX 1 query ifType'
+ Executing script query 'c:\php\php.exe -q C:\Websites\Cacti\scripts\query_host_isdncalls.php XXX.XXX.XXX.XXX XXXX 1 query ifAdminStatus'
+ Executing script query 'c:\php\php.exe -q C:\Websites\Cacti\scripts\query_host_isdncalls.php XXX.XXX.XXX.XXX XXXX 1 query ifOperStatus'
+ Found data query XML file at 'C:\Websites\Cacti/resource/script_queries/host_isdncalls.xml'
+ Found data query XML file at 'C:\Websites\Cacti/resource/script_queries/host_isdncalls.xml'
+ Found data query XML file at 'C:\Websites\Cacti/resource/script_queries/host_isdncalls.xml'

but with no items or rows discovered. This isnt creating a RRD file nor resulting in any data be displayed in the Data query section of create graphs.

Any ideas on how to troubleshoot this? Some feedback would be greatly appreciated.

Thanks in advance

My script discover ISDN correctly:

+ Running data query [10].
+ Found type = '4 '[script query].
+ Found data query XML file at '/var/www/localhost/htdocs/cacti/resource/script_queries/host_isdncalls.xml'
+ XML file parsed ok.
+ Executing script for list of indexes '/usr/bin/php -q /var/www/localhost/htdocs/cacti/scripts/query_host_isdncalls.php 192.168.X.X XXXX 1 index'
+ Executing script query '/usr/bin/php -q /var/www/localhost/htdocs/cacti/scripts/query_host_isdncalls.php 192.168.X.X XXXX 1 query index'
+ Found item [isdnSignalingifIndex='0'] index: 0
+ Found item [isdnSignalingifIndex='1'] index: 1
+ Found item [isdnSignalingifIndex='2'] index: 2
+ Found item [isdnSignalingifIndex='3'] index: 3
+ Executing script query '/usr/bin/php -q /var/www/localhost/htdocs/cacti/scripts/query_host_isdncalls.php 192.168.X.X XXXX 1 query chcount'
+ Found item [isdnSignalingBchannelCount='2'] index: 0
+ Found item [isdnSignalingBchannelCount='2'] index: 1
+ Found item [isdnSignalingBchannelCount='2'] index: 2
+ Found item [isdnSignalingBchannelCount='2'] index: 3
+ Executing script query '/usr/bin/php -q /var/www/localhost/htdocs/cacti/scripts/query_host_isdncalls.php 192.168.X.X XXXX 1 query status'
+ Found item [isdnSignalingStatus='1'] index: 0
+ Found item [isdnSignalingStatus='1'] index: 1
+ Found item [isdnSignalingStatus='1'] index: 2
+ Found item [isdnSignalingStatus='1'] index: 3
+ Executing script query '/usr/bin/php -q /var/www/localhost/htdocs/cacti/scripts/query_host_isdncalls.php 192.168.X.X XXXX 1 query ifDescr'
+ Found item [ifDescr='BRI1/0-Signaling'] index: 0
+ Found item [ifDescr='BRI1/1-Signaling'] index: 1
+ Found item [ifDescr='BRI1/2-Signaling'] index: 2
+ Found item [ifDescr='BRI1/3-Signaling'] index: 3
+ Executing script query '/usr/bin/php -q /var/www/localhost/htdocs/cacti/scripts/query_host_isdncalls.php 192.168.X.X XXXX 1 query ifName'
+ Found item [ifName='BR1/0'] index: 0
+ Found item [ifName='BR1/1'] index: 1
+ Found item [ifName='BR1/2'] index: 2
+ Found item [ifName='BR1/3'] index: 3
+ Executing script query '/usr/bin/php -q /var/www/localhost/htdocs/cacti/scripts/query_host_isdncalls.php 192.168.X.X XXXX 1 query ifAlias'
+ Found item [ifAlias='4329650'] index: 0
+ Found item [ifAlias='4329660'] index: 1
+ Found item [ifAlias='4286960_9'] index: 2
+ Found item [ifAlias=''] index: 3
+ Executing script query '/usr/bin/php -q /var/www/localhost/htdocs/cacti/scripts/query_host_isdncalls.php 192.168.X.X XXXX 1 query ifType'
+ Found item [ifType='isdn(63)'] index: 0
+ Found item [ifType='isdn(63)'] index: 1
+ Found item [ifType='isdn(63)'] index: 2
+ Found item [ifType='isdn(63)'] index: 3
+ Executing script query '/usr/bin/php -q /var/www/localhost/htdocs/cacti/scripts/query_host_isdncalls.php 192.168.X.X XXXX 1 query ifAdminStatus'
+ Found item [ifAdminStatus='up(1)'] index: 0
+ Found item [ifAdminStatus='up(1)'] index: 1
+ Found item [ifAdminStatus='up(1)'] index: 2
+ Found item [ifAdminStatus='down(2)'] index: 3
+ Executing script query '/usr/bin/php -q /var/www/localhost/htdocs/cacti/scripts/query_host_isdncalls.php 192.168.X.X XXXX 1 query ifOperStatus'
+ Found item [ifOperStatus='dormant(5)'] index: 0
+ Found item [ifOperStatus='dormant(5)'] index: 1
+ Found item [ifOperStatus='dormant(5)'] index: 2
+ Found item [ifOperStatus='down(2)'] index: 3
+ Found data query XML file at '/var/www/localhost/htdocs/cacti/resource/script_queries/host_isdncalls.xml'
+ Found data query XML file at '/var/www/localhost/htdocs/cacti/resource/script_queries/host_isdncalls.xml'
+ Found data query XML file at '/var/www/localhost/htdocs/cacti/resource/script_queries/host_isdncalls.xml'

and when i'm trying to add monitoring then i get this message:

Notice: Undefined index: sgg_10 in /var/www/localhost/htdocs/cacti/graphs_new.php on line 71

Notice: Undefined index: sgg_10 in /var/www/localhost/htdocs/cacti/graphs_new.php on line 71

Notice: Undefined index: sgg_10 in /var/www/localhost/htdocs/cacti/graphs_new.php on line 71

Warning: Cannot modify header information - headers already sent by (output started at /var/www/localhost/htdocs/cacti/graphs_new.php:71) in /var/www/localhost/htdocs/cacti/graphs_new.php on line 310

What can be wrong???

Hi,

I'm using this script for a Cisco 2600 with an E1 interface and I get following graphs.

Are these values correct or how should I interpret this output ?

Screenshot002.jpg looks right if you have 1 call every 20 minute or so.

Change values to Exact Numbers, to get a real number 0.003 instead of a 3micro minutes.


/Christofer

hey

thanks for the script it works well. Just wondering though how do i automaticaly get the graph to divide each value by 200 to get the correct value ? i.e 200 = 1 call on the graph ?

thanks

I'm having the same problem. Cacti shows one call at 200m?! Does anyone have a solution for this problem?

Hi,
I'm using a Cisco 2800 (2821 with a dual PRI) Series Integrated Services Router, the initial query works fine.

+ Running data query [12].
+ Found type = '4 '[script query].
+ Found data query XML file at '/var/www/html/cacti/resource/script_queries/host_isdncalls.xml'
+ XML file parsed ok.
+ Executing script for list of indexes '/usr/bin/php -q /var/www/html/cacti/scripts/query_host_isdncalls.php 192.168.1.1 public 1 index'
+ Executing script query '/usr/bin/php -q /var/www/html/cacti/scripts/query_host_isdncalls.php 192.168.1.1 public 1 query index'
+ Found item [isdnSignalingifIndex='0'] index: 0
+ Found item [isdnSignalingifIndex='1'] index: 1
+ Executing script query '/usr/bin/php -q /var/www/html/cacti/scripts/query_host_isdncalls.php 192.168.1.1 public 1 query chcount'
+ Found item [isdnSignalingBchannelCount='23'] index: 0
+ Found item [isdnSignalingBchannelCount='23'] index: 1
+ Executing script query '/usr/bin/php -q /var/www/html/cacti/scripts/query_host_isdncalls.php 192.168.1.1 public 1 query status'
+ Found item [isdnSignalingStatus='1'] index: 0
+ Found item [isdnSignalingStatus='1'] index: 1
+ Executing script query '/usr/bin/php -q /var/www/html/cacti/scripts/query_host_isdncalls.php 192.168.1.1 public 1 query ifDescr'
+ Found item [ifDescr='Serial0/0/0:23-Signaling'] index: 0
+ Found item [ifDescr='Serial0/0/1:23-Signaling'] index: 1
+ Executing script query '/usr/bin/php -q /var/www/html/cacti/scripts/query_host_isdncalls.php 192.168.1.1 public 1 query ifName'
+ Found item [ifName='Se0/0/0:23'] index: 0
+ Found item [ifName='Se0/0/1:23'] index: 1
+ Executing script query '/usr/bin/php -q /var/www/html/cacti/scripts/query_host_isdncalls.php 192.168.1.1 public 1 query ifAlias'
+ Found item [ifAlias=''] index: 0
+ Found item [ifAlias=''] index: 1
+ Executing script query '/usr/bin/php -q /var/www/html/cacti/scripts/query_host_isdncalls.php 192.168.1.1 public 1 query ifType'
+ Found item [ifType='isdn(63)'] index: 0
+ Found item [ifType='isdn(63)'] index: 1
+ Executing script query '/usr/bin/php -q /var/www/html/cacti/scripts/query_host_isdncalls.php 192.168.1.1 public 1 query ifAdminStatus'
+ Found item [ifAdminStatus='up(1)'] index: 0
+ Found item [ifAdminStatus='up(1)'] index: 1
+ Executing script query '/usr/bin/php -q /var/www/html/cacti/scripts/query_host_isdncalls.php 192.168.1.1 public 1 query ifOperStatus'
+ Found item [ifOperStatus='dormant(5)'] index: 0
+ Found item [ifOperStatus='dormant(5)'] index: 1
+ Found data query XML file at '/var/www/html/cacti/resource/script_queries/host_isdncalls.xml'
+ Found data query XML file at '/var/www/html/cacti/resource/script_queries/host_isdncalls.xml'
+ Found data query XML file at '/var/www/html/cacti/resource/script_queries/host_isdncalls.xml'
+ Found data query XML file at '/var/www/html/cacti/resource/script_queries/host_isdncalls.xml'
+ Found data query XML file at '/var/www/html/cacti/resource/script_queries/host_isdncalls.xml'
+ Found data query XML file at '/var/www/html/cacti/resource/script_queries/host_isdncalls.xml'
+ Found data query XML file at '/var/www/html/cacti/resource/script_queries/host_isdncalls.xml'
+ Found data query XML file at '/var/www/html/cacti/resource/script_queries/host_isdncalls.xml'
+ Found data query XML file at '/var/www/html/cacti/resource/script_queries/host_isdncalls.xml'
+ Found data query XML file at '/var/www/html/cacti/resource/script_queries/host_isdncalls.xml'
+ Found data query XML file at '/var/www/html/cacti/resource/script_queries/host_isdncalls.xml'

However the polling get method does not work, it returns a U? I started with v1 then switch to v2 which gave me a little bit more info.

10/18/2006 07:38:42 PM - CMDPHP: Poller[0] DEBUG: SQL Exec: "insert into poller_output (local_data_id, rrd_name, time, output) values (50, 'isdn_callsout', '2006-10-18 19:38:41', 'U')"
10/18/2006 07:38:42 PM - CMDPHP: Poller[0] Host[6] DS[50] CMD: /usr/bin/php -q /var/www/html/cacti/scripts/query_host_isdncalls.php 192.168.1.1 public 2 get calls_out 1, output: U
10/18/2006 07:38:42 PM - CMDPHP: Poller[0] Host[6] DS[50] WARNING: Result from CMD not valid. Partial Result: No Such Instance cur

I spent several hours teaching myself what I can about all of this (to no avail) and it appears that the 2800 series does not use SNMP Transmission MIB (.1.3.6.1.2.1.10.20.1.3.2.1). I am going through the Cisco documentation attempting to find out the new oid's. I am curious is anyone else has successful manipulated this to work with a 2800? Any hints or help would be very appreciated.

What's the difference between In/Out and In/Out connected? Seems a bit odd to me. If the call isn't connected...it's....not connected.

Coolhand,

I have ran into the same issue. Did you find out the correct OID for 2821 to poll from?

Thx.

Script update for cacti-0.8.7a

begin 644 query_host_isdncalls.php-0.8.7a.diff
M+2TM("]T;7`O<75E<GE?:&]S=%]I<V1N8V%L;',N<&AP"3(P,#@M,#,M,#8@
M,3$Z,S<Z,#(N,#`P,#`P,#`P("LP-C`P"BLK*R!Q=65R>5]H;W-T7VES9&YC
M86QL<RYP:'`),C`P."TP,RTP-B`Q-#HT-CHP."XP,#`P,#`P,#`@*S`V,#`*
M0$`@+3$L-R`K,2PW($!`"B`\/W!H<`H@"B`D;F]?:'1T<%]H96%D97)S(#T@
M=')U93L*+6EN8VQU9&4H9&ER;F%M92A?7T9)3$5?7RD@+B`B+RXN+VEN8VQU
M9&4O8V]N9FEG+G!H<"(I.PHK:6YC;'5D92AD:7)N86UE*%]?1DE,15]?*2`N
M("(O+BXO:6YC;'5D92]G;&]B86PN<&AP(BD["B!I;F-L=61E*&1I<FYA;64H
M7U]&24Q%7U\I("X@(B\N+B]L:6(O<VYM<"YP:'`B*3L*(`H@)&]I9',@/2!A
M<G)A>2@B:6YD97@B(#T^("(Q+C,N-BXQ+C(N,2XQ,"XR,"XQ+C,N,BXQ+C(B
M+`I`0"`M,3$P+#<@*S$Q,"PW($!`"B`)"6-A<V4@)VEF06QI87,G.@H@"0EC
M87-E("=I9D%D;6EN4W1A='5S)SH*(`D)8V%S92`G:69/<&5R4W1A='5S)SH*
M+0D)"21A<G)?:6YD97@@/2!R96EN9&5X*&-A8W1I7W-N;7!?=V%L:R@D:&]S
M=&YA;64L("1S;FUP7V-O;6UU;FET>2P@)&]I9'-;(FEN9&5X(ETL("1S;FUP
M7W9E<G-I;VXL("(B+"`B(BP@,38Q+"`Q,#`P*2D["BL)"0DD87)R7VEN9&5X
M(#T@<F5I;F1E>"AC86-T:5]S;FUP7W=A;&LH)&AO<W1N86UE+"`D<VYM<%]C
M;VUM=6YI='DL("1O:61S6R)I;F1E>")=+"`D<VYM<%]V97)S:6]N+"`B(BP@
M(B(L("(B+"`B(BP@(B(L("(B+"`B(BP@,38Q+"`Q,#`P*2D["B`)"0DD=%]O
M:60@/2`D:69O:61S6R1A<F==+B(N(BXD87)R7VEN9&5X6R1I;F1E>%T["B`)
M"0EP<FEN="!C86-T:5]S;FUP7V=E="@D:&]S=&YA;64L("1S;FUP7V-O;6UU
M;FET>2P@)'1?;VED+"`D<VYM<%]V97)S:6]N+"`B(BP@(B(L(#$V,2P@,3`P
M,"D["B`)"0EB<F5A:SL*0$`@+3$R,RPW("LQ,C,L-R!`0`H@9G5N8W1I;VX@
M9V5T7VEF:6YF;R@D:&]S=&YA;64L("1S;FUP7V-O;6UU;FET>2P@)'-N;7!?
M=F5R<VEO;BP@)&%R9RD@>PH@"6=L;V)A;"`D;VED<RPD:69O:61S.PH@"0D)
M"0D*+0DD87)R7VEN9&5X(#T@<F5I;F1E>"AC86-T:5]S;FUP7W=A;&LH)&AO
M<W1N86UE+"`D<VYM<%]C;VUM=6YI='DL("1O:61S6R)I;F1E>")=+"`D<VYM
M<%]V97)S:6]N+"`B(BP@(B(L(#$V,2P@,3`P,"DI.PHK"21A<G)?:6YD97@@
M/2!R96EN9&5X*&-A8W1I7W-N;7!?=V%L:R@D:&]S=&YA;64L("1S;FUP7V-O
M;6UU;FET>2P@)&]I9'-;(FEN9&5X(ETL("1S;FUP7W9E<G-I;VXL("(B+"`B
M(BP@(B(L("(B+"`B(BP@(B(L("(B+"`Q-C$L(#$P,#`I*3L*(`DD<F5T=7)N
M7V%R<B`](&%R<F%Y*"D["B`)"B`)9F]R("@D:3TP.R@D:3QS:7IE;V8H)&%R
M<E]I;F1E>"DI.R1I*RLI"D!`("TQ-#$L-R`K,30Q+#<@0$`*(&9U;F-T:6]N
M(&=E=%]I;F9O*"1H;W-T;F%M92P@)'-N;7!?8V]M;75N:71Y+"`D<VYM<%]V
M97)S:6]N+"1A<F<I('L*(`EG;&]B86P@)&]I9',["B`)+R]P<FEN="`H(F=E
M=%]I;F9O(&9O<B`D87)G7&XB*3L*+0DD87)R(#T@<F5I;F1E>"AC86-T:5]S
M;FUP7W=A;&LH)&AO<W1N86UE+"`D<VYM<%]C;VUM=6YI='DL("1O:61S6R1A
M<F==+"`D<VYM<%]V97)S:6]N+"`B(BP@(B(L(#$V,2P@,3`P,"DI.PHK"21A
M<G(@/2!R96EN9&5X*&-A8W1I7W-N;7!?=V%L:R@D:&]S=&YA;64L("1S;FUP
M7V-O;6UU;FET>2P@)&]I9'-;)&%R9UTL("1S;FUP7W9E<G-I;VXL("(B+"`B
M(BP@(B(L("(B+"`B(BP@(B(L("(B+"`Q-C$L(#$P,#`I*3L*(`DO+W)E86-H
M*"1A<G(@87,@)&ME>2`]/B`D=F%L=64I('MP<FEN="`B)&ME>2`]/B`D=F%L
M=65<;B([?0H@"21R971U<FY?87)R(#T@87)R87DH*3L*(`D*0$`@+3$V,"PW
M("LQ-C`L-R!`0`H@9G5N8W1I;VX@9V5T7VEN9&5X97,H)&AO<W1N86UE+"`D
M<VYM<%]C;VUM=6YI='DL("1S;FUP7W9E<G-I;VXI('L*(`EG;&]B86P@)&]I
M9',["B`O+PEP<FEN="`H(F=E=%]I;F1E>&5S7&XB*3L*+0DD87)R(#T@<F5I
M;F1E>"AC86-T:5]S;FUP7W=A;&LH)&AO<W1N86UE+"`D<VYM<%]C;VUM=6YI
M='DL("1O:61S6R)I;F1E>")=+"`D<VYM<%]V97)S:6]N+"`B(BP@(B(L(#$V
M,2P@,3`P,"DI.PHK"21A<G(@/2!R96EN9&5X*&-A8W1I7W-N;7!?=V%L:R@D
M:&]S=&YA;64L("1S;FUP7V-O;6UU;FET>2P@)&]I9'-;(FEN9&5X(ETL("1S
M;FUP7W9E<G-I;VXL("(B+"`B(BP@(B(L("(B+"`B(BP@(B(L("(B+"`Q-C$L
M(#$P,#`I*3L*("\O"7!R:6YT(")!<G)A>3H@87)R7&XB.R!F;W)E86-H*"1A
M<G(@87,@)&ME>2`]/B`D=F%L=64I('MP<FEN="`B)&ME>2`]/B`D=F%L=65<
A;B([?0H@"21R971U<FY?87)R(#T@87)R87DH*3L*(`D*
`
end

Can't attach file

After finding this wouldn't work for me on the newer Cacti version, I did more searching to find someone took this script and updated it in another post. The link is here: http://forums.cacti.net/about26940.html&highlight=isdn

Seems to work better for me. Working out the "normal" vs. "exact number" kinks since 5.11 calls in the past 5 minutes isn't very realistic...

Mike

new version is here
http://forums.cacti.net/download.php?id=14697

01/19/2009 02:43:19 PM - SPINE: Poller[0] Host[149] DS[759] WARNING: Result from SCRIPT not valid. Partial Result: ...

Debugging the graph and datasource, everything appears ok.
This is on a 3825 with 2port T1 Wics.

Anyone have an idea, I have looked through all the forums and tried multiple things.

01/19/2009 02:43:19 PM - SPINE: Poller[0] Host[149] DS[759] WARNING: Result from SCRIPT not valid. Partial Result: ...

Debugging the graph and datasource, everything appears ok.
This is on a 3825 with 2port T1 Wics.

Anyone have an idea, I have looked through all the forums and tried multiple things.