Quick Tip: Automating SQL Reporting Reports

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.

pic1

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.

pic2

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

pic3

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:

pic4

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

pic5

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.

2 comments on “Quick Tip: Automating SQL Reporting Reports”

  1. Pingback: NeWay Technologies – Weekly Newsletter #113 – September 18, 2014 | NeWay

  2. Pingback: NeWay Technologies – Weekly Newsletter #113 – September 19, 2014 | NeWay

Leave A Reply

Your email address will not be published. Required fields are marked *