SQL Script Descriptions

For both SQL Server and Oracle environments, FlexNet Operations provides the same collection of sample SQL scripts.

Sample SQL Scripts Included with FlexNet Operations Reporting

Script Type

Script Description and Name

Subscription Billing Report

For a given date, this report shows a list of product line items that are expiring, along with additional details about those products.

ADDONS_EXPIRING_ON_A_DATE_OR_TIMEPERIOD.sql

Consumed Count Trends

For a given customer, this report shows a list of products for which the consumed copies increased or decreased during a specified time period.

ADDONS_WITH_CHANGED_CONSUMED_COPIES_FOR_CUSTOMER_OVER_A_TIMEPERIOD.sql

Device Activity Report

For a given date range, this report shows device activity (line items mapped or unmapped) as well as a number of related details like the event type, SKU, product name, event date, and so on.

DEVICE_ACTIVITY_REPORT(AVID).sql

Maintenance Expiration Report for a Customer

For a given customer, this report shows all the customer’s devices with maintenance items that are expiring.

DEVICES_WITH_EXPIRING_MAINTENANCES.sql

Unactivated Products on Devices

For a given date and a given product, this report shows a list of devices for which the product was requested but the consumed count is 0.

DEVICES_WITH_UNACTIVATED_ADDONS.sql

Maintenance Expiration Report for Products

For a given date, this report shows a list of maintenance items that are expiring and the products related to those expiring maintenance items.

MAINTENANCE_PRODUCTS_EXPIRING_ON_GIVEN_DATE.sql

Devices with Pre-Installed Licenses by Customer

For a given customer, this report shows the list of devices with pre-installed licenses and includes the device name, device status, host type or host attribute, and the date the license was generated.

MANUFACTURER_PREBUILT_LICENSE_DEVICES_FOR_CUSTOMER.sql

Total Number of Devices by Machine Type

This report shows the total number of devices and the VM name (as appropriate) for each machine type (virtual, physical, or unknown).

TOTAL_NUMBER_OF_DEVICES_FOR_MACHINE_TYPE_OR_VM_NAME.sql

Total Number of Devices by Status and by Host Type or Host Attribute

For a given device status and a given host type or host attribute, this report shows the total number of devices.

TOTAL_NUMBER_OF_DEVICES_FOR_A_HOSTTYPE_OR_HOSTATTRIBUTE.sql