A Dutch UC professional (Frederik Lefevre) has written a couple of blog entries on how to get the Response Group showing queue information… Source: http://www.ucprofessional.com/2011/01/response-group-queue-monitoring.html. However, he has it covered in multiple entries, with updates on multiple locations, therefore I’m putting it into a single blog entry for you all to use.
This article provides the complete picture on how to create the parts that are in the database and the webservices …
- On the database server create a database called ‘gngacd’.
- Create a Security login which matches your webservername (e.g. DOMAINNAME\COMPUTERNAME$)
- Provide that account Sysadmin rights with dbo rights on the GNGACD, RGSCONFIG, RGSDYN, TEMPDB databases.
- Create or update the function using Create or Update script using the SQL Server Management Studio, select the database (GNGACD), right click New Query:
- Copy and past the Create or Update script content in the query field and press execute. This creates or updates the required function.
2nd part is the webserver part. The webserver provides the interface of the requested queue… You can either select a current or create a new webserver with the following IIS parts configured (run these commands in a Administrative Powershell):
On the webserver, create directories for any Response Group of which you want to provide the Queue information. The picture below provides an example on a couple of Repsonse Groups.
Download this file RGSQueueMonv1.zip and export it to a temporary directory. It contains the following files:
If you are into custom coding you can change the background, layout and all… For now, I’ll leave it out of scope. The most important file is the web.config.
<add name="[YOUR CONNECTION STRING NAME]" connectionString="Data Source=[YOUR SQL SERVER NAME];Initial Catalog=[YOUR DB NAME];Integrated Security=True" providerName="System.Data.SqlClient" />
Please replace the following parts:
[YOUR CONNECTION STRING NAME] –> gngacdConnectionString
[YOUR SQL SERVER NAME] –> Your SQL database
[YOUR DB NAME] –> Your SQL Database (e.g. gngacd)
Please modify the lines to your needs. you can do this using a search and replace method or look for the lines yourself. The example below provides a Helpdesk queue. Make sure the Q.Name and Q.[Name] are unique and match your Queue names in the Lync Control Panel as shown below:
<title>Lync Server 2010 RSG Status – Helpdesk</title>
Where Q.Name Like ‘Helpdesk%’">
Where Q.[Name] Like ‘Helpdesk%’">
<td class="RSGstatus">Response Group Status: <BR><B>Helpdesk</B></TD>
Once you are done modifying this,copy it to a directory which you’ve created at the start of #3.
On the IIS server, start the IIS Manager and create Virtual Directories as shown below:
By now, you should be finished and able to view the website. Have fun and if you have any questions, please contact me.