Exploring Default Installation and SQL Paths in Lync Server 2013

http://howdouc.blogspot.com/2012/11/exploring-default-installation-and-sql.html

SfB Topology Builder – Select Database File Location

http://silbers.net/sfb-topology-builder-select-database-file-location/

How to Install Lync SQL Express to a Non-System Drive

https://guybachar.net/2014/03/29/how-to-install-lync-sql-express-to-a-non-system-drive/

Script: Set-Cs2013Features.ps1 – Easily Install Prerequisites and Tools for Microsoft Lync Server 2013

https://www.ucunleashed.com/1697

Lync Server 2013: Using the DatabasePathMap Parameter to Deploy Databases

https://blogs.technet.microsoft.com/nexthop/2012/11/20/lync-server-2013-using-the-databasepathmap-parameter-to-deploy-databases/

Stats Man and KHI released for Skype for Business Server 2019

Setup Step-by-Step For Real-Time Stats Manager

https://blogs.technet.microsoft.com/dodeitte/2015/10/24/skype-for-business-server-real-time-statistics-manager/

https://blogs.technet.microsoft.com/dodeitte/2016/04/25/skype-for-business-server-real-time-statistics-manager-1-1-available/

Skype for Business Server 실시간 통계 관리자에 대한 업데이트를 사용할 수 있습니다. 릴리스 1.1에서 다음과 같은 알려진 문제점이 수정되었습니다.

• UI / 서버 / 에이전트 - 신뢰성 및 성능 향상

• UI - 기본 필터 제어가 이제 다른 경우와 정확하게 정렬됩니다 (사람들이 특정 서버가 시스템에 없을 때 시스템에 있다고 생각하게 만들었습니다)

• 서버 - 이제 서버 구성 요소가 영어가 아닌 서버에 설치됩니다.

• 서버 / 에이전트 - 특정 버전의 .NET 4.0 때문에 에이전트 및 서버 구성 요소가 .NET 오류로 설치되지 않는 경우가 있습니다. 이 문제가 해결되었습니다.

• 에이전트 - Statsman 에이전트에 확장 이벤트 로깅이 추가되었습니다. 토폴로지가 아닌 서버에 에이전트를 설치하면 더 이상 크래시가 발생하지 않으며 가능한 다른 많은 오류 조건과 함께 이벤트 로그에 기록됩니다.

• UI - Chrome 브라우저를 사용하는 웹 클라이언트는 Statistics Manager 웹 서버와 동일한 작업 그룹 또는 도메인에 가입되지 않은 클라이언트 컴퓨터를 사용할 때 여러 로그인 프롬프트를 보게됩니다. 이제 세션 당 하나의 로그인 만 필요합니다.

Introduction

Managing address book in Lync\SFB environment, in itself, is a task. Lync\SFB admins keep on getting address book related issues in the environment.

• Users may notice duplicate contacts in address book search
• User may notice old contact details (name, phone number, title etc).
• Users see contacts deleted in Active Directory (resigned cases)
• Users may not be able to search address book.
• Users may experience “Cannot Synchronize Address Book” error as below.

"This article focusses on steps to resolve address book issues."

Re-Create the Address Book (Server)

This section of the article explains the process to re-create address book files at server end. Navigate following folder and delete the contents (existing address book files).

Forces the back-end user database to clear its replication status with Active Directory. This causes the database to re-read all the user-related information stored in Active Directory Domain Services.

Now, run following command on the Front End server;

Update-CsAddressBook

Forces the specified Address Book servers to synchronize their contents with the User database.

Wait for some time (5-10 mins, may be longer), and navigate to following location. You should see the files being recreated.

Check Address Book URLs

As a next step, make sure that you can browse to the following URLs.

As an internal client;

As an external client;

Test Address Book Service

Run following commands to check errors. You should be fine if it doesn’t return configuration related erros.

Test-CsAddressBookService

Test-CsAddressBookWebQuery

AddressBookAvailability Setting in Client Policy

You have option to select how a user should search a contact. There is a setting, AddressBookAvailability, in Lync\SFB client policy for this. By default, the policy is set to allow address book download and web search (by typing SIP URI of a contact).

Run following command to check address book setting.

Get-CsClientPolicy | Select-Object Identity,AddressBookAvailability | ft

There are currently three available settings for this parameter; WebSearchAndFileDownload,WebSearchOnly, and FileDownloadOnly. Define it as per your organization’s requirement.

WebSearchOnly is realtime and address book file content could be 24 hrs old. You need to type full SIP URI for web search. Contact searching is user friendly if address book file downloaded.

Re-Create the Address Book (Client)

Now, re-create address book file, after performing above steps. First, delete local SIP profile of the users.

If user is running Skype For Business 2016

• Log off of the Lync client and delete the profile from:
• %userprofile%\appdata\Local\Microsoft\Office\15.0\Lync
• Delete following registry key.
• HKCU\Software\Microsoft\Office\16.0\Lync\sip@Domain.com

If user is running Lync 2013\Skype For Business 2015

• Log off of the Lync client and delete the profile from:
• %userprofile%\appdata\Local\Microsoft\Office\15.0\Lync
• Delete following registry key.
• HKCU\Software\Microsoft\Office\15.0\Lync\sip@Domain.com

If user is running Lync 2010

• Log off of the Lync client and delete the profile from:
• %userprofile%\AppData\Local\Microsoft\Communicator
• Delete following registry key.
• HKLM\Software\Policies\Microsoft\Communicator\sip@Domain.com

Download Address Book Immediately

In some cases, Lync\SFB users may face delay (upto 60 minutes) in address book download. Create this registry key to download address book immediately.

Run following command if user is running Skype For Business 2016

• reg add HKLM\Software\Policies\Microsoft\Office\16.0\Lync /v GalDownloadInitialDelay /t REG_DWORD /d 0 /f

Run following command if user is running Lync 2013\Skype For Business 2015

• reg add HKLM\Software\Policies\Microsoft\Office\15.0\Lync /v GalDownloadInitialDelay /t REG_DWORD /d 0 /f

Run following command if user is running Lync 2010

• reg add HKLM\Software\Policies\Microsoft\Communicator /v GalDownloadInitialDelay /t REG_DWORD /d 0 /f

Lync 오디오 품질 메트릭 입문서

1. 특정 Front-End 서버의 사용자만 찾고자 하는경우

Get-CsUser | Get-CsUserPoolInfo | Where-Object {$_.PrimaryPoolPrimaryRegistrar -eq "fe01.mani4u.com"} | ft identity, PrimaryPoolPrimaryRegistrar

2. 특정 Front-End 서버의 특정 사용자만 찾고자 하는경우

Get-CsUser -Filter {DisplayName -Like "*TEST*"} | Get-CsUserPoolInfo | Where-Object {$_.PrimaryPoolPrimaryRegistrar -eq "fe01.mani4u.com"} | ft identity, PrimaryPoolPrimaryRegistrar

결과값

Identity                                PrimaryPoolPrimaryRegistrar
--------                                ---------------------------
1000002@mani4u.com                     fe01.mani4u.com
1000010@mani4u.com                     fe01.mani4u.com
1000013@mani4u.com                     fe01.mani4u.com
1000014@mani4u.com                     fe01.mani4u.com
1000016@mani4u.com                     fe01.mani4u.com
1000019@mani4u.com                     fe01.mani4u.com
1000021@mani4u.com                     fe01.mani4u.com
1000024@mani4u.com                     fe01.mani4u.com

Phone Number Normalization Rule Regular Expressions

Phone Number Normalization Rule Regular Expressions

A question that comes up from customers from time to time is how do I get a list of what users are actually using OCS/Lync?  While there’s no built in report to easily tell you what users are actually signing into the environment, there is some information stored in SQL that you can use to help figure out adoption rate in your environment.  The information we’re looking for is stored in the LastNewRegisterTime column in the HomedResourceDynamic table in the rtcdyn database.  You can run the following queries* to pull back the user’s SIP URI and their last registration time:

For Lync Server 2010/2013

USE rtcdyn
SELECT rtc.dbo.Resource.UserAtHost, rtcdyn.dbo.HomedResourceDynamic.LastNewRegisterTime
FROM rtcdyn.dbo.HomedResourceDynamic
INNER JOIN rtc.dbo.Resource on rtc.dbo.Resource.ResourceId = rtcdyn.dbo.HomedResourceDynamic.OwnerId
INNER JOIN rtcdyn.dbo.RegistrarEndpoint ON rtcdyn.dbo.RegistrarEndpoint.OwnerId = rtcdyn.dbo.HomedResourceDynamic.OwnerId
WHERE IsServerSource = 0
ORDER BY UserAtHost

Which produces the following output:

For OCS 2007 R2

USE rtcdyn
SELECT rtc.dbo.Resource.UserAtHost, rtcdyn.dbo.HomedResourceDynamic.LastNewRegisterTime
FROM rtcdyn.dbo.HomedResourceDynamic
INNER JOIN rtc.dbo.Resource ON rtc.dbo.Resource.ResourceId = rtcdyn.dbo.HomedResourceDynamic.OwnerId
ORDER BY UserAtHost

Which produces the following output:

Note: A user with a LastNewRegisterTime of NULL is a user that has never logged in, but has been added to someone’s contact list.  You would want to remove these entries from your exported results.

While the query to gather the information is very similar the SQL instance that you connect to to retrieve this information is different depending on which version you’re using.  In OCS 2007 R2 all of this information was stored in the rtcdyn database on the SQL instance that you defined when first creating the pool.  Because of the changes to the registrar functionality in Lync Server 2010 to support survivability, the information that we’re looking for has moved to the RTCLOCAL SQL instance that is stored on each registrar.

You can see this if you compare the HomedResourceDynamic table in the rtcdyn database between the Front End Pool SQL Instance and one of the Front End Server’s RTCLOCAL SQL Instance:

Front End Pool SQL Instance

RTCLOCAL SQL Instance

For row 2, OwnerId 12 corresponds to my Lync test user that has logged into the client.  You can see that the information that we’re looking for, LastNewRegisterTime, only gets populated in the RTCLOCAL SQL instance on the Front End Server.  So this means that in Lync Server 2010 you don’t have one place you can go for all of the users homed on that pool.  You will need to run the query and aggregate the data from every registrar in the pool, as well as any SBA/SBS deployed.  The other issue that comes up in an Enterprise Edition pool with multiple Front End Servers is that when users fail-over to another Front End Server in the pool, there is a record created in that Front End Server’s RTCLOCAL rtcdyn database.  After you run the queries and have exported all of the results you would want to clean up the duplicate entries so that you weren’t reporting inflated numbers.

Even though there’s a little work involved in gathering the information this is a fairly easy way to gauge adoption and see which of your users are actually using the OCS/Lync.

Using the Lync Server 2013 Monitoring Server

If you have the Monitoring Server role configured in your environment, and for Lync Server 2013 everyone should!, you can use information contained in the LcsCDR database to pull back the last time a user signed in.  You can run the following query* to pull back the user’s SIP URI and their last login time:

USE LcsCDR
SELECT dbo.Users.UserUri, dbo.UserStatistics.LastLogInTime
FROM dbo.UserStatistics
JOIN dbo.Users ON dbo.Users.UserId = dbo.UserStatistics.UserId
ORDER BY UserUri

Which produces the following output:

The advantage to using the Monitoring Server to obtain this data is that unlike the information contained in the rtcdyn database, the information from the LcsCDR data will persist even when the user isn’t signed into Lync.

*These queries are provided for you to use at your own risk.  Please make sure you test before running in a production environment.

use rtc

declare @sipQuery nvarchar(250)

set @sipQuery = 'test1@contoso.com'

select FE.Fqdn,R.UserAtHost, * from FrontEnd FE

join RoutingGroupAssignment RGA

On FE.FrontEndId = RGA.FrontEndId

join ResourceDirectory RD

on RGA.RoutingGroupId = RD.RoutingGroupId

join Resource R

on RD.ResourceId = R.ResourceId

where R.UserAtHost = @sipQuery

참고

https://msdn.microsoft.com/en-us/library/bb878933.aspx

http://mikestacy.typepad.com/mike-stacys-blog/2009/08/are-you-really-away.htmlㄴ

use rtc

declare @sipQuery nvarchar(250)
set @sipQuery = 'sipusername%'

select Publisher, MIN(Status) as Status
from
(select Publisher, Status=
CASE
when Availability BETWEEN 0 AND 2999 then 'Not defined:'+Availability
when Availability BETWEEN 3000 AND 4499 then 'Available'
when Availability BETWEEN 4500 and 5999 then 'Available - Idle'
when Availability BETWEEN 6000 and 7499 then 'Busy'
when Availability BETWEEN 7500 and 8999 then 'Busy - Idle'
when Availability BETWEEN 9000 and 11999 then 'Do not Disturb'
when Availability BETWEEN 12000 and 14999 then 'Be right back'
when Availability BETWEEN 15000 and 17999 then 'Away'
when Availability > 18000 then 'Offline'
end
from
(
select Publisher,
substring(
substring(PublicationDocument,patIndex('%<availability>%',PublicationDocument)+14,50),0,
patIndex('%<availability>%',substring(PublicationDocument,patIndex('%<availability>%',PublicationDocument)+14,50))
) Availability
from
(select UserAtHost Publisher,ContainerNum,CONVERT(varchar(4000),convert(varbinary(4000),Data)) PublicationDocument
from rtcdyn.dbo.PublishedInstance tblPublishedInstance,
rtc.dbo.Resource tblResource
where tblPublishedInstance.PublisherId = tblResource.ResourceId) as PublishedDocuments
where LEN(replace(PublicationDocument,'aggregateState','')) < LEN(PublicationDocument)
and ContainerNum = 2
) as PublisherAndAvailability
where Publisher like @sipQuery
union
select UserAtHost Publisher, 'Offline-Not Registered Here' Status
from rtc.dbo.Resource
where UserAtHost like @sipQuery) as PublisherAndStatus
group by Publisher

참고

http://mikestacy.typepad.com/mike-stacys-blog/sql/

Container 테이블 설명

https://msdn.microsoft.com/en-us/library/bb879521.aspx

https://msdn.microsoft.com/en-us/library/office/dn454664.aspx

Access Control List Containers