Licenses By Product Report
The Licenses By Product Report displays a list of licenses for a given Product over specified date range, grouped by Product.
To view this report, click the Reports menu, scroll down to the Licenses section, and click Licenses by Product.
Report Options
- Report Type
- The report type. Options are as follows:
- Adobe Acrobat: The report will be generated as an Adobe Acrobat file (pdf).
- Microsoft Excel: The report will be generated as a Microsoft Excel spreadsheet (xls).
- Comma Separated Value: The report will be generated as a comma separated value file (csv).
- XML by Elements: The report will be generated as xml with separate elements for each field.
- XML by Parameters: The report will be generated as xml with a single element containing an attribute for each field.
- Start/End Date
- The date range to run the report for. This will include licenses based on their creation date. The activation data for those licenses will not be limited by the specified date range, and will include data the occurred after the End Date (if applicable).
Note that depending on the server configuration, there may be a restriction of the number of days the report can be run for. - Save to Disk
- Check this box to save the report to disk. If unchecked, the report will be displayed in an inline frame within the web page, otherwise you will be prompted to save the file to disk.
- Product
- Choose a Product to filter the report data to only include records for the given Product. Select the default of ALL to include all Products.
- Filter Issue License
- Check the checkbox to include only licenses for Product Options that have Issue License feature set on the Option configuration.
- Filter Unregistered
- Check the checkbox to include only licenses for customers who have registered.
- Filter OK Status
- Check the checkbox to include only licenses with OK status.
- Status Check Days Back
- The number of days back from the current date to search each license for a count of active installations which have phoned home to perform a status check.
- Sort By
- The grouping method of the report. Options are as follows:
- Entered Date
- Licensee Name
- Product Option Name
Report Output
This report contains the following fields:
PDF and XLS
- Product
- Licensee (Company Name)
- License ID
- Qty
- Entered Date
- Option Name
- Successful Activations: The total number of successful activation requests.
- Declined Activations: The total number of declined activation requests.
- Threshold Activations: A successful activation request that was reactivation, which is allowed if the Allow Reactivations on Same Computer setting is enabled, and there is a previous activated installation for the exact same computer.
- Active Installations: Successful activation requests that have an Installation ID.
Total amounts are listed for each Product.
CSV and XML
- CustomerID
- LicenseeName
- ContactName
- FirstName
- LastName
- MailAddr1
- MailAddr2
- MailAddr3
- City
- StateProvince
- PostalCode
- Country
- EMail Voice
- Fax Enabled
- OfferProduct
- OfferPartners
- ExternalReference
- LastLogin
- Status
- LicenseEnteredDate
- EnteredBy
- ProdOptionID
- QOrdered LicenseID
- ActivationPassword
- UnlocksLeft
- ExpirationDate
- LicenseCounter
- ProductID
- ProductName
- OptionName
- DistributorID
- InvoiceNo
- InvoiceCustomerID
- Terms
- AmountCharged
- AmountStoreCredit
- AmountDiscount
- AmountShipping
- AmountTax
- Source MarketingSource
- PromoCode
- InvoicePriorityCode
- ShipMethod
- QBAccount
- QBClass
- QBItem
- QBTaxable
- UnitPrice
- SalePrice
- ComboDiscountAmount
- UpsellProdOptionID
- BundleDiscountAmount
- BundledProdOptionID
- LicenseNotes
- CustomData
- LicensePriorityCode
- PriorityCodeDiscountAmount
- DistribCompanyName
- DistribContactName
- PaymentPlanInstanceID
- LastUpdateDate
- LastUpdateStatus
- SuccessfulActivations
- DeclinedActivations
- ThresholdActivations
- ActiveInstallations
- ActiveInstallationsPhonedHome
- LicenseLicenseeName
- LicenseLicenseeEmail
- OriginalLicenseID
- LFUdefChar1 - LFUdefChar10
- LFUdefNum1 - LFUdefNum5
- LFUdefFloat1- LFUdefFloat5
- LFUdefDate1 - LFUdefDate5
- ExternalReference1
- ExternalReference1Source
- ExternalReference2
- ExternalReference2Source
- LicenseCustomData
- OptionCustomData
- ProductCustomData
- AuthorCustomData