Purpose
This tool may be used to get your product usage data in a single table in a CSV file. This allows for self-discovery outside of the restrictions of a formatted report. You may view all Export Jobs that have been created by other Admins and Co-Admins at your account.
Roles
Users with at least one of the following roles are able to access the report:
Access
Data Export
When it first opens, it will display the list of all Export Jobs that have been run. The Export Jobs may be downloaded from this page. Export Jobs are stored for 60 days.
Click on a column header to sort that column in ascending order. Click on the column header again to sort in descending order. Click on the filter icon for the columns that have them to filter.
The page will automatically refresh every minute. You may also use the refresh icon in the top right-hand corner.
Name
Description
Job Name
The name given to the Job.
Status
Indicates if the Export Job is pending, executing, complete, or failed.
Export Type
Indicates the layout of the data that was requested.
Created by
IMS email address of the user that originally submitted the request.
Submitted
Date and time of when the Export Job was submitted. It is in the local timezone of the user currently viewing this page.
Completed
Date and time of when the Export Job completed. It is in the local time of the user looking at this page.
Remaining Days Available
Jobs are automatically deleted after 60 days. This will countdown the number of days the file has left. When it has 5 or fewer days, it will be highlighted in red.
Export Size
Actions - Download
Actions - Delete
To create a new export job, click on the Create a New Export Job button in the top right-hand corner.
Create a New Export Job
Click the Create a New Export Job in the top right-hand corner. This will open the Create a New Export Job dialog box. Click Cancel to close the window.
The format of the export job. More details on Export Type are below.
The name for this export job.
Date Range
Date range for the export job. All dates are based on UTC time. The earliest date available is 18 months from the current date. The maximum range that may be selected is 92 days.
Once all of the options have been selected, the Create Job button will activate so you may submit your job. The amount of time it takes for the job to complete depends on how large the report will be based on your Export Type and Date Range selections. You will be emailed when the file is ready for download. If a job has any issues, it will automatically delete after two days.
There are six Export Types, which each have their own layout. The description underneath Each Export Type indicates the report the Export Type is based on.
Machine Usage data
Contains data from: Machine Usage and Application Usage by Day
User Usage data
Contains data from: Daily Usage by User
Intervals Data
Contains data from: Usage Details
Peak Usage Data
Contains data from: Daily Peak Application Usage
Inventory Data
Contains data from: CONNECTION Client Inventory
E365 Usage Data
Contains data from: E365 Usage. This is only available to accounts part of the E365 program.
Usage Date
Most of the reports have some type of a UsageDate column. When the CSV is viewed in a plain-text tool such as Notepad, the column is visible as a YYYY-MM-DD format.
Depending on your default Excel settings, if you open the CSV in Excel, you may need to change the column format.
Other Language Sources
Deutsch