| Mladen Milanovic 2007-12-29, 1:11 pm |
| Bernard,
thans a lot. You helped me a lot.
Mladen
-----Original Message-----
From: Bernhard Albler [mailto:balbler@nts.at]
Sent: Saturday, December 29, 2007 2:53 AM
To: Mladen Milanovic; cisco-voip@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
|