Video Screencast Help
Symantec Appoints Michael A. Brown CEO. Learn more.

Creating Report Subscriptions for IT Analytics

Created: 11 Dec 2012 • Updated: 22 Nov 2013 | 4 comments
Language Translations
dprager's picture
+18 18 Votes
Login to vote

IT Analytics offers customers unparalleled flexibility in the way they visualize, analyze, and consume their business critical data. In addition to providing users a valuable and comprehensive reporting solution out of the box, IT Analytics’ flexible architecture and use of standard technologies gives users several options for report consumption. This article outlines creating report subscriptions using SQL Reporting Services so that reports can be delivered via e-mail to specific users on a set schedule.

NOTE: This article assumes IT Analytics is already installed and configured, and that you have the proper rights to SQL Reporting Services. 

Creating a Subscription

  1. On the server hosting SQL Reporting Services, open a web browser and go to the following URL: http://localhost/Reports/
  2. Click on the IT Analytics folder.

article17-1_1.gif

  1. Locate the report or dashboard you would like to subscribe to, in our example we will use the Computer Inventory Dashboard, however you can select any report from any the installed content packs (SEP, DLP, CSP, ServiceDesk or Altiris Client Server Management). Once you have located the desired report, click the downward facing triangle and select Subscribe.

article17-2_0.gif

 

  1. Specify Windows File Share in the Delivered by field, assign a File Name, Specify a UNC Path, select a Render Format, provide credentials to access the file share, and specify appropriate overwrite options.

 

article17-3.gif

 

  1. Click on the Select Schedule button to define the subscription schedule.

 

article17-4_0.gif

  1. Define the schedule as required and select OK.

 

article17-5.gif

  1. If your report or dashboard contains parameters, specify them as required, in our case we will select the Use Default options, then click OK.

 

article17-6.gif

  1. Navigate to the UNC path specified above to view the subscription (will be empty until the execution time has occurred).

 

article17-7.gif

  1. View your report to ensure it appears as expected.

 

Modifying an Existing Subscription (E-mail Delivery Option)

In this section, we will modify the subscription previously created to send an email instead of posting to a UNC share. In order to use this functionality, SQL Reporting Services must have properly configured E-Mail settings.

  1. On the server hosting SQL Reporting Services, navigate again to the Report Server home page http://localhost/Reports/
  2. In the upper right hand corner of the page click on My Subscriptions.

  1. Click the Edit link next to Computer Inventory Dashboard.

 

article17-9.gif

  1. Change the Delivered by option to E-Mail and specify the To address as required.

 

article17-10.gif

  1. Click on the Select Schedule button to define the subscription schedule.

 

article17-11.gif

  1. Define the schedule as required and select OK.

 

article17-12.gif

  1. If your report or dashboard contains parameters, specify them as required, in our case we will select the Use Default options, then click OK.

 

article17-13.gif

  1. At the scheduled time, the report will be emailed to recipients specified in step 4.

 

article17-14.gif

Comments 4 CommentsJump to latest comment

R@mj0's picture

hi Sir,

sorry, what product are you using on this?

i might get idea on this.

coz i need Regarding the “Dashboard scheduled report”

to send out the graph to the specific user.

 

thank you,

0
Login to vote
dprager's picture

This article shows an example of using IT Analytics with Microsoft Reporting Services to send out a dashboard report. If you have any of the following Symantec products, then you have access to IT Analytics out-of-the-box:

  • Symantec Endpoint Protection
  • Data Loss Prevention
  • Critcal System Protection
  • IT Management Suite
  • ServiceDesk

For more information on implementing IT Analytics, simply search for articles under my username and you'll find a ton of content.

Hope that helps.

0
Login to vote
JoeVan's picture

Note:  Depending on how you configured SQL Reporting services, your URL may be different.  In my case, the SQL Reporting instance name is part of the url so it looks more like this:

http://SQLSERVERNAME/Reports_INSTANCENAME/

Also, if you can't figure out why the subscription options are missing, ensure  you are on the right URL.  The above "Report Manager" UI is completelty different from the Report Server UI which has a URL like this:

http://SQLSERVERNAME/ReportServer_INSTANCENAME/

I didn't realize the difference right away and it caused me some confusion. 

Joe VanHollebeke
Systems Engineer

0
Login to vote
R@mj0's picture

hi,

Since i used DLP, i used the Oracle DB.

0
Login to vote