[Okta Webinar] Learn how to a build a cloud-first strategyRegister Now


Lync 2013 users statistics

Posted on 2014-09-02
Medium Priority
Last Modified: 2014-09-24
dear all,

is there a way to get sort of statistics for Lync users which include as example the up time per account, last login time ... etc

Question by:Rhala

Expert Comment

by:Dan Arseneau
ID: 40299162
Here you go, courtesy of Microsoft...

User Activity Report in Lync Server 2013
LVL 10

Expert Comment

ID: 40299164
Did you install the Lync monitoring reports from Microsoft?  The reports have a ton of information.  This is the MS link: http://technet.microsoft.com/en-us/library/jj204989.aspx

In case the link breaks and for future reference, here's a copy of the important stuff:


Click Start, click All Programs, click Microsoft Lync Server 2013, and then click Lync Server Deployment Wizard.


In the Deployment Wizard, click Deploy Monitoring Reports in order to start the Deploy Monitoring Reports wizard.


In the Deploy Monitoring Reports wizard, on the Specify Monitoring Database page, make sure that the fully qualified domain name of the computer hosting your monitoring store appears in the Monitoring database dropdown list. (If you have multiple monitoring stores you will need to select the appropriate server from the dropdown list.) Verify that the correct SQL Server instance appears in the SQL Server Reporting Services (SSRS) instance box (for example, atl-sql-001.litwareinc.com/archinst) and then click Next.


On the Specify Credentials page, in the User name box, type the domain name and user name of the account to be used when accessing the Monitoring Reports (for example, litwareinc\kenmyer). If you do not use this format (domain\user name) an error will occur.
Type the user account password in the Password box, and then click Next. Note that no special rights are required for this account. The account will automatically be granted the required logon and database permissions when setup completes.


On the Specify Read-Only Group page enter the name of a security group that will be granted read-only access to the SQL Server Reporting Services in the User group box. For example, to give read-only administrators access to the reports enter RTCUniversalReadOnlyAdmins. Click Next.


On the Executing Commands page, click Finish.
Monitoring Reports can also be installed from the Lync Server Management Shell by running the script
DeployReports.ps1; this Windows PowerShell script can be found on the Lync Server installation media in the \Setup\ReportingSetup folder. To install Monitoring Reports using DeployReports.ps1, type a command similar to the following at the Management Shell prompt:
D:\Setup\AMD64\Setp\ReportingSetup\DeployReports.ps1 -storedUserName "litwareinc\kenmyer" -storedPassword "p@ssw0rd" -readOnlyGroupName "RTCUniversalReadOnlyAdmins" -reportServerSqlInstance "atl-sql-001.litwareinc.com" -monitoringDatabaseId "MonitoringDatabase:atl-sql-001.litwareinc.com"
LVL 44

Expert Comment

by:Vasil Michev (MVP)
ID: 40299395
In case you are looking for Reports for Lync online: http://msdn.microsoft.com/en-us/library/office/dn387063(v=office.15).aspx

Not much statistics available unfortunately...

Author Comment

ID: 40300330
Yes i Have monitoring server implemented, but what i need is a report for a specific group of users to get their information, for example, i need to know all info about Sales department users specifically, is that possible?
LVL 18

Accepted Solution

irweazelwallis earned 2000 total points
ID: 40313881
you can build up custom reports but you need some SQL skills to link up the information you need

failing that you use one of the inbuilt reports which isn't filtered for the specific users and import into Excel to amend
technet gives you some pointers on this


Featured Post

Simplify Active Directory Administration

Administration of Active Directory does not have to be hard.  Too often what should be a simple task is made more difficult than it needs to be.The solution?  Hyena from SystemTools Software.  With ease-of-use as well as powerful importing and bulk updating capabilities.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Issue: One Windows 2008 R2 64bit server on the network unable to connect to a buffalo Device (Linkstation) with firmware version 1.56. There are a total of four servers on the network this being one of them. Troubleshooting Steps: Connect via h…
Windows Server 2003 introduced persistent Volume Shadow Copies and made 2003 a must-do upgrade.  Since then, it's been a must-implement feature for all servers doing any kind of file sharing.
In this Micro Tutorial viewers will learn how they can get their files copied out from their unbootable system without need to use recovery services. As an example non-bootable Windows 2012R2 installation is used which has boot problems.
This tutorial will walk an individual through the process of configuring their Windows Server 2012 domain controller to synchronize its time with a trusted, external resource. Use Google, Bing, or other preferred search engine to locate trusted NTP …
Suggested Courses

873 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question