Search Engine: Elastic

Article ID: 113345, created on Feb 22, 2012, last review on May 4, 2014

  • Applies to:
  • Operations Automation 5.4


I need to have the ability to get information about the assignments of phone numbers.


First, you need to obtain an application instance ID:
Application ID

When you have all the required information, you can go to the provisioning host (the host where the Lync Phone Numbers application was installed).

1. On the provisioning host, go to: C:\Program Files (x86)\SWsoft\PEM\APS\instances\<Application Instance ID>\scripts\service.
2. Open the Web.config file.
3. Copy the connection string. For example: "Data Source =&quot;C:\DBs\LPN\pnms_wc60386.sdf&quot;; Password =&quot;<Database password>&quot;;"

Note: <Database password> can be found on the Settings page of the Lync Phone Numbers application (Lync Phone Numbers -> Configuration -> Settings).

How to connect to the database file:
If you have SQL Server Management Studio installed, just create a new connection.

You may also download sqlcecmd (a command line tool) from

Command line query:
sqlcecmd -d "Data Source =C:\DBs\LPN\pnms_wc60386.sdf; Password=<Database password>;" -q "SELECT owner_id from assigned_phone_number where number='<phone number>'"

SQL Server Management Studio query:
SELECT owner_id from assigned_phone_number where number='<phone number>'

<phone number> is the number without any additional characters. For example, if a phone number is +1(200)900-90-90, this value should be 12009009090.


ac82ce33439a9c1feec4ff4f2f638899 5356b422f65bdad1c3e9edca5d74a1ae 2554725ed606193dd9bbce21365bed4e caea8340e2d186a540518d08602aa065 e12cea1d47a3125d335d68e6d4e15e07

Email subscription for changes to this article
Save as PDF