Generating a list of OC users with a "specified" number of contacts

  • Article

The list is required for OCS Admins to see how many OC users are max'ing out on the number of contacts they have added.

The following SQL query helps in generating that list.

SELECT     rtc.dbo.Contact.OwnerId, rtc.dbo.Resource.UserAtHost AS "SIP Name"
FROM         rtc.dbo.Contact
INNER JOIN rtc.dbo.Resource ON rtc.dbo.Contact.OwnerId=rtc.dbo.Resource.ResourceId
GROUP BY rtc.dbo.Contact.OwnerId, rtc.dbo.Resource.UserAtHost
HAVING      (COUNT(rtc.dbo.Contact.OwnerId) >= 2)

The output looks like below. You can customize the script to add mroe columns.