TopBanner

Skype for Business (Lync) Community Report Repository: Free Monitoring & Archiving Reports

image

Have you created a Skype for Business (Lync) Monitoring /Archiving Server report that you would be glad to share with others? The Skype for Business (Lync) Community Report Repository is meant to give you an easy way to share your standard SQL Reporting Services reports and benefit by the work of others.

Current Reports in the Repository

Report Author

2013

2010

  Short Description Download
Lync User IP Endpoints Matt Landis

X

 

N

Type in a SIP URI and get all the IP endpoints registered to that user. gallery pkg
IM Archive Report Hany George  

X

 

  click here
Peer-to-Peer Details Japheth Nolt

X

 

E

Get direct URL to link to specific details. gallery pkg
PChat Archive Report Richard Schwendiman

X

    persistent chat archive click here
NEW!Archiving Report & Dashboard Dodeitee

X

X

  Dashboard overview, detailed P2P IM conversations and conferences , more click here
   

 

 

     

[1] –note

Other Report Related Downloads

Tool Author

2013

2010

  Short Description Download
Lync Monitoring Reports Decoder Andrew Morpeth

X

X

 

Type in a SIP URI and get all the IP endpoints registered to that user. click here
NEW! Call Accounting Andrew Morpeth

X

X

  Call Accounting/Billing system click here
NEW! HP User Registrations Viewer HP

X

?

  Configured Lync Users and Registered Lync Users click here

 

How To Use a Report?

Just download the report and upload it to your SQL Reporting Services.

The typical URL for your SQL Reporting Services Home is http://{Your_SQL_Reporting_Server_Name}/Reports

image

Next Open Your Lync Monitoring Server Reports folder (Lync ServerReports) then open the “Reports_Content” folder.

image

From here you Upload the report file you downloaded from the repository by clicking “Upload File”.

image

Now you should be able to click the report you just uploaded and get a fresh new look at your Lync data!

NOTE: Make sure if you are uploading a report that overwrites an original report that you have a copy of the original report.

How to Submit a Report?

You can submit a report by emailing your report to mattmlandis at gmail with a subject of “Lync Report”. A short description of the report and if it is compatible with Lync 2010 and/or Lync 2013. Also include your name and URL for attribution.

I suggest having the report Data Source be either CDRDB or QMSDB.

How to Promote the Lync Community Report Repository?

Link to this blog article using: http://bit.ly/lyncreports
(I suggest linking to this blog)

The Skype for Business (Lync) Community Report Repository

To download the Lync Server report repository: Click Here

7 comments:

  1. Get the conference participants organized by a given user and in a specific time range is one of report which is very demanding by the end users. Below is the URL which Microsoft has published a sample sql query but doesn't seems to be working. Could you please look into this report and guide me in creating a custom report
    http://technet.microsoft.com/en-us/library/gg398329(v=ocs.14).aspx

    ReplyDelete
  2. Hi Matt, hope you're well.

    I've got an interesting query from a customer who wants count how often an individual Lync 2013 user is using each modality, i.e. IM, EV, Conferencing. I cannot see anything ready made, so before I work out how to do to it myself I thought I would check in for any ideas!

    ReplyDelete
  3. dont know of a report like that offhand. if you make one, we could include in repository

    ReplyDelete
  4. Not quite a Reports Server report yet (but it will be soon as I have the time), but here's a free basic solution to Lync Call Accounting. The solution can figure out who should be billed for the call, then looks up that users name, department and company up in Active Directory - http://www.lync.geek.nz/2014/03/lync-call-accounting-for-user-or.html. Please leave feedback so I can improve it.

    ReplyDelete
    Replies
    1. you really ought to make that a ssrs monitoring report. ;) seems like it would be a good fit.

      Delete
  5. I have been asked for the exact same report Chris.. Have you accomplished it? Would be if great help.

    ReplyDelete