In Skype 4 Business (Lync Server as some still call it) there is the option of operating response groups formally or informally. Response groups in general are queues that can represent more or less complex telephone exchanges.
- Formal groups are groups in which you have to register manually before calls can be accepted.
- Informelle Gruppen sind Gruppen, bei denen man automatisch angemeldet wird, wenn sobald man an einem beliebigen Client angemeldet ist. Das Kontrollkästchen „Angemeldet“ bei diesen Gruppen kann nicht deaktiviert werden.
Wenn man Skype4Business Gruppen „formell“ betreibt, dann wäre es oft gut zu wissen, welche User an-, bzw. abgemeldet sind. Das kann man ja einfach per SQL-Statement auf der Datenbank abfragen, wie ich here on the net have found. However, it is not really practical for the helpdesk to always do this via the SQL Management Studio if necessary. I wanted to make this available on a web platform and simply created a small example with php. I don't want to display all reaction groups on the dashboard, as they belong to different departments and not everyone is allowed to see them for data protection reasons. However, I have added a unique identifier to the description so that I don't always have to adjust the script manually.
I then took the SQL statement from the link above and added the Discription column, which I can now filter on:
First I need a db.inc.php in which the database connection is defined. This file will be included later in the main file
<!--?php defined ( 'DB_HOST' ) ? null : define ( 'DB_HOST', 'S4BSERVER\RTC' ); defined ( 'DB_USER' ) ? null : define ( 'DB_USER', 'yourUser' ); defined ( 'DB_PASS' ) ? null : define ( 'DB_PASS', 'yourPassword' ); defined ( 'DB_NAME' ) ? null : define ( 'DB_NAME', 'rgsconfig' ); require_once('../class.mssql.php'); $db = new mssqldb(); $db->connect(); ?-->
I then load db.inc.php into Index.php and use the previously tested SQL select to retrieve all the information. This information is then output. To embellish this, I have added an image to the status so that you can immediately see who is now active in a reaction group.
<!--?php date_default_timezone_set('Europe/Vienna'); ####################### Load Database Class ################## require_once('db.inc.php'); $status = $db->select("select T1.Name, T1.Description, T3.DisplayName, T4.[State] from [rgsconfig].dbo.AgentGroups as T1 join rgsconfig.dbo.AgentGroupsToAgentsMap as T2 on T1.ID = T2.AgentGroupId join rgsconfig.dbo.Agents as T3 on T2.AgentId = T3.ID left join rgsdyn.dbo.AgentGroupSignInStates as T4 on (T2.AgentGroupId = T4.GroupId and T2.AgentId = T4.AgentId) where T4.[State] in (0,1) and T1.Description like 'Test' group by T1.Name,T1.ID,T1.Description,T3.DisplayName,T3.ID,T4.[State];"); for($i=0;$i<count($status);$i++){ $exit = $status[$i]["Name"]; $old = $status[$i -1]["Name"]; ##### Status 1 = Online, Status 2 = Offline ##### if($status[$i]["State"] == "1"){ $state = "<img src="online.png">"; } elseif ($status[$i]["State"] == "0"){ $state = "<img src="offline.png">"; } if($exit != $old){ print "<strong><u>".utf8_encode($status[$i]["Name"]).":</u></strong><br>"; } print "&nbsp;&nbsp;".$state."&nbsp;".utf8_encode($status[$i]["DisplayName"])."<br>"; } ?-->
The result looks like this:
Natürlich kann das ganze auch jederzeit visuell angepasst werden. Mit reicht es allerdings, da es „nur“ im Helpdesk Dashboard eingebunden wird.