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.