QueryLog
The QueryLog properties listed in this topic are written to the log file named QueryLog.<ID>.txt. Each row in the log represents a query, which was generated from a data connector running on the Spotfire instance and sent to an external data source. By default, the logging level is set to OFF.
Property | Description |
---|---|
Level
|
The logging level |
HostName
|
The name of the computer running the Spotfire service. |
TimeStamp
|
The date and time, in the local time of the computer running the service, when the query was generated in Spotfire. |
UTCTimeStamp
|
The date and time, in UTC, when the query was generated in Spotfire. |
QueryId
|
The unique identifier of the query, as assigned by Spotfire. |
UserName
|
The Spotfire username of the logged in user. |
Status
|
Specifies whether the query succeeded, failed, or was canceled by the user. |
DurationMs
|
The amount of time, in milliseconds, that the query took to execute in the external data source. |
RowCount
|
The number of rows in the query result. |
ColumnCount
|
The number of columns in the query result. |
DataSourceType
|
The type of Spotfire connector that was used in the connection. |
DatabaseServer
|
The URL or IP address of the server of the external data source. |
Database
|
The name of the database in the external data source. |
DatabaseUser
|
The database user that was used to log in to the external data source. |
Analysis
|
The name of the Spotfire analysis file. |
Visualization
|
The name of the visualization in the analysis that generated the query. |
Operation
|
The type of operation that generated the query. |
DataSourceInfo
|
Connector type specific information regarding the data connection. |
Parameters
|
Any parameters in the query. |
QueryString
|
The full query string sent from Spotfire to the external data source. |
Parent topic: Service logs