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
Next Open Your Lync Monitoring Server Reports folder (Lync ServerReports) then open the “Reports_Content” folder.
From here you Upload the report file you downloaded from the repository by clicking “Upload File”.
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
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
ReplyDeletehttp://technet.microsoft.com/en-us/library/gg398329(v=ocs.14).aspx
Hi Matt, hope you're well.
ReplyDeleteI'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!
dont know of a report like that offhand. if you make one, we could include in repository
ReplyDeleteOk, I'l let you know how I get on
ReplyDeleteNot 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.
ReplyDeleteyou really ought to make that a ssrs monitoring report. ;) seems like it would be a good fit.
DeleteI have been asked for the exact same report Chris.. Have you accomplished it? Would be if great help.
ReplyDelete