This SQL View provides details of ROI generated when running Query scripts.
Back to Reporting SQL Views.
| Field Name | DB Type | Type | Nullable | Description |
|---|---|---|---|---|
| Id | uniqueidentifier | Guid | 0 | Unique ID of this view/table |
| LogId | uniqueidentifier | Guid | 0 | ID of ROI log. ID is created for each entry in the log |
| SAPUser | nvarchar | String | 0 | Runner SAP user |
| QueryFileName | nvarchar | String | 0 | Query script name |
| SAPSystem | nvarchar | String | 0 | SAP system iD |
| NumberOfRecords | bigint | Int64 | 0 | The number of retrieved by the Query. |
| TimeToExecute | nvarchar | String | 0 | Time required for execution |
| TablesUsed | nvarchar | String | 0 | Tables used in query |
| OutputFields | nvarchar | String | 0 | Field that are mapped to result file |
| SelectionFields | nvarchar | String | 0 | Fields used for criteria |
| ResultFileName | nvarchar | String | 0 | Result file name |
| ReasonForRun | nvarchar | String | 0 | Reason for run |
| Client | nvarchar | String | 0 | SAP client number |
| DateTimeOfRun | datetime | DateTime | 0 | Date of Run |
| QueryUnattendedLogId | bigint | Int64 | 0 | ID of unattended chunks on SAP server. For internal use only. |
| Username | nvarchar | String | 0 | User name of the Runner user |
| CustomerName | nvarchar | String | 0 | Connect customer name |
| CRMCustomerId | nvarchar | String | 0 | Connect CRM customer ID. |
| Product | nvarchar | String | 0 | Transaction/query. In this case query. |
| ClientProduct | nvarchar | String | 0 | Studio/Integration Server. Here Integration Server means run by Worker |
| ProductVersion | nvarchar | String | 0 | Version of Studio/Integration Server (Worker) eg. 20.0 |
| License | nvarchar | String | 0 | License used for run |
| CRMLicenseId | nvarchar | String | 0 | Connect CRM license ID. |
| RunType | nvarchar | String | 0 | server/manual |
| ReferenceId | uniqueidentifier | Guid | 0 | ID of the app in which query was run. |
| IsLogSync | bit | Boolean | 0 | Indicated if log have been synced to connect. |
| QueryLogId | int | Int32 | 0 | Unique log ID. This ID is sequential for maintaining the order of logs. |
| ProductName | nvarchar | String | 0 | Product name of license used for the run. |
| UserId | uniqueidentifier | Guid | 0 | The Runner user ID. |
| AppId | uniqueidentifier | Guid | 0 | The ID of the app in which the query was run. |