LextEdit automatically generates and stores a history of all commands executed. A history record consists of the status of the command executed, number of rows returned, total elapsed time of the execution, the command text that was executed, the start time of when it was executed, the row result, the connection string of the system the command was executed against, and what type the connection was.
The History files can be navigated quickly and searched based on the content of the command, the row result, result status, connection string, and connection type. The Directories tab shows the History folder and any sub folders in the History directory. By default the sub folders are unchecked to allow for faster searching of more recent history files.
The calendar information shows the days where commands where executed, the graph shows the frequencey of the number of commands executed by hour, and the Sessions can be tied to the graph. Double clicking on the session will link you back to the session in the History Navigation.