0 Replies Latest reply on Oct 31, 2016 8:58 AM by GaryMcAllister

    Creating custom AppSense Reports with SSRS

    GaryMcAllister SupportEmployee

      SQL Reporting Services (SSRS) provideds a full range of ready-to-use tools and services to help you create, deploy, and manage reports. Reporting Services includes programming features that enable you to extend and customize your reporting functionality.


      When using SSRS in conjunction with the AppSense ManagementServer and PersonalizationServer databases, we are able to create a limitless number of reports, detailing everything that you might need to know about your AppSense environment, and more!



      What’s more, we are able to export and share any report templates that we create, allowing us to greatly extend the currently reporting capabilities within DesktopNow.


      SSRS is a feature of SQL, and can be selected as an option when installing SQL, or added as an additional feature later on. It’s quick and easy to set up, requires little configuration, and allows you to quickly start running customized reports against the AppSense Databases.


      Once the feature is enabled, it’s simply a case of creating a ‘DataSource’ (a link to your Database) and a ‘Report Model’ (a user-friendly description of the underlying database). Both of these can be generated from the SSRS web console (http://localhost/Reports), and are very quick and easy to set up.



      We’ve added a number of SSRS reports to AppSense Exchange already, so that you can download and try these for yourself. The reports were created in Report Builder 3.0, and required no SQL scripting skills what-so-ever. Once the reports are uploaded to your SSRS web console, you can start to run them against your databases.


      But why stop there? Once SSRS is set-up and your Report Model created, you can use Report Builder to create your own custom reports!


      Check out the attached guide for how to get started with AppSense & SSRS.