[cisco-voip] Informix SQL Query to pull some configurationinformation

[Mladen Milanovic]

Bernard,
thans a lot. You helped me a lot.

Mladen 

-----Original Message-----
From: Bernhard Albler [mailto:balbler at nts.at] 
Sent: Saturday, December 29, 2007 2:53 AM
To: Mladen Milanovic; cisco-voip at puck.nether.net
Subject: AW: [cisco-voip] Informix SQL Query to pull some
configurationinformation

Mladen,

the following query might give you what you want. run ist via "run sql"
on the cli:

select d.name,d.description,np.dnorpattern,np.description from device
d,busylampfield blf,numplan np where d.pkid=blf.fkdevice and
blf.fknumplan=np.pkid order by d.pkid,blfindex

gives you something along these lines:
name            description                        dnorpattern
description
=============== ================================== ===========
=================================
SEP001DA290A3C1 OFCD - RID: 98137856               68000
OFCD_68000
SEP001DA290A3C1 OFCD - RID: 98137856               68001
OFCD_68001
SEP001DA290A3C1 OFCD - RID: 98137856               68002
OFCD_68002
SEP001DA290A3C1 OFCD - RID: 98137856               68004
OFCD_68004
SEP001DA290A3C1 OFCD - RID: 98137856               68005
OFCD_68005
SEP001DA290A3C1 OFCD - RID: 98137856               66001       OFCC FLZ
Slot Desk_OFCC_FLZ_66001
SEP001DA290A3C1 OFCD - RID: 98137856               66000       OFCC FLZ
Airbus_OFCC_FLZ_66000
SEP001DA290A3C1 OFCD - RID: 98137856               68291
OFCD_Schnurlos_68291

There is also a label field on the busylampfield table, if you that is
more meaningful than the description of the dn that is monitored.

regards
bernhard