Query ROI View

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.