Generating Database Usage Tracking Report consists of the following two steps:
Do NOT click on the Database Usage Tracking Report shown at the bottom of the page. The online execution of this Usage Tracking Report has been disabled.
Click on the Administration tab on the top right corner of the page. Then select FTP under Delivery as shown below:
Click Add Server.
Enter the following fields for the FTP server:
Server Name - Example : myFTPserver (any name of your choice)
Host - Example : myhost.company.com
Port - Example : 22
Select "Use Secure FTP" check box to enable secure FTP (SFTP)
Enter a username and password to connect to the host
Click on Catalog Folders or alternatively the Catalog menu as shown in the following graphic.
Select Shared Folders, then select Enterprise Manager Cloud Control and then EM_Datamodels
Scroll to Database Usage Tracking Report and click Edit.
On the bottom of the left list, select Bursting, and then BurstToFTPserver.
In the SQL Query area, update the query as show below:
"myFTPserver" (configured in step 4) as the value for the PARAMETER1 column.
The output directory (absolute path of the directory on the disk) as the value for the PARAMETER4 column.
The status of the submitted job can be monitored in "Report Job History" page as shown below.
Errors (if any) in the metric collection are displayed at the bottom of each report that gets generated for an instance.
Use the refresh button highlighted in the screen shot (job_running.png) to refresh the status of the job
Wait until the status of the job changes from Running to Success.