# Open iT Reporting Services

Open iT Reporting Services is a web portal hosted via SQL Server Reporting Services. It includes a range of pre-configured report templates displayed in different graphical formats to enhance the visual representation of data. These templates have two categories: LicenseAnalyzer Level 1 and LicenseAnalyzer Level 2.

# LicenseAnalyzer Level 1 Reports

The Reporting: LicenseAnalyzer Level 1 Standard Reports table lists LicenseAnalyzer Level 1 report templates and their description.

Report Title Description
Annual Usage Overview This report presents a monthly summary overview of application license usage for a specified period. (Tabular view)
Application Distinct User per Hour Summary This report presents a chart overview of Distinct Users per hour, ideal for usage pattern analysis.
Day since Last Used - per User This report presents the individual license usage report on a monthly overview. It also shows the day the application was last used. Very useful for named-user agreements. (Tabular view). (Tabular view).
Distinct User per month This report presents an overview of Distinct Users per application per month, ideal for usage pattern analysis.
DSLS License Usage per Licensing Model and Pricing Structure This report presents a table that features the license usage of individual licensing models and pricing structures, ideal for monitoring usage past the specified threshold.
Heatmap - Month Hour This report presents a heatmap illustrating the times of day when license usage peaks and declines throughout a day for a month.
Heatmap - Week Hour This report presents a heatmap illustrating the times of day when license usage peaks and declines throughout a day over a week.
License Efficiency Chart This report presents an inverse cumulative frequency chart for concurrent license checkouts. It also shows the number of licenses used between 95 and 99 percent of the time.
License Efficiency Chart - With Percentile This report presents the extended version of the License Efficiency Chart, which includes the 99% and 95% Confidence Intervals, and Weekly Time Bucket reports.
License Overview This report presents a monthly Elapsed Time view of applications within the specified periods.
License Usage per Feature Version This report presents a monthly summary overview of application license usage categorized by version for a specified period. (Tabular view)
License Usage per User This report presents a table that features individual user's license use, ideal for monitoring usage past the specified threshold.
Max and Average License Use - With Denials This report presents the daily license usage trend history, including license denials for a selected vendor license/feature over a specified period of time.
Max Concurrent - Distinct User This report presents a table that shows the Max Concurrent Distinct Users for specified Vendor Licenses and Applications.
Summary page to detail page This report presents a comprehensive view of application license usage and denials, which can be further drilled down to the user level.
User Denials This report presents the license denials of distinct users for selected Vendor License and Applications.
Reporting: LicenseAnalyzer Level 1 Standard Reports

# Advanced Reports

Report Title Description
Invoice This report presents the invoice statement used for pay-per-use agreements or chargebacks.
License Efficiency LAN versus WAN This report presents the LAN vs. WAN agreement simulations, which show the total concurrent licenses of all the vendor licenses against the true concurrent license usage when these vendor licenses are combined.
Percentile Cost Savings This report presents potential cost savings from the selected applications based on the number of unused licenses at the selected efficiency percentile, unit license costs, and maintenance costs.
Usage Right Compliance This report presents the license compliance of applications that are not using license managers by comparing ownership and usage.
Reporting: LicenseAnalyzer Level 1 Advanced Reports

# LicenseAnalyzer Level 2 Reports

Report Name Description
Active vs Inactive per User This report lists application users and corresponding usage activity and inactivity.
Application Activity This report presents the recorded elapsed time of an application's activity versus inactivity.
Work Ratio This report presents the monitored elapsed time of an application's activity versus inactivity ratio relative to overall usage.
Reporting: LicenseAnalyzer Level 2 Reports

# Recommended Reading

The following configuration is essential for Reporting Services to work properly.

   Configuring SSRS Subscription

   Updating Service Account in Reporting Services Data Sources

Powered by Open iT ® Open iT Docs All rights reserved.