< Blog

3 New SQL SSRS Reports

This year we added 3 new SSRS reports to our SQL Collection category in Enhanced Web Reporting – EWR.

Count of SQL 2012 Editions.¬ This report provides a count of all SQL 2012 editions within your environment.¬ From here you can drill down further to see the report List of PCs by SQL 2012 Edition, which in turn drills through to Computer SQL Details. With this information you will know the number of SQL 2012 licenses you have. Use Count of SQL 2012 Editions to help retrieve and report on your SQL 2012 software.

List of PCs by SQL 2012 Edition. Drill down to this report from Count of SQL 2012 Editions.¬ This report provides you with the PC Name, Version Number, Instance Name, and Installed Directory for a particular SQL 2012 edition.¬ Your software inventory assessment for SQL 2012 will be complete when you know exactly which PCs have this software installed on them. From this report, you can drill through to Computer SQL Details.

AND,

Computer SQL Details. Drill down to this report from List of PCs by SQL 2005 Edition, List of PCs by SQL 2008 Edition, and List of PCs by SQL 2012 Edition. With this information you will know the number of SQL 2005, 2008, and 2012 licenses you have for a specific PC.

Tomorrow, we will tell you about an additional bonus that you can use once you install the SQL Collection.

Sample Screenshots:

Count of SQL 2012 Editions

List of PCs by SQL 2012 Edition

Computer SQL Details