×

Warning message

  • Cisco Support Forums is in Read Only mode while the site is being migrated.
  • Cisco Support Forums is in Read Only mode while the site is being migrated.

sql request...

Unanswered Question
Jan 28th, 2003
User Badges:

Story short, I need to actually list the pickup lines numbers with the associated directory number.


Does someone knows what SQL query I could use to see this kind of information?


Thanks Alex.

  • 1
  • 2
  • 3
  • 4
  • 5
Overall Rating: 0 (0 ratings)
Loading.
s-doyle Mon, 02/03/2003 - 11:35
User Badges:

You can try out something similar to this.


select dNOrPattern from numplan where ikNumPlan_CallPickupGroup in (select pkid from numplan where dnorpattern = xxxx)


Note: xxxx is the directory number.


Actions

This Discussion