Home › Discussions › Questions & Answers › Controlling SQL Visibility in Log and Output Files

Controlling SQL Visibility in Log and Output Files

Avatar photoCustomer Questions & Answers 5 replies

For security reasons, we need to prevent the report SQL from being displayed in both the concurrent program log files and the parameter tab of the XLSX output files. How is this configured?

5 replies

  • Support Enginatics

    You can control SQL visibility using two separate profile options. To exclude the SQL from the log file, set ‘Blitz Report Include SQL in Log’ to ‘No’.

  • Avatar photoCustomer

    And for the Excel file itself?

  • Support Enginatics

    To prevent the SQL from appearing on the parameter tab of the XLSX output file, set ‘Blitz Report Include SQL in XLSX Output’ to ‘No’.

  • Avatar photoCustomer

    I assume the default for both is ‘Yes’?

  • Support Enginatics

    That is correct. By default, the SQL is included in both the log file and the XLSX output file.

  • You must be logged in to reply to this post.