Log Parser Studio - Keyboard Shortcuts

I often find myself wooing and wowing colleagues with the keyboard shortcuts built into LPS. Though they can be found via help, I thought it might a good idea to list them here since they are so handy:

Log Parser Studio - Shortcuts

  • ALT+B - Display the Batch Job window.

  • CTRL+C - Query Results: Copy selected cells to clipboard including field names. Library: Copy selected queries and their properties to clipboard.

  • CTRL+D - Duplicate the selected query tab. Use this to quickly create a new copy of the query you are editing.

  • CTRL+E - Export query results to CSV file.

  • CTRL+ALT+E - Opens the LPS error log if any errors have been logged.

  • CTRL+F - Reloads the default library into Log Parser Studio. If you have saved some queries but have not saved the library, this will revert those changes.

  • ALT+F - When the library is visible, this will filter to only show queries that are marked as favorites (Same as clicking the favorites buttonĀ - The category/favorites buttons are no longer shown by default - see preferences to enable).

  • F1 - Open Log Parser Studio Help.

  • F2 - When the library is visible, this allows quick editing of the selected query's name, description and category. This is handy if you have previously saved a query but need to make small changes quickly without actually opening the query.

  • F3 - When a query tab is visible, this displays the default IISW3C field names for quick reference. CTRL+Click to select the desired fields then click enter to place these on the clipboard. Any queries beginning with * are fields that are not enabled by default when IIS is initially installed.

  • SHIFT+F3 - Displays the Log Parser 2.2 Function Reference. Use this when creating your own queries or to learn more about Log Parser's built-in functions.

  • F4 - If a cell or cells are highlighted in a query's result grid, this will expand/collapse the selected columns the cells belong to.

  • F5 - When a query is opened, execute the selected query.

  • F6 - When a query which has results is visible, F6 displays its chart. However, for the chart functionality to work, the first column can be any data type, the second column must be some type of numerical value. Charts always operate on the first two columns only.

  • F7 - Auto insert FROM '[LOGFILEPATH]' into the selected position when editing a query.

  • F8 - Auto insert INTO '[OUTFILEPATH]\Output.csv' into the selected position when editing a query. Output.csv is auto-selected to facilitate changing the name to something more meaningful, quickly.

  • F9- Auto insert LIKE '%%' into the selected position when editing a query. Many queries search for data using the LIKE statement. This makes using LIKE quick and easy. Just press F9 then type the string you are searching for.

  • F10 - Display a new random hint. Hints are randomly displayed in the top right main window. Press F10 to see a new one.

  • CTRL+L or CTRL+I- Load/Import XML Queries.

  • CTRL+ALT+L - Opens the current library in XML format in an installed text editor. If no known editors are found, it uses the operating system's default editor for XML files. Order of search for installed editors (first found is used): Notepad++, Notepad2, Textpad, Notepad, Default.

  • CTRL+K- Display's the shortcut keys window you are viewing now.

  • CTRL+Q - Switch to the library.

  • Mouse Button Forward - Move to next tab.

  • Mouse Button Back - Move to previous tab.