Export Activation Data Report
The Export Activation Data Report allows exporting raw activation data from the database to a csv or xml file. It can be reached from two locations:
- Click the Reports menu, scroll down to the Licenses section, and click Export Activation Data. When reached through this path, the report can be run against a specific Product over a given date range.
- From the License Activation History page by using the Actions dropdown and choosing Export. When reached through this path, the report will export activation data for the given license.
Report Options
- Report Type
- The report type. Options are as follows:
- 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.
- Filter By Date
- Whether to filter by date.
- Start/End Date
- The date range to run the report for. 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. This option is not available when reached from the license activation history page.
Report Output
This report contains the following fields:
- ActivationDate
- LicenseID
- CustomerID
- CompanyName
- FirstName
- LastName
- Country
- ProductID
- ProductName
- ProdOptionID
- OptionName
- LicenseEnteredDate
- LicenseModifiedDate
- ExtraInfo
- Status
- ActivationType
- InstallationID
- ComputerID
- InstallationName
- EnteredBy
- IPAddress
- ResultCode
- LastStatusCheck
- LastStatusCheckResultCode
- InitialProductVersion
- CurrentProductVersion
- Exception
- LicenseUpdate
- DeactivatedDate
- DeactivatedBy
- RecordID - a unique identifier for the record, formed from the source ID plus a suffix of A for a successful activation or R for a rejected attempt (for example 8842A, 8842R). This is a string; do not parse it as an integer.
Working with Exported Data
- Exported rows are not immutable. Fields such as DeactivatedDate, DeactivatedBy, LicenseModifiedDate, LastStatusCheck, LastStatusCheckResultCode, and CurrentProductVersion can change on a row after it has already been exported, and IPAddress is cleared when customer data is purged. A consumer tracking these records should upsert by RecordID rather than insert-only, or later changes (most importantly deactivations) will be missed.
- InstallationID, InstallationName, LastStatusCheck, and CurrentProductVersion are tied to the Installation record, which can be reassigned from one activation to another (for example on a license transfer or reactivation). A record that once exported with these fields populated may later export them as empty, with the values now appearing on a different record - this reflects the installation moving, not data loss.