Monthly Archives: April 2014

You are browsing the site archives by month.

Building Sonus Transformation Tables…fast…very fast!!!

If you have been using Sonus Session Border Controllers (Sonus SBC’s 1000/2000) for any amount of time you probably are well aware about the amount of time transformation table entries can consume. Anywhere from few minutes for couple of transformation table entries to few hours or even days if you have got couple of 100 to create. If  you have got 100’s of these transformation table entries to be copied across multiple SBC’s…well you are in for some serious fun!

Needless to say adding creating 100’s of transformation table entries manually via GUI is tedious, error prone and highly inefficient. It certainly doesn’t seem to be sort of thing you should be wasting your or your customers time in this day and age of automation, efficiency & cost cutting!

To take the pain out of building transformation table entries I have created an Excel spreadsheet – SonusSBCTransformationTableBuilder. It allows you to build Transformation table entries offline – anywhere, without access to the SBC.

Read More →

Lync Insights – Answering the burning questions – Part1!

This is a multi-part blog series. This is Part 1.For other blog posts in this series please click the relevant links – Part 2.

After completing the Lync deployment don’t you in the back of your mind think I  wish I knew how Lync is being used, who is having issues, who is not using it, etc ? In fact, the burning questions, perhaps questions like these:

  • To which PSTN number highest number of phone calls are made
  • Who is on the phone for the longest duration (and who the least!)
  • When was the last time someone logged on to Lync
  • Find all the calls which are over certain thresholds e.g. over 10% packet loss, over 3ms Jitter, etc
  • Generate alerts when your boss makes a call and the call is not good quality e.g. Over 10% packet loss, over 30ms Jitter, etc
  • Find who is doing the most number of file transfers in your organization?
  • Find who is transferring what file and to whom?

Standard Lync Monitoring reports provides you with great information on several elements of Lync usage and health.But Lync Monitoring reports only scratches the surface of what information is actually available in Lync Monitoring database. Lync Monitoring database is a goldmine of information – unfortunately in spite of Microsoft publishing the database schemas I have barely seen anyone querying database directly.

In order to attempt to make the Lync monitoring databases more accessible and answer the above burning questions and I have created a Lync Insights PowerShell module. My idea is to include in Lync Insights all kinds of different SQL queries I use on day to day basis for various customers and share with ever growing passionate Lync community!

Read More →