| Bernhard Albler 2007-12-29, 7:11 am |
| 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
|