Quick Tip: Automating SQL Reporting Reports

September 16, 2014

There are a ton of great tools available from both Microsoft and third party providers for reporting information about your Lync deployment.  One of the often overlooked options we have is to automate the delivery of reports from your SQL Reporting Server.  Here are the quick steps to enable this feature.

Step #1 – Setup SMTP on your SQL Reporting Server

For whatever reason, my experience is SQL Administrators never setup the SMTP options for the SRS server.  To configure this, launch the SQL Reporting Server Configuration tool on your SQL Server.  Go to the E-mail Settings and enter in your Sender Address, Current SMTP Delivery Method and SMTP Server.  When you have finished entering those settings, click on Apply at the bottom.

Make sure that the SMTP Server is setup to accept anonymous relay as there are no authentication options available from this management interface.

Step #2 – Subscribe to your reports

In order to subscribe to the reports, you need to make sure that you go to the reporting server page and not the reporting page.  Typically it will be a name like this:  http://<serverfqdn>/Reports_<instancename>.

You should see a page similar to this.

Click on LyncServerReports, Reports_Content and then on the far right side click on Detail View.  You should see something like this:

At this point in time, you should see a list of all of the reports available to you.  Find the report you wish to subscribe to and hover over it.  You should see an arrow and select subscribe:

On the resulting page you will have the option to e-mail the reports to yourself.

In addition to the e-mail option, you can also select a file location to drop copies of the report as well.  If you don’t see the E-Mail option listed under Delivered By that means your SMTP settings aren’t setup correctly.


Written by Richard Richard is an Office Apps &amp; Services MVP (Teams / Skype) who lives in Minneapolis, MN. Microsoft Certified Solutions Master (MCSM) and MCSM Instructor - when those were a thing long ago. When not writing code, breaking teams - debate coach and avid golfer.
Follow on Twitter

Built using Gatsby and Material-UI

Copyright © TheArgyleMVP 2022.