Tuesday, 17 September 2013

Accessing Call Log History on Siemens OpenScape Telephone System

Objective: Accessing Telephone Call history on the Siemens OpenScape Office Telephone System
Below is a method that you should be able to use to extract telephone call history (both incoming and outgoing) from the Siemens OpenScape Office Telephone System. There is a tool called myReports that can be used to extract more detailed call information, but in my case, access to this tool was not available to me due to not having the relevant licensed modules on our telephone system.

My Environment
Telephone System: Siemens OpenScape Office
Version: OSO_V3_R3.6.0_007
Client PC: Windows 7 64Bit
Required Information (my environment details [not real!])
Telephone Server IP: 192.168.1.50
Telephone Server Username: MYUSERNAME@system
Telephone Server Password: MYPASSWORD

Method 1 - Call log information via Telephone Server URL
After trying to un-successfully run the Siemens myReports Software, a few Google searches later, I came across a PDF download from the Siemens Wiki Site (OpenScape Office V3 - Call Detailed Recording & Call Data Record Structure 2012-07-24) which referenced accessing the servlet available on the telephone system to retrieve call log information. Page 7 of this document indicated that a specially crafted URL containing a valid HTTP interface log in username and password within the parameters would allow access to call log information.

I tried this URL adjusting it to my environment and managed to get all our outgoing call information using:-

https://192.168.1.50/management/portlet/?portlet=hipathaccountingdownload::HiPathAccountingDownloadPortlet&entity=accounting&action=get&username=MYUSERNAME@system&password=MYPASSWORD

I could then see the following outgoing (info on how to change this is below...) call information in my web browser


It looks like there is some scope to run some automated script with a get command to download this call log info to a pipe-delimited text file for further analysis if desired.

Method 2 - Call log information via Siemens Accounting Manager Tool
Within the Siemens OpenScape Server, there is a Microsoft Windows MSI based tool called Siemens Accounting Manager that can be configured to retrieve call log information from the telephone server. The tool can be installed by logging into the HTTP/S interface of the telephone server (https://192.168.1.50/) and browsing to the Service Center section, it is listed under the Software section as Call Charge Manager.


The download URL should be something like https://192.168.1.50/management/downloads/AccountingManager.zip
Once downloaded, unzip the files and run Accounting Manager.msi to start the install process.

Once installed you will need to open the application from the Start Menu and then configure the connection settings under the drop down menu of Settings > Connection
 Enter your Telephone Server's IP address, Port, Username and password.

Once entered, you may be prompted to restart the application. You will then need to get the application to download the call information from the telephone server using the drop down menu PBX > Retrieve Data option. Depending on how much data is in your telephone system and you network etc, this can take a while. (For me, it took around 10 minutes). I suspect application pulls this information using the servlet method described above in Method 1 as you specify the server IP, port, username and password.

My retrieve process seemed to hang at 99% even after leaving it to the next day so I had to run an CTRL+ ALT+DEL > Task Manager > End Task on the Application. Once restarted however, it seemed to function as intended with the data it downloaded on the first attempt being being displayed.


Once the data has been retrieved, you will need to configure the Filters to specify the date period and call types you wish to display. You can do this under CDR > Set Filters.




What about Incoming Call Data?
In our environment, the Telephone Server had not been configured to record incoming call statistics. I suspect that this was a default configuration to keep the telephone server's database quite lean therefore, snappy. To show incoming call statistics, I enabled incoming call logging under the HTTP interface of the telephone system found under Expert Mode > Telephony Server > Basic Settings > Call Charges > Check 'Log Incoming Calls'. Incoming calls after setting this option are then recorded by the server, however, this is basic call information (telephone number, date, duration) as call routing after hitting the systems attendant menu is not available unless the relevant add on module required for myReports is purchased.







8 comments:

  1. This comment has been removed by a blog administrator.

    ReplyDelete
  2. This comment has been removed by a blog administrator.

    ReplyDelete
  3. This comment has been removed by a blog administrator.

    ReplyDelete
  4. This comment has been removed by a blog administrator.

    ReplyDelete
  5. Its a great pleasure reading your post.Its full of information I am looking for and I love to post a comment that "The content of your post is awesome" Great work. 0800 business lines

    ReplyDelete
  6. The best and fastest way to convert your big data into a summarized or graphical form is to give this work to the data scientists who are expert in this type of work and they specially made for data handling. This data scientist team can be reached you easily by just visiting this activewizards.com/.

    ReplyDelete
  7. The business telephone framework permits this; it enhances consumer loyalty and makes him or her prescribe the business to dear loved ones, accordingly profiting the business. how expensive is a 0800 line?

    ReplyDelete
  8. 0800 is the most popular and most advance toll free number in the whole world.0800

    ReplyDelete