Viewing user query history

The application keeps a history of your queries issued from the current workstation.

To view the history, click View User Query History in the top menu or use the Alt+H keyboard shortcut.

The User Query History window is displayed after that. The main workspace of the window initially contains a list that represents all user queries issued from your current workstation. When a history record is highlighted, you can see the full query at the bottom of the window.

Use the filtering fields on the top to filter the list by specific criteria. Using the Find field, you can also filter out records that contain specific text.

To sort the list by a specific column in ascending or descending order, click the column header once or twice.

Note that the query history is kept on the local computer. To find it, see the article here.

The number of records in the history is defined in the application settings. To set this number, click Tools Options in the top menu, go to Query Analyzer Defaults settings section and enter the desired value under Keep [number] user queries in history.

Have more questions? Submit a request


  • 0
    Berger, Chuck

    Can the location the user query history is stored be customized?

  • 0
    Berger, Chuck

    Can a sql query be removed from the user history? In particular, I use alter user to change my password. If I bring up user query history with others watching, they can see my new password. I would like to remove that statement from the history file.

Please sign in to leave a comment.

** Aginity, Inc.’s Provision of Scripts and Similar Materials at Help Desk Center. For the convenience of Aginity Amp™ clients, we provide code snippets, scripts and similar materials at this Help Desk Center. Such materials are reference materials provided for illustration purposes only. These are intended to serve as an example for self-service clients and are generally geared to respond to common questions asked by similar clients. Such materials constitute Aginity’s intellectual property. Aginity Amp clients and their authorized users are permitted to use these materials in connection with their software license and/or subscription of Aginity Amp. Nothing herein shall limit Aginity’s right to use, develop, enhance, modify or market any of these materials as part of its business. These materials are not formally supported by Aginity or its affiliates. Usage of these materials does not guarantee any specific results, uptime, performance or error-free operation. Aginity disclaims all warranties of any kind, whether express, implied, statutory or otherwise, including any implied warranty of merchantability or fitness for a particular purpose.

Powered by Zendesk