1. On the User Console server, open File Explorer and navigate to '...\BDNA\User Console\Tools\Tomcat\webapps\bdna\WEB-INF\classes'.
2. Open the file Log4j2.xml in a text editor (e.g., Notepad, Notepad++, etc.).
3. Look for the sections containing SQLLOG, and uncomment them by removing <!-- and -->.
   Original:
   

   </RollingFile>
   	<!--<RollingFile name="SQLLOG"
   			fileName="${basePath}/mondrian_sql.log"
   			filePattern="${basePath}/mondrian_sql.%d{yyyy-MM-dd}-%i">
   
   		<PatternLayout pattern="${LOG_PATTERN}"/>
   		<Policies>
   			<TimeBasedTriggeringPolicy interval="1" modulate="true" />
   		</Policies>
   		<DefaultRolloverStrategy max="1"/>
   	</RollingFile>
   	-->

   After uncommenting:
   

   </RollingFile>
   	<RollingFile name="SQLLOG"
   			fileName="${basePath}/mondrian_sql.log"
   			filePattern="${basePath}/mondrian_sql.%d{yyyy-MM-dd}-%i">
   
   		<PatternLayout pattern="${LOG_PATTERN}"/>
   		<Policies>
   			<TimeBasedTriggeringPolicy interval="1" modulate="true" />
   		</Policies>
   		<DefaultRolloverStrategy max="1"/>
   	</RollingFile>

   Original:
   

   </Logger>
   	<!--<Logger name="mondrian.sql" level="DEBUG">
   	  <appender-ref ref="SQLLOG"/>
   	</Logger>-->

   After uncommenting:
   

   </Logger>
   	<Logger name="mondrian.sql" level="DEBUG">
   	  <appender-ref ref="SQLLOG"/>
   	</Logger>

4. Save the changes made to the file.
5. Restart the Flexera User Console Service for the changes to take effect.
6. After the service restarts, open the User Console application, create a simple report, and wait for the results to populate.
7. Using File Explorer, navigate to '...\BDNA\User Console\Logs'. You should now see a new log file named mondrian_sql.log.
8. Open the log file and scroll to the bottom to find the latest SQL query executed. Use this query to run against the database directly.

NOTE: If the log file does not appear, restart the machine and try again. After gathering the necessary queries, consider commenting out the section in step 3 to disable extra logging. The log file can grow significantly, so you may want to disable the option or manually clear the mondrian_sql.log file periodically.