Cloud Inventory® Documentation

Create the Activities table

Activities data stored in the activities log flat file can optionally be stored in a table in the database. You can create the Activities table (dsiActivities) to record this data.

To create the Activities table, complete one of the following sets of steps, depending on the database, in Advanced Inventory Platform Manager.

For a SQL Server database, complete the following substeps.
1. Locate the following file in the Mobile Enterprise Platform instance folder in the Resources\SQL\SQLServer folder: CreateActivities.sql.
2. n SQL Server, navigate to, open, and execute the CreateActivities.sql against the database that was created. The dsiActivities is created.
For an Oracle database, complete the following substeps.
1. Locate the following file in the Mobile Enterprise Platform Instance folder in the Resources\SQL\Oracle folder: CreateActivities.sql.
2. Execute the CreateActivities.sql against the database created.

Postrequisite: Register the Activities table. For steps, refer to Register database tables.

Note:If the Activities table is not registered, data activity will continue to be recorded in a flat file by default.

Create the dsiPlatformMetrics table

The dsiPlatformMetrics database table captures device and app event data. Though SQL Server Management Studio is used in this procedure, you can create this table using a number of database tools. Additionally, if you run an Oracle Database, we recommend you use SQL Developer to execute the necessary script.

Note: If you are a Cloud customer, this process is completed by Cloud Operations.

Prerequisite: Before you begin this process, you must have access to the database that hosts the Mobile Enterprise Platform tables.

To create the dsiPlatformMetrics table using SQL Server Management Studio, complete the following steps in Platform Manager.

In SQL Server Management Studio, locate the database where you want to create the table. In the following example, the table is created in the EDUMEPDEV database.

Step Information
In the Open File dialog box, complete the following substeps.
1. Navigate to the Resources directory for your Mobile Enterprise Platform installation and the applicable database.
2. Select CreatePlatformMetricsTable.sql and select Open.
Step Information
After the script loads, select the applicable database, then select Execute.

Step Information

Note:When using an Oracle Database, we recommend using SQL Developer to run and execute this script. Also ensure that you connect to the database schema.
Expected Result
Result: If the script runs successfully, the following message displays.
Command(s) completed successfully.

Result: The Platform Metrics table is now available for registration. If the Platform Metrics table is not registered, data activity is recorded in a temporary file for backup only. The Platform Metrics table must be registered for the data to be viewed. Refer to Register the Platform Metrics Insights database table for more information.

Create the Location Log table

You can create and register the Location Log table (dsiLocationLog) to record device GPS information received for Device Tracking.

To create the Location Log table, complete one of the following sets of steps, depending on the database, in Advanced Inventory Platform Manager.

For a SQL Server database, complete the following substeps.
1. Locate the following file in the Mobile Enterprise Platform instance folder in the Resources\SQL\SQLServer folder: CreateLocationLog.sql.
2. In SQL Server, navigate to, open, and execute the CreateActivities.sql against the database that was created. The dsiLocationLog is created.
For an Oracle database, complete the following substeps.
1. Locate the following file in the Mobile Enterprise Platform Instance folder in the Resources\SQL\Oracle folder: CreateLocationLog.sql.
2. Execute the CreateLocationLog.sql against the database created.

Postrequisite: Register the Location Log table. For steps, refer to Register database tables.

Note:If the Location Log table is not registered, data activity is recorded in a temporary file for backup only. The Location Log must be registered for the activity to be viewed in Device Tracking.

Create the Change Log table

You can create the Change Log table (dsiChangeLog) to record changes according to the settings specified in the Change Log Settings in Admin.

To create the Change Log table, complete one of the following sets of steps, depending on the database, in Advanced Inventory Platform Manager.

For a SQL Server database, complete the following substeps.
1. Locate the following files in the Mobile Enterprise Platform instance folder in the Resources\SQL\SQLServer folder: CreateChangeLog.sql.
2. In SQL Server, navigate to, open, and execute the CreateChangeLog.sql against the database that was created. The dsiChangeLog is created.
For an Oracle database, complete the following substeps.
1. Locate the following file in the Mobile Enterprise Platform instance folder in the Resources\SQL\Oracle folder: CreateChangeLog.sql.
2. Execute the CreateChangeLog.sql against the database created.

Postrequisite: Register the Change Log table. For steps, refer to Register database tables.

Note:If the Change Log table is not registered, data activity is recorded in the DSIChangeLog.XLog file. Either way, the recorded activity becomes available for review in System Monitor.

Create the dsiTransactionLog table

The dsiTransactionLog database table captures app transaction data. Though SQL Server Management Studio is used in this process, you can accomplish this task using a number of database tools. Additionally, if you run an Oracle Database, we recommend that you use SQL Developer to run and execute the necessary script.

Note: If you are a Cloud customer, this process is completed by Cloud Operations.

Prerequisite: Verify that the dsiTransactionLog table was not already created. Features other than the Platform Metrics insightsPlatform Metrics insights solution use the dsiTransactionLog table, and it might already exist in your environment. To complete this procedure, you must have access to the database hosting the Mobile Enterprise Platform tables.

To create the dsiTransactionLog table using SQL Server Management Studio, complete the following steps in Platform Manager.

In SQL Server Management Studio, locate the database where you want to create the table. In this example, the table is created in the EDUMEPDEV database.

Step Information
In the Open File dialog box, complete the following substeps.
1. Navigate to the Resources directory for your Mobile Enterprise Platform installation, then select the applicable database.
2. Select CreateTransactionLog.sql, then select Open.
Step Information
After the script loads, select the applicable database, then select Execute.

Step Information

Note:When using an Oracle Database, we recommend using SQL Developer to execute this script. Also ensure that you connect using the database schema.
Expected Result
Result: If the script runs successfully, the following message displays.
Command(s) completed successfully.

Result: The Transaction Log table is now available for registration.

Mobile Enterprise Platform

Create database tables

Create the Activities table

Create the dsiPlatformMetrics table

Create the Location Log table

Create the Change Log table

Create the dsiTransactionLog table