Microsoft updates its Active Directory Sync tool with a small fix and a new prerequisite for .Net 4.5.1
The new build version is: 6985.0000
You can check your DirSync version by running the following PowerShell command:
The latest version can be downloaded here
Update: Please review Greig Sheridan post on the accidental release of an earlier version of the Lync CAB file.
Polycom releases UC Software 5.1.1 Revision B for VVX and SoundStructure series phones.
Polycom UC Software 5.1.1 offers support for the following endpoint platforms:
- VVX® 300/310 business media phone
- VVX® 400/410 business media phone
- VVX® 500 business media phone
- VVX® 600 business media phone
- VVX® 1500 business media phone
- Polycom® SoundStructure®
This release also provides support for the following VVX accessories:
- Polycom VVX® camera
- Polycom VVX® Expansion Module
New Features Introduce in UC Software 5.1.1 REV B (part of the Configuration File Enhancements):
- Smart Paging allows to automatically distribute all Lines, BLF’s and Speed Dials utiling the Expansion modules. The feature needs to be enabled via up.em.smartpaging.enabled=”1″ and the flexible line key configuration has priority over this feature.
- Remote Packet Capture for Logs enables to collect wireshark traces from the phone in a remote manner.
- BToE (Lync™) is now disable as a standard and requires manual activation.
- The Web Interface is now disabled if in Lync™ profile mode.
- Do not disturb / DND and/or call forward can now be deactivated via a configuration parameter.
Resolved Issues in UC Software 5.1.1 REV B:
- In Lync 2013 environment, phone now releases the bandwidth after the call hang up when using CAC (applies to VVX 300/SoundStructure).
New Features Introduce in UC Software 5.1.1:
- Added support to connect to the phone’s web user interface by choosing either HTTP or
HTTPS protocol. And the phone’s web interface is disabled by default when the base profile is set
- Added support for the single line registration and disabled all the other lines when the
phone is set to Lync as a base profile.
- Added support to forward the delegated call to the Boss voice mail.
- Added support for the full support of Lync contact card.
Resolved Issues in UC Software 5.1.1:
- The phone’s Web interface is now displayed in compatibility mode when the user tries to view it in Internet Explorer.
- In a Lync environment, the phone now updates the configuration changes without any issues when the user tries to change the existing configuration on the phone after signing in.
- In a Lync 2013 environment, the phone now displays without any issue the orbit number for Call Park when the range is set to one digit (1 to 9).
- In a Lync 2013 customer environment, the phone’s stability has been improved in heavy network load situations when the phone receives a large number of broadcast messages.
- The phone now plays remote ringback tones when Lync “media bypass” is enabled.
- The phone now records the call history without any issue after using it for longer periods
- In a BLF scenario, the phone now displays all the statically or dynamically configured BLF lines (~50) when the expansion module is connected to it and no longer causes any issue
- The soft keys on the phone now respond properly without any issue during heavy network load scenarios
- In heavy network load, the phone now receives calls without any issues when a new user signs in via PIN authentication
- BToE application backward compatibility is now available
- In a Lync federation call scenario, receiving incoming calls from the PSTN number no longer causes any issues
- Trying to call a Lync client which has sim ring configured to an external number now gets audio on both ends without any issue
- The phone now accepts the re-formatted ACK packets as per RFC 2543.
- When the phone is in the locked state, the Call List soft key is nolonger displayed on the phone screen after a reboot.
- The phone now sends the ACK to the SDP (Session Description Protocol) media change and is able to place the call successfully.
- The phone now sends a query to the alternate DNS server when the primary server rejects the initial query.
NOTE: BToE 2.3.0 can download here
In 2012, Ilse Van Criekinge published a great article on Extending your Lync monitoring data using PowerPivot and Power View. This article included a built-in Excel file that integrated into the Lync Monitoring Data database and allowed you to use Excel Power Pivot to look in into a few reporting examples made by IIse.
Following that blog article, I’d like to show you the process on how exactly you can integrate Excel and the Lync Monitoring data and a few examples of what you can do with that.
- Open Excel 2013 and enable the PowerPivot Add-in by going to File > Options > Add-Ins.
- In the Manage box, click COM Add-ins> Go.
- Check the Microsoft Office Power Pivot in Microsoft Excel 2013 box, and then click OK. If you have other versions of the Power Pivot add-in installed, these versions are also listed in the COM Add-ins list. Be sure to select the Power Pivot add-in for Excel 2013.
- On the Excel 2013 Ribbon, you should now see PowerPivot display. Click on it and choose Manage on the top left corner of the Ribbon.
- On the Power Pivot for Excel screen that opens, Click on “From Database” and choose “From SQL Server” to load the Table Import wizard which will allow us to import the monitoring data from the databases.
- In the “Table Import Wizard” screen prompt, type the Monitoring SQL Server name (No FQDN is required) and specify the Instance if there is any. If no Instances exist, type the server name only. If the name was entered correctly, you should be able to choose the Database name out of the drop down list below.
For the example below, I’ve chosen the LcsCDR database, but you can choose any type of database, or alternatively, you can import data out of the Lync Front End Servers such as RTCLOCAL or RTC databases.
- On the “Choose How to Import the Data” screen, choose “Select from a list of table and views to choose the data to import” or if you are familiar enough with SQL queries, choose the second option which will allow you query the databases with your custom queries.
- On the “Select Tables and Views” screen, select the tables you want to query or run the PivotTable/PivotCharts against it. For the examples below, I’ve chosen the following tables:
- You can also choose “Select Related Tables” if you want to let the Excel determine the associated tables based on the relationship configured in the SQL databases. Once you’ve selected the tables, click the Finish button to start importing the data.
- Once the import is done, the “PowerPivot for Excel” screen will show up and will display all the data imported from the Monitoring databases based on the tables selection.
- In order to perform analysis on the imported data, click the “PivotTable” button and select the type of pivot. In my examples I chose PivotTable and PivotChart.
- Once you’ve selected the PowerPivot option, on the right side of the screen you will be able to choose the Rows and Columns out of the existing tables being imported and also provide with some values and choose different filters for views. More on how to use PivotTable and PivotCharts here.
I decided to share 2 examples of usage with data imported from the LcsCDR database, but bear in mind that it’s up to you to decide how you’re going to use it and the options are almost unlimited.
Example #1 – Top 10 PSTN Numbers called from Lync Users
- In order to demonstrate this example, choose the following information:
- ROWS – [VoIP Details View].[ToPhone]
- FILTERS – [VoIP Details View].[ToUriType] and choose PhoneURI as the filter value in order to count only PSTN numbers as destinations.
- VALUES – Count of [VoIP Details View].[ToPhone]
- Once you’ve selected the following, you can see on the left side of the screen that the PivotTable is changing accordingly.
- In order to select the top 10 and also sort by the Count column, click on the Row Label sort button and choose Value Filters > Top 10
- In the Filter screen choose the top 10 out of the “Count of to Phone”:
- For sorting, choose “More Sort Options” and choose Descending “Count of ToPhone”:
- The result should be similar to that:
- Another great options, is also adding some Data Slicers, those can be helpful, for instance adding timeline slicer to filter the amount on calls per Months/Quarters/Years. To do so, choose the PivotTables Analyze Ribbon and select Insert Timeline:
- On the Insert Timeline screen, select the “SessionIdTime” and click OK:
- Once selected, the following Timeline filter will show up on the screen and will allow you to filter the amount of calls per date:
Please note that you can choose the same details and use PivotChart and play with the other column to display Source number instead of destination numbers and every other scenario you can think of.
Example #2 – Getting Last Logon Time for Users
The other example, is based upon a recent script that was released allowing you find Lync Orphaned users.
- Open the PowerPivot Screen and Select new PivotTable on a new Worksheet.
- Select the following:
- Insert Timeline and select “LastLoginDate”:
- One the screen that appears, filter with the Timeline slicer to display Years/Quarters/Days in order to show the results requested.
- The result should be similar to that:
For more great examples, please check this Blog and download the Excel files which include more samples for usage:
Recently Yoav Barzilay and I upgraded our script for Getting the Last Login time for a user sign in into a Lync pool and it’s client type. we’ve added a new functionality to include the actual server the user is sign-in into within an enterprise pool and its backup servers based on the Get-CsUserPoolInfo cmdlet.
One of the feedbacks we got was that another interesting thing would be to see Users which did not sign-in the last couple of days, or in matter affect seeing all users which not being signed in for a long time – Orphaned Users.
Starting to explore this options, our main problem showing those orphaned users was that the Lync servers does not includes any kind of information as they only holds recent data in the RtcDyn database (last couple of days).
Our assumption was that this kind of data may only resides within the Lync Monitoring databases under the LcsCDR database.
So we’ve decided to play a bit with the LcsCDR databases and see where we can get this information from. Fortunately we found two tables which seems to be relevant:
looking on those tables we could see that they holds interesting information such as the User LastLoginTime (Under UserStatistics) and also the UserURI (Under Users) in addition to other interesting information such as the last time a user originated a Conference etc.
Combining the two tables and creating the following SQL Query allowed us to display the information we wanted:
SELECT UserStatistics.UserId,UserUri,LastLogInTime,LastConfOrganizedTime, LastConfOrganizerCallFailureTime FROM [LcsCDR].[dbo].[UserStatistics] INNER JOIN [LcsCDR].[dbo].[Users] ON [LcsCDR].[dbo].[Users].UserId = [LcsCDR].[dbo].[UserStatistics].UserId WHERE LastLogInTime IS NOT NULL ORDER BY [LcsCDR].[dbo].[UserStatistics].LastLogInTime desc
The next step was using that query and put into a PowerShell script which will be easy to use and also will allow users to get all the information they wanted in one place.
The following script is the outcome of our work which will result in the following:
1) Choosing an Output Selection: CSV, GridView or output Screen
2) Getting the monitoring servers out of the Lync topology, Query the Instances on that servers and perform the SQL query against it. the script also allow you to choose the number of days since the last logon of users you want to see.
3) Displaying the output of the query based on the users selection:
- UserUri – The User Sign In Address (SIP address)
- LastLogInTime – The Last login Time appeared on the database
- Days Since Last Login – A calculation column which takes the user input and diff the last login date
- LastConfOrganizedTime – Last time the user organized Conference call
- LastCallFailureTime – Last time the user has failure in making call
Download the script Here
We would like to hear your feedback.
Just updated the “List the last time a User registered on a Lync pool and its client type” script to version 0.5 (5-July-2014).
New functionally added to the script based on users feedback:
- Check if the User is running under Administrator elevation privileges
- The output also includes results from the Get-CsUserPoolInfo cmdlet, meaning that you can now see when the user last logged in and also see what his primary main server is and what his backup servers are. that can be very helpful in cases where you want to verify who is connected to a specific server within a pool for cases such as maintenance, troubleshooting etc.
- Added support for catching SQL Exceptions on specific servers
- Added additional validation tests
Download the new version Here