How to query the "Display (Internal Caller ID)" field ?

[Sandy Lee]

Hi,

I've just noticed that some phones were inserted in the CCM with the value of the "Display (Internal Caller ID)" field EMPTY, i.e. the person who's in charge of doing this made a mistake. Instead of putting the value in this field, it was put in the "Alerting name" field. Is there a way to query the CCM to know exactly which lines have the "Display (Internal Caller ID)" field = EMPTY ?

Thanks!

[gogasca]

Table is DeviceNumPlanMap and field is Display

This will contain Display value...

How to know which line contain it?

Under DeviceNumPlanMap there is fkNumPlan

which contains the association to NumPlan table, this table will contain the DN that is using this field. (DNorPattern)

For example you look into NumPlan.

Look for DNorPattern 2001 . In this row you will also have pkid (NumPlan.pkid), this value will contain the association with

DeviceNumPlanMap and the field is fkNumPlan-

Let me know if this answer your question.