[cisco-voip] Informix SQL Query to pull some configuration information

[Bernhard Albler]

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