(Simple) list content of BLF labels for a DN. Nice and simple/short command to show what is out there:![]() Output will look something like this: label labelascii =========== =========== Mike Gibson Mike Gibson Mr Gibson Mr Gibson Mike G. Mike G. test test Gibson Gibson Mike Gibson Mike Gibson |
List content of BLF labels, index of labels, and description of the devices they belong on.![]() Output will look something like this: blfdestination label labelascii blfindex name description ============== =========== =========== ======== =============== =============== 81234 Mike Gibson Mike Gibson 7 SEP68BC044143D3 80200 - Telecom 81234 Mr Gibson Mr Gibson 3 SEP64A5055E7682 82345 - Telecom 81234 Mike G. Mike G. 3 SEP30435516F77D 82392 - Telecom 81234 test test 4 SEP142439455B59 86014 - Telecom 81234 Gibson Gibson 20 SEP61A2E3146506 88443 - Telecom 81234 Mike Gibson Mike Gibson 18 SEP0012203B4E35 88730 - Telecom |
List content of BLF labels for a device they belong on. List by device and order of index. run sql select blf.blfdestination,blf.label,blf.labelascii,blf.blfindex,d.name,d.description from device d,blfspeeddial blf where d.description like '81234%' and blf.fkdevice=d.pkid order by d.name,blf.blfindex Output will look something like this: blfdestination label labelascii blfindex name description ============== =========== =========== ======== =============== =============== 82345 Dan T Dan T 1 SEP00255E173F3C 81234 - Telecom 83456 Brian G Brian G 2 SEP00255E173F3C 81234 - Telecom 84567 Danny E Danny E 3 SEP00255E173F3C 81234 - Telecom 85678 Jane D Jane D 4 SEP00255E173F3C 81234 - Telecom 86789 Anne M Anne M 5 SEP00255E173F3C 81234 - Telecom |