SQL Query - find FederatedPIC conversations

One of my customers recently needed to find out how many internal users were talking to aol.com users via Lync. I wrote the script below which can be edited for any Federated\PIC domain.   This will display both users in the conversation URIs and the Session time. If you just wanted a total count you…

10

Per-User Conference joins grouped by UriType SQL Query

I recently had a request from a customer to gather conference data group by individual user. They wanted to see this data in two different formats: 1. Per-User conference join with SessionIdTime, Conference type, and ConferenceUri 2. Total Per-User Conference joins grouped by Conference type   So with the help of a colleague Tommy Mhire,…

0