# 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