This is a predefined report created to provide the Allocation and installation details of each Licensed Product. This solution works for all DB's (Sybase, Oracle, MS-Sql)
The licensed product can be allocated by demographic (Site/Department/Cost Center).
This report provides the summary as below:
And the Installation Details as below:
Summary: Licensed Product, Allocation Type, Cost Code, Device Count, Allocated Quantity, Installed Quantity, Variance of allocation and installation.
Installation Details are by demographic: Machine Name, Manufacturer, License Name, License Version, Ip Address, Last Usage Date, Site, Last Inventory Scan Date.
Also this report takes the Input data before running the report. Below are the ones.
Input Controls: License Product Manufacturer, License Name, Version, Demographic Unit.
Attached the screenshot of the Report where the Licensed Products Allocation type is Site.
Note: For Sybase - download the report file "zrsReports_export_Sybase.zip" zrsReports_export_Sybase
For Oracle - download the report file "zrsReports_export_Oracle.zip" zrsReports_export_Oracle
For MS-Sql - download the report file "zrsReports_export_Mssql.zip" zrsReports_export_Mssql